Question

I installed TWiki newly and the SpreadSheet plugin. When I try to make a simple spreadsheet the preview page looks O.K. but after saving changes all SpreadSheet functions ($SUM, $ABOVE, etc.) disappear. A small example:

| | *Spent* | *Budget* | *Left* |
| books | -30 | | |
| confs | -1000 | | |
| *Total* | %CALC{"$SUM($ABOVE())"}% | 2000 | %CALC{"$SUM($LEFT())"}% |

When I save changes I get this on the screen:

In the text, there are only empty formulas %CALC{"(())"}%.

I have found a workaround: if I add a backslash in front of every dollar the functions survive, but the backskashes are eaten, and when I edit the page again they must be added anew.

• TWiki version: 01-Sep-2001 Release
• Web server: Apache 1.3.14
• Server OS: SPARC/Solaris 7
• Web browser: Netscape 4.78
• Client OS: SPARC/Solaris 7

-- HanaSkoumalova - 22 Oct 2001

Answer

This is very odd. Did you look how the saved file looks like? Does it have the correct formula or empty %CALC{"(())"}%? Are there any other plugins besides the Default plugin?

Try also to enable debug for the SpreadSheetPlugin and check what you get in the debug.txt file.

-- PeterThoeny - 23 Oct 2001

The text contains %CALC{"(())"}%. Beside Default plugin, there is InterWiki plugin installed.

Currently, I am not at my place, so I can't try debugging, I will do that the next week.

-- HanaSkoumalova - 24 Oct 2001

I managed to collect some debugging data. Actually, when I edited the SpreadSheetPlugin page (to enable debugging) it got corrupted as well. The file spread-debug.txt contains relevant information on operations on that page.

-- HanaSkoumalova - 24 Oct 2001

Yesterday, I tried this plugin on my home machine (Linux with Apache and Netscape) and everything works O.K. I also collected some debug information, which is attached in files spread-linux.txt and spread-solaris.txt. It seems that there is something wrong with rcs on Solaris (the line Store: rev = 1.1 is missing), but after saving changes I do get a new version.

-- HanaSkoumalova - 05 Nov 2001

Sorry, where is the answer to my question? How do I make my twiki installation show spreadsheets correctly?

-- HanaSkoumalova - 11 Dec 2001

I don't know the answer. The only thing I can suggest is to upgrade to a newer version of Perl and CGI.pm.

-- PeterThoeny - 11 Dec 2001

I have discovered that this error was caused by a module mod_html. It is a third-party module for Apache used for serving the proper language and encoding version of a document. I have sent a report of the bug to the author of the module.

-- HanaSkoumalova - 19 Feb 2002