Excel allows Names to stand for an absolute cell range as in Calligra but also for a relative cell or formula to be performed thereon. I have several spreadsheets made in Excel that utilize the latter feature, that say essentially "Do this to the cell on the left". And the thing the formula does is basically a lookup, expressed as a series of nested IF-THEN-ELSE. In other words, I could replace every appearance of FORMULANAME with IF(A1<=1,"Very Low",IF(A1<=2,"Low",IF(A1<=3,"Fairly Low",.. and so forth, making an unreadable mess.

What is the best way to accomplish the same thing in Calligra Sheets? To replace the Name with the nested Ifs as described, or is there a way for a user to define a function without know a scripting language?

If this appears somewhere in the dos or on the forum, what is the term to search for? "user-defined function" came up dry.

Thanks,

GEF

This board's not exactly hopping, and that makes me wonder about the status of Calligra and its user-base. Now that screens are wide but not too high, the idea of putting all the tools on the sides, instead of the top, makes a lot of sense to me, which is why I decided to give it a try, but the support resources seem anemic. So I'm wondering if Calligra's still experimental, needing users knowledgeable to stress the system without needing a manual (which excludes the likes of me) or if it's ready for prime time but facing a chicken-and-egg problem with documentation (and again, I'm not knowledgeable enough to write any - but I'd volunteer to proof-read). -GEF

Different subforums receive different amounts of activity. I'm not sure if the lack of activity in the Calligra forums is indicating lack of use (due to being sub-par compared to LibreOffice or other alternatives) or due to general acceptation that it is good enough for what people use it for.

There was some flurry of activity when Calligra first spun off from KOffice, and I know Calligra is still being actively developed. However, I think most of the attention is on Krita and Kexi now.

I can certainly agree with you on the use of side panels instead of toolbars or ribbons. I think it's a great idea in the age of wide screens to move that stuff to the sides of the screen.
Unfortunately I don't have more feedback as I don't use office tools that much.

Maybe the function MULTIPLE.OPERATIONS is interesting for you.
Say B1: =IF(A1<=20;"low";"high")
To use this formula elsewhere, put e.g. in D1: =MULTIPLE.OPERATIONS($B$1;$A$1;C1)
That means take the formula of $B$1 and replace the parameter $A$1 with C1, so it is the same as D1: =IF(C1<=20;"low";"high")
With this combination of relative and absolute references, copying the content from D1 (the one with the MULTIPLE.OPERATIONS formula) to D2 should still produce the expected result and be equivalent to D2: = IF(C2<=20;"low";"high").

This can be combined with absolute names, so if you name B1 "formula" and A1 "parameter", you could write D1: =MULTIPLE.OPERATIONS(formula;parameter;C1)