Formulas processing. about rspreadsheet HOT 7 CLOSED

I have added this functionality few days ago and it is in very untested state. Feel free to test it and let me know any observations. However it is really experimental. Every cell object has a formula setter and getter, where you can set formula (starting with =) as string.

There are several problems with the fucntionality - for example I do not know how to markt the cell "outdated" so next time its value gets recalculated (it is clear that the gem is not able to caluculate the result itself).

from rspreadsheet.

@gorn Thanks. Is that in master? Have you released this in some numbered version?

from rspreadsheet.

@gorn, I found that it is in the master know, but not in the v0.2.7. Thank you! I am going to check it! I'll write you back!

from rspreadsheet.

@gorn, For my purpose of generating formulas in the document it works like a charm!
I am wondering how circumstances coincidence: you have added it right few days before I need it.
That is really awesome!
Thank you a lot!

from rspreadsheet.

Yes it is nice coincidence, on the other hand it is motivating, when I see other people use it as well. :) I have relased v0.2.8 with formulas and I will be releasing v0.2.9 soon, because i just found that there is an issue when rewriteing formula by fixed string. That will be solved, but there is naother mysterious thing in LibreOffice itself - it appears, that each cell has a type, which can be number, string or some other options, but there is not "formula" type and I am not really sure how these two things work together - how one can "guess" from formula what type of value is the result. I was unable to find any docs on this.

from rspreadsheet.

Formula support works fine from me and all tests are passing, so this issue is closed. Feel free to open one if you spot any unexpected behaviour. Version releases as v0.2.9

from rspreadsheet.

@gorn Thank you a lot! 💪

from rspreadsheet.