Spreadsheet formulas not working in Tiki 9
- Status
- Pending
- Subject
- Spreadsheet formulas not working in Tiki 9
- Version
- 9.x
- Category
- Error
- Feature
- Spreadsheet
- Resolution status
- Please retest
- Submitted by
- JustKen
- Lastmod by
- Xavier de Pedro
- Rating
- Description
Hi all,I'm trying to implement tax calculations in a spreadsheet, and I find that the formulas documented in
https://doc.tiki.org/Spreadsheet+jq#New_syntax_for_formulas(external link)
are not working for me, specifically the IF formula. I tried cutting and pasting the formula in the documentation, and it returned an error: Parse error on line 1, with an arrow pointing to the first cell reference.Is there something I have to do to configure my spreadsheet to use the JQuery formulas?
Thanks!
JK
- Solution
- This might be working as expected in recent Tiki versions (12.x, 15.x, 16.x). Can you please retest? Thanks!
- Importance
- 6
- Easy to solve?
- 5
- Priority
- 30
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 4318
- Created
- Friday 19 October, 2012 20:19:01 UTC
by JustKen - LastModif
- Sunday 29 January, 2017 14:42:12 UTC