SID-02199: Problems TWikiSheetPlugin

Status:	Answered	TWiki version:	6.0.2	Perl version:	perl 5.8.8 x86_64
Category:	TWikiSheetPlugin	Server OS:	cent0S 5.3 Linux 2.6.18 64bit	Last update:	9 years ago

The plug completely settled and we JSON dependence but using the plug does not read operators

The code I use is the following:

%TWIKISHEET{ mode="edit" save="0" }%
|  | 16Q1 | 16Q2 | 16Q3 | 16Q4 |
| East: | 163 | 182 | 208 | 193 |
| Center: | 82 | 97 | 126 | 91 |
| West: | 217 | 231 | 294 | 249 |
| Total: | =SUM(B2:B4) | =SUM(C2:C4) | =SUM(D2:D4) | %CALC{$SUM(E2:E4)}% |
| Min: | =MIN(B2:B4) | =MIN(C2:C4) | =MIN(D2:D4) | %CALC{$SUM($ABOVE())}% |
| Max: | =MAX(B2:B4) | =MAX(C2:C4) | =MAX(D2:D4) | =MAX(E2:E4) |

As you can see try also use plug SpreadSheet Plugin syntax nor run

-- Pablo Jovanni Lopez Garcia - 2016-05-10

Discussion and Answer

As documented:

1. TWiki variables in TWiki Sheets are not expanded. That this, they are preserved as is, but that means they do not show the actual value.

That is, if you are not happy with the TWikiSheetPlugin formula syntax, you can use the SpreadSheetPlugin syntax use the mode="classic" in TWikiSheetPlugin.

-- Peter Thoeny - 2016-05-10

Well, but the details are not that syntax to use if not rather do not want to pull any Furmula calculation without the TWikiSheetPlugin and nor the SpreadSheetPlugin

-- Pablo Jovanni Lopez Garcia - 2016-05-10

First of all I think it is important mensionar the following: as the first time we tried to install the plug from bin / configure which we frame mistake but thought it was problem of plugin because another plugin if you let us install which proceeded to install manually by downloading the zip and that's how we start the plugin now that I start as I have been discussing all uses when calculating as I can edit cells and all the detail is that the calculation functions do not work, well then we try to reinstall the plugin from bin / configure and now shows us the following error

-- Pablo Jovanni Lopez Garcia - 2016-05-10

Something very important is that we reliance JSON in version 2.3 and the update by marking in the plugin is 2.9 and that was solved

-- Pablo Jovanni Lopez Garcia - 2016-05-11

Thank you for pointing this out. I updated the CPAN module dependency for JSON >= 2.0.

-- Peter Thoeny - 2016-05-13

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.