Category: Spreadsheet

Formerly the sheet got displayed, when going to /tiki-view_sheets.php - it's not like that any more. I can edit it perfectly, etc. - but it doesn't get shown..

Contributors

In TikiSheet: I'm trying to have 'T' or 'true' shown when two other columns have the same value. But =(H3==K3) when saved shows "true=(H2=". Note the truncation; the truncated stuff shows up in the expression field on the edit screen. Before being saved the cell shows 'true'. Adding a conditional ("?:") expression wrapper did not help.

Also, a spreadsheet could not have rows added to it until a similar expression was removed from the spreadsheet.

Contributors

Contributors

editing tiki sheets at tw.o don't keep the changes made (no error nor warning message shown; everything apparently ok). But no sign of the changes made, not in the sheet, nor in the history of tiki sheet.

Example:
http://tikiwiki.org/tiki-view_sheets.php?sheetId=1

I did edit it as user "xavi", add some info the cell A2, save, and no record of the changes.
Looking at the tiki sheet history, nothing is shown either about the edit.

See a related post of users reporting other problems with tw.o sheets since tiki 4.0 (I couldn't reproduce their problem, though).
http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=21908#threadId35330

Using latesst trunk from today (Feb 1st 2010). Installed a new tiki, enabled tikisheets, created one. Edit it and save changes.

Then enable jquery.sheet through Admin > Look & Feel > interface (or whatever name, I don't remember) > tick the jquerty sheet checkbox. also enable ajax.

Create another sheet. Edit it with jquery.sheet, and it , and "A Sheet Id is required" type of message (or something similar) was shown.

I remember it worked for me weeks ago, when I tested the first commits by jonny with jquery.sheet in trunk. But nowadays, it doesn't work for me.

Very similar to this bug that was fixed in Version 5:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=3017&trackerId=5&show=view

Unfortunately, our host does not support version 5 yet, so I am dead in the water unless this same issue gets addressed in version 4.1

Basically, you can create sheets, but whenever you try to edit them, simply clicking on any of the links (Insert, Remove, etc.) causes a redirect to an error page stating: "A SheetId is required."

I haven't been able to import simple spreadsheets either, but that's another issue.

An idea expressed by Mike Kerr (Kerrnel22) at the Nov 2008 Montreal TikiFest:

To include tracker output data in the spreadsheet. This would help make very flexible reports, with charts.

Nowadays that JQuery has been added to 3.0svn, there is big opportunity ("low hanging fruit"?) for improving the usability of tiki spreadsheets, adding (optionally, of course) one better interface for spreadsheets through jquery plugins.

My proposal is __jQuery.sheet__:
http://plugins.jquery.com/project/sheet

http://jqueryplugins.weebly.com/jquerysheet.html

demo:
http://jqueryplugins.weebly.com/uploads/3/1/3/8/313814/jquery.sheet.html

This would improve the editing UI (for sheets), as well as big tables, if created and managed through the plugin SHEET directly from the wiki page, as drawing could be created previously.

Trying to create a spreadsheet results in DB error.

Incorrect integer value: '' for column 'parentSheetId' at row 1

La requête était :
INSERT INTO `tiki_sheets` ( `title`, `description`, `author`, `parentSheetId` ) VALUES( ?, ?, ?, ? )

Valeurs :

Probo
admin

La requête construite était probablement :
INSERT INTO `tiki_sheets` ( `title`, `description`, `author`, `parentSheetId` ) VALUES( 'Probo', '', 'admin', '' )

Stacktrace :
* C:\inetpub\wwwroot\tiki\7.2\tiki-sheets.php : 0 -> {main}(array ( ))
* C:\inetpub\wwwroot\tiki\7.2\tiki-sheets.php : 98 -> replace_sheet(array ( ))
* C:\inetpub\wwwroot\tiki\7.2\lib\sheet\grid.php : 2358 -> query(array ( ))
* C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb\Bridge.php : 29 -> query(array ( ))
* C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb\Pdo.php : 120 -> handleQueryError(array ( ))
* C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb.php : 150 -> handle(array ( ))

Using latest trunk from today (Feb 1, 2010)
Installed blank new tiki site, enabled tiki sheets.
Wishes:

(1) When adding a new sheet, some hint could be shown about the chance to use jquery.sheet interface.

I enabled jquery.sheet plugin, but not ajax.

(2) If ajax is required for jquery.sheet to work (that's what I've been told, but I don't know for sure myself), jquery.sheet should report that ajax is needed and show a link to enable it.

User with Editor plus sheet edit permission tried to create a Tiki Sheet in v2.0RC4 -Arcturus-.

An error occured in a database query!

Context:
File tiki-sheets.php
Url tiki-sheets.php
Query:
INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( ?, ?, ? )
Values:
0 testsheet
1 this is a test
2 NULL
Message:
Column 'author' cannot be null
Built query was probably:
INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( 'testsheet', 'this is a test', NULL )

User with Editor plus sheet edit permission tried to create a Tiki Sheet in v2.0RC4 -Arcturus-.

An error occured in a database query!

Context:
File tiki-sheets.php
Url tiki-sheets.php
Query:
INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( ?, ?, ? )
Values:
0 testsheet
1 this is a test
2 NULL
Message:
Column 'author' cannot be null
Built query was probably:
INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( 'testsheet', 'this is a test', NULL )

I tried to export a sheet that I made and it didn´t work anyway. But I compared tiki-import_sheet.php and tiki-export_sheet.php and I found the error.

Spreadsheets can be created directly through wiki SHEET plugin directly within wiki pages. this allows managing big tables visually, as well as having the data ready for producing graphs, etc. (see documentation for tikisheets at doc.tw.o, if needed)

However, when you create a sheet through a call to the SHEET plugin from the wiki page itself, there are 3 issues which need to be fixed:
# you need to know the id you want to assign it to,
# after that, tiki-sheets.php doesn't list it (even if the sheet is really created, and you can import data to it, and show it at the wiki pages, etc.).
# the sheet is not shown with the right css

Even if we have wysiwyg option available, I still think that is worth improving tiki sheets usability to be used directly from wiki pages, once those 3 previous issues are fixed.
---
Updated on Feb. 2, 2011, using trunk (7svn)
# Steps to reproduce the first issue
## Edit a wiki page
## Use the plugin helper to create a new sheet in that page. And since it's a new sheet, it doesn't have a sheetId yet, so that you leave all fields empty in the plugin helper for the pluginsheet
++ this will add this type of code in your wiki page:
++ {CODE()}{sheet}{CODE}
## Save the wiki page
++ you will see an empty sheet shown in place at that wiki page, with the button at the bottom to allow the user to "edit it" (so far, so good)
## Once you click in the edit sheet button, you end up in some url like this one:
++ http://localhost/tiki7trunk/tiki-view_sheets.php?sheetId=&parse=edit
++ which produces a WSOD (blank page).
*** In my case, I guess that this url should have been:
+++ http://localhost/tiki7trunk/tiki-view_sheets.php?sheetId=2&parse=edit
+++ since I had only one sheet previously created, with sheetId 1, so that the next one should be 2. However, this new url is still producing WSOD for me. (tiki caches cleared, just in case, repeated this step, and same WSOD)

The expected behavior is that the user is the user would be editing a blank new sheet with the url:
http://localhost/tiki7trunk/tiki-view_sheets.php?sheetId=2&parse=edit

and when the user saves that sheet, the new sheetId 2 exists, and the user is either sent back to the wiki page where he clicked at the button "edit sheet" (preferable option) or either sent to the corresponding tiki view sheet 2.

See bug reported and confirmed in tw.o forums:

http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=35420

To reproduce (in tiki 3.3 without ajax, and in tiki 4.0 regardless of ajax setting):

^ 1. create a sheet
2. click insert column (or row)
3. fails with error msg "A SheetId? is required." ^

In Tiki 3.3, this misbehavior dissappears when you enable ajax.
In tiki 4.0, no way to make it work.

It used to work in tiki 2.x, afaik...

In groups of people you often have the problem to find day/time when all the people have time to meet.

Especially if they are not in the same room.
And even if they are present its difficult to talk about all the pro and cons when is the best time.


http://www.doodle.com/
Is offering an easy solution. Everybody marks the spots when he has time. Doodle comes up with a proposal, when is the best time to meet. No discussions, every vote has the same weight, non-party and you can always reproduce how the decission was formed.

Can we integrate something like this? Especially because the Tiki direction goes more in decision making.
That feature would fit perfectly in.

In groups of people you often have the problem to find day/time when all the people have time to meet.

Especially if they are not in the same room.
And even if they are present its difficult to talk about all the pro and cons when is the best time.


http://www.doodle.com/
Is offering an easy solution. Everybody marks the spots when he has time. Doodle comes up with a proposal, when is the best time to meet. No discussions, every vote has the same weight, non-party and you can always reproduce how the decission was formed.

Can we integrate something like this? Especially because the Tiki direction goes more in decision making.
That feature would fit perfectly in.

Issue with the back button (maybe not related to the spreadsheet-function):

I check the version history of the Spreadsheet and compare the two latest versions (works fine). But when I try to use the button "back" I get an empty error message. When I choose OK I get the same message. I am forced to use "cancel". When I instead use the back button in the web reader everything works fine and I can return to the version history. I use firefox 3.6.3.

The following settings do not get saved when you create a new sheet or configure an already created sheet.

Class Name:
Header Rows:
Footer Rows:
Wiki Parse Values:

Hello!

I just updated to tiki 8.2 and found the problem with data integration from spreadsheets to wiki pages. I did the upgrade to tiki 8.1 before that and there was a problem mentioned in release notes that "Spreadsheets cannot be viewed (via view_sheets). The table quickly disappears when the page loads. Spreadsheets can nevertheless be viewed by editing them, if the user has the appropriate permission." Same thing happened when you integrated cells in wiki page. In 8.2 that problem was fixed, but now whet i type something like

{CODE(colors="c")}''Telephone number:'' | {SHEET(id=>4 range="A6:A6")}Table{SHEET}{CODE}

on wiki page in result I get the whole table showed like in default mode without range instead of only one cell. I tried to find something about changes in module or so, cause may be syntax changed, but no success. In 7.2.1 everything works just fine.

Thanks in andvance
Devox

In the version 8.3 there are some errors if one wants to export a spreadsheet

The first one appears if one click on the export button. An error () shows up.
I have tried to fix it by inserting the code
"$sheetlib = TikiLib::lib("sheet");" at the line 11 of the "tiki-export_sheet.php" file.

After this fix the export menu appears but exporting the spreadsheet as csv file does not work. (exporting as V 1.0 does not work either, exporting as TikisheetFile V.1 seams to work)
For the case of exporting as csv: After clicking on the "Export" button, the browser ask for saving the file. Depending on the option I choose for saving ("Save as" or "DownloadThemAll") different behavior are observed:
* Save as: A file of 0kB is downloaded (for info the .tws file as 141kb)
* DownloadThemAll an "Server error*" error is shown in the program.

Say I have a desktop spreadsheet file. I can copy-paste this to Tiki spreadsheet and it makes it fun & fast to move data to Tiki. (It's also easy to export to .csv to re-use in the desktop spreadsheet).

But what if I want my info in a tracker?

((doc:PluginTrackerList)) has displaysheet=y which displays in spreadsheet view. This is nice but we'd need to be able to edit existing records, and easily add records.

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

Some fields display html code in the spreadsheet cells:
Like:

{CODE()}
Identificació - 319 ItemId - 320
<span class="hdrField" data-level="3" style="display:none;"></span> 1596
...
{CODE}

See screenshot here:
{img src="display66"}

The first column is a self-numbering field type, as main field (linked from the list to the item), and the one that says "Etiquetes lliures" refers to tags, which show hyperlinked tags, etc.
---
UPDATE: Still happening in 12.x {sign user="xavi" datetime="2013-11-17T08:47:04+00:00"}

In Spreadsheets' overview 'List Sheets' page date for 'Created' and 'Last Modif' are the actual date, not the real dates assigned to a sheet.

See:
http://fmg-11537-4338.show.tikiwiki.org/tiki-sheets.php

Features Classification

Using strasa.css in dev.tw.o, the tiki-sheets.php is not showing the content from both lateral columns.

I attempted to change theme style in dev.tw.o, but it's dead slow right now. and after 4 min. of waiting response from the server, I skip the test with another theme style. At least with strasa. it doesn't display both lateral columns.
----
after dev.tw.o responded (8+ min), I could reproduce the problem also in thenews.css
And the exact url to see the issue is this one:
http://dev.tikiwiki.org/tiki-sheets.php?edit_mode=edit&sheetId=0
---
and colors are not ready either (at least here in dev.tw.o):
See it here
http://dev.tikiwiki.org/tiki-view_sheets.php?sheetId=1

I miss predefined mathematical functions like "Sum(number_1, number_2 ...)"

When the functions are there I would like a help list (like in for example google spreadsheets) that presents possible names on mathematical functions that can be performed. For example: I type "=S" and the cell presents med with a list of alternatives like

"Sign(number)"
"Sin(number)"
"Sum(number_1, number_2 ...)"

I can not find the ability to receive an email notification when a table gets changed.

It would be very useful if this capability were part of tikiSheets. Several other tikiwiki features have this feature through the watch capability.

This will greatly enhance how user's precieve spreadsheets, and will turn Tiki from an afterthought to a mainstream player.
* We will need to switch from regular scrollbars to UI scroll bars to "trick" the user.
* We will need the new calculations engine running in php
* We will need functionality to send a formula to the server and return the result from the currently running sheet and the ability to update cells from it.

I have a tikisheet created (mainly text): 7x7 table, with special characters (é, è, spaces, round brackets)

||Programari | Sistema Operatiu | Llicència |Català |Multiplataforma |Mida (octets) |Funció
WinK |GNU/linux, M$ Windows |Gratuït per a ús no comercial |No (en procés) |Si |100 |Per generar video tutorials
OpenOffice |Linux, Windos, Mac |LGPL | Si |Si |50000
Firefox | |MPL |Si |Si |6000
Thunderbird | |MPL |Si |Si |6000
Gimp | |GPL |Si |Si |2000
Gaim | |GPL |Si |Si |2000 ||

I've just enabled feature_charts, and tried to produce a pie chart, but didn't work for me. I got just the title, and the legend.

The options requested after pie chart is selected, are:
||Títol: | Prova
Series:
label | c1
value | c3:c7
color |
style | ||
(similar to what I saw at the screengrab at [http://tikiwiki.org/tiki-index.php?page=TikiSheetDemo|tw.o sheet demo]
.

When TikiSheet is deactivated but a plugin sheet exists (with previous data), we get a weird error message.

When TikiSheet is deactivated, all sheets and plugin should say " This feature is disabled: feature_sheets "

Attempting to view sheets as a registered user,
http://uniwiki.aia06.ourproject.org/tiki-sheets.php

or a specific sheet, such as
http://uniwiki.aia06.ourproject.org/sheet56

I get 500 error, just after I upgraded 1.10 code on that site. Previous 1.10 code (5 months ago, maybe?) worked fine.

(However, other tikis from the same multitiki installation doesn't show that problem;
http://uniwiki.ourproject.org/sheets is fine for reg. users, for instance)

Sys. admin has reported that the tiki script died for some reason:
{CODE()}
[Tue Apr 10 10:23:40 2007] [error] [client 161.116.71.35] Premature end
of script headers:
/var/lib/gforge/chroot/home/groups/uniwiki/htdocs/tiki-view_sheets.php

(...)

207.46.98.41 - - [09/Apr/2007:20:03:20 +0200] "GET /tiki-sheets.php
HTTP/1.0" 200 29408
66.249.65.78 - - [09/Apr/2007:20:31:18 +0200] "GET
/tiki-index.php/////////////////////////tiki-sheets.php?page=HomePage&comments_parentId=99&comments_maxComments=1&comments_style=commentStyle_threaded
HTTP/1.1" 200 18802
81.177.22.221 - - [09/Apr/2007:23:17:24 +0200] "GET /tiki-sheets.php
HTTP/1.1" 200 36099
66.249.72.180 - - [10/Apr/2007:01:35:03 +0200] "GET /tiki-sheets.php
HTTP/1.1" 200 36099
{CODE}

I'm having problems also at other spots, such as http://uniwiki.aia06.ourproject.org/tiki-admin_actionlog.php , and maybe other places...

I cleaned caches, etc. and same effect.

Clicking "Save" icon in toolbar doesn't work.

In TikiSheet: I'm trying to have 'T' or 'true' shown when two other columns have the same value. But =(H3==K3) when saved shows "true=(H2=". Note the truncation; the truncated stuff shows up in the expression field on the edit screen. Before being saved the cell shows 'true'. Adding a conditional ("?:") expression wrapper did not help.

Also, a spreadsheet could not have rows added to it until a similar expression was removed from the spreadsheet.

I have created a tikisheet: 7x7 table, with some special characters (é, è, spaces, round brackets, comma, ...)

||Programari | Sistema Operatiu | Llicència |Català |Multiplataforma | 2000 |Funció
WinK |GNU/linux, M$ Windows |Gratuït per a ús no comercial |No (en procés) |Si |100 |Per generar video tutorials
OpenOffice |Linux, Windos, Mac |LGPL | Si |Si |50000
Firefox | |MPL |Si |Si |6000
Thunderbird | |MPL |Si |Si |6000
Gimp | |GPL |Si |Si |2000
Gaim | |GPL |Si |Si |2000 ||

I've just enabled feature_charts, and tried to produce a multiline chart, but I just got a 100% blank page .

The options requested after multiline chart is selected, are:
||
Títol: | prova
Independant Scale: | (x) Horizontal ( ) Vertical
Horizontal Scale: | (x) Bottom ( ) Dalt
Vertical Scale: | (x) Left ( ) Right
Series:
label | prova
color | red
style |
x | a1:a7
y0 | f1:f7
y1 |
y2 |
y3 |
y4 ||

(similar to what I saw at the screengrab at [http://tikiwiki.org/tiki-index.php?page=TikiSheetDemo|tw.o sheet demo]
.
But it produces a blank page.
memory limit at php.ini is set to at least 32 Mb, I think (for sure, more than 8Mb or 16Mb)
--------
Updated 6th dec'05:
^
Warning: Division by zero in /var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/graph-engine/abstract.gridbased.php on line 253,

(and idem on: 475, 278, 278, 253, 475, 278, 278, 437)

Fatal error: Maximum execution time of 30 seconds exceeded in /var/lib/gforge/chroot/home/groups/gclub/htdocs/lib/graph-engine/abstract.gridbased.php on line 450^

Still doesn't work for me... :-/
What am I doing wrong?

I created a sheet with this data set:

|| -1 | test
1 | test2
2 | peres
5 | peres
10 | pomes ||

When I click on graph this data sheet (to select type of graph, etc.), I cannot select anything becasue I see a WSOD.

tiki-graph_sheet.php?sheetId=N


Using proposals/3.x r24782

I've just installed a 3.0svn, and while using tiki-sheets.php, the modules in the left column go down , below the height of the central column.

I have just created a list of email addresses and names in tikisheet. When trying to create a new column or delete a column a box pops up saying, "An error occured, inexistant column in grid.getColumn." Then forwards me to an error page which states, "A SheetID is required."

It would be nice if TikiSheet had the ability to clone an already existing spreadsheet. A possibility would be to have a clone button next to the import/export buttons.

Possible functionality of the clone button:
- Create a new table with an new sheetId that has exactly the same contents of the original
- Title of copy could be Copy of 'InsertOrigName'
- If aforementioned Title exists new title could be Copy of InsertOrigName(#) as long as the title containing specific # also does not exist.
- All setting, excluding sheetId, of orig table copied to cloned table

Add data to a sheet. Click save. You'll see the sheet with the data that was there before you added yours.

However, your new data has been stored properly. If you click again in tiki-view_sheets.php?sheetId=N, then you'll see the sheet with your data.

I have created a table filled with contents using TikiSheet. Check that view and admin sheet permission is set. When I create a link in a wiki page pointing to this table, the page did not display the table but only a Edit Table link. I am using 1.9.0. However, when I tried that on the tikiwiki.org site it works fine.

Need to know why it did not work on the 1.9.0.

Pretty similar issue is tw#380 - marked as duplicate - text of it is here:
/tiki-view_sheets.php doesn't display the sheet before clicking on "edit"
Formerly the sheet got displayed, when going to /tiki-view_sheets.php - it's not like that any more. I can edit it perfectly, etc. - but it doesn't get shown..

Thanks to kwow for pointing that out:
"Amette,
It does seems like you have also opened a similar[http://dev.tikiwiki.org//tiki-view_tracker_item.php?itemId=380&show=view&offset=0&reloff=45&status=op&trackerId=5&sort_mode=f_41_desc|bug ticket].

The clickable "edit" link in your bug ticket is exactly the link I an refeering to. Do you think it is worthwhile to combine the same tracker item as one as they are refeering to the same problem we are facing."

see ((tw:TikiSheetDev)) Louis-Philippe Huberdeau

When I click "edit" spreadsheet, it loads twice (a short break in the middle) before entering edit mode.

I have a Firefox version 3.6.3.

When watching the history of a wiki page, the two most recent versions are pre-checked. But, when watching the history of a spreadsheet no versions are pre-checked: http://demo.tiki.org/trunk/tiki-view_sheets.php?sheetId=3