Reply to topic

How do I define a function? (replace Names in Excel)

gefagan
Registered Member
Posts
14
Karma
0
OS
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
gefagan
Registered Member
Posts
14
Karma
0
OS
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
airdrik
Registered Member
Posts
1720
Karma
5
OS
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.


airdrik, proud to be a member of KDE forums since 2008-Dec.
sebpe
Registered Member
Posts
49
Karma
1
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)

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], claydoh, Google [Bot], jsalatas, kinghat, ngraham, npeter, Sogou [Bot], vinnywright, Willov