Category: Spreadsheet

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 "

PluginChart doesn't produce the expected chart, just the legend

Try to reproduce the example at the documentation, and you'll get the issue reproduced, like in the https://doc.tiki.org/PluginChart

Strategic feature to get Spreadsheets and charts out of them in the game again.

^__Please note:__
This request is to have the png & jpg versions of the charts produced ( see: https://doc.tiki.org/Spreadsheet+Graphics+and+Charts#Select_the_Graphic_Type_and_Output_Format ), not some js based solution (like reusing raphaeljs or chartjs lib, etc.), since this implies an easy solution for charts in PDF reports working automagically without requiring complex solutions to get js-based charts incluided in PDF reports. A different request/wish will be added to add some optional parameter to get the chart produced with some JS lib already in Tiki like the ones cited above.
^

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.

That used to work in 6.x at least.
I created a simple sheet

|| foo | 1
bar | 2
yeah | 3
toto | 4
||

And wanted to create a simple scatter plot. I did select the required options, in [tiki-graph_sheet.php?sheetId=1&graphic=MultilineGraphic&renderer=PNG&format=&orientation=&width=500&height=400&title=Nou+full+de+la+p%C3%A0gina%3AHomePage&independant=horizontal&horizontal=bottom&vertical=left&series%5Blabel%5D=&series%5Bcolor%5D=&series%5Bstyle%5D=&series%5Bx%5D=A1%3AA5&series%5By0%5D=B1%3AB5&series%5By1%5D=&series%5By2%5D=&series%5By3%5D=&series%5By4%5D=|this url]

and got this error message:
{CODE()}
( ! ) Fatal error: Maximum execution time of 90 seconds exceeded in /var/www/12.x/lib/graph-engine/abstract.gridbased.php on line 444
Call Stack
# Time Memory Function Location
1 0.0015 307504 {main}( ) ../tiki-graph_sheet.php:0
2 0.1446 13397672 Graphic->draw( ) ../tiki-graph_sheet.php:160
3 0.1447 13407536 GridBasedGraphic->_drawContent( ) ../core.php:305
4 0.1449 13420336 GridBasedGraphic->_drawScales( ) ../abstract.gridbased.php:51
5 0.1450 13422144 LinearGridScale->getSize( ) ../abstract.gridbased.php:91
6 0.1450 13423168 LinearGridScale->_calculateSkip( ) ../abstract.gridbased.php:435
{CODE}

I've reproduced it in show.t.o
u: admin
p: 12345


* Go to http://xavi-9794-4890.show.tikiwiki.org/tiki-graph_sheet.php?sheetId=1
* and choose multiline
+ {img src="display543"}
* Then add the basic params, as in the screenshot, and click at "show":
+ {img src="display544"}
* Error message:
+ {CODE()}
Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/xavi-9794-4890/lib/graph-engine/abstract.gridbased.php on line 444
{CODE}

I added "foo" to the cell B15 of sheet6 in nextdoc.t.o
https://nextdoc.tiki.org/tiki-history_sheets.php?sheetId=6

The change is shown in the wrong column, the one from 2010 instead of the one at the left from 2013.

Moreover, more cells are shown in green as if they changed, and they didn't.

{img src="display536"}

---
^
Update {sign user="xavi" datetime="2013-11-16T17:20:37+00:00"}:
* AS of Nov 16th 2013 (r48457), the first issue is fixed (change shown in the right column), but second issue is still present:
{QUOTE()}
"Moreover, more cells are shown in green as if they changed, and they didn't."
{QUOTE}

Example: https://doc.tiki.org/tiki-history_sheets.php?sheetId=6
* I just added the missing "C" to the word "COMBINATION", but many other cells are shown in green as if they changed, and they didn't.
^

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.

Sheets do not place charts properly (almost hidden, in doc.t.o sheet intended for documentation)

This used to work in some earlier version of Tiki. (sorry I can't be more precise)

To reproduce, visit:
https://doc.tiki.org/sheet2

and click at tab : "Charts". You will see that at column C Chart, charts are placed to the left, below column B, and therefore, almost hidden.
{img fileId="1016" thumb="y" rel="box[g]"}

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?

when you want to see the history of a sheet, the different versions of the sheet appear and then disappear at the same time. This effect occurs when you reload the page.
I was using Chrome Version 75.0 and Opera Version:60.0

When you want to import or export a spreadsheet to an online or local server, it produces an error. Online, the server produces an error 500 and locally an error message is displayed on the pages __tiki-export_sheet.php__ and on the page __/tiki-import_sheet.php__

in full screen mode, the column headers take the full width of the screen instead of staying the same size as the columns. (see screen shot)

{img fileId="589"}

{syntax type="tiki" editor="plain"}
I can create multiple spreadsheets if i wish.
When I enter data while in edit mode, the data appears in the collect cell.
I then press the save button.
I then press "list spreadsheets"
When I click back into the spreadsheet I want No data is saved.

Tikis spreadsheet readily divides by zero - I expected to get an error message (which I wanted to translate), but I got none. And even more curious: Tiki presents a numerical result from the division by zero, also "0"... !

The correct result would be infinity, but infinity is not a number, it is a behaviour (lim, limes rising above ALL existing numbers) - therefore ALL calculators and calculating spread sheets display an error message upon any division by zero.

{syntax type="tiki" editor="plain"}
When the feature is opened, the spreadsheet grid shows but there's no way to edit it. When I click "Spreadsheet help", this error message displays in the modal:

"Too late to modify headers. Headers already sent by output_headers() called at [/home/tiki-doc/public_html/temp/templates_c/en_social^c65dbf08b2e2cbfd6ac5170dcabfe3af12708efa_0.file_header.tpl.php:441])"

When you extend one of the two drop down menus ("View" and "Style") two things can be observed (besides the fact that View and Style do not translate): The menus are in the background, i.e. ''behind'' the icons... They should extend in the foreground, thus be painted over the icons, partially obscuring them...
Thanks
hman

Clicking on fullscreen view doesn't do anything. No matter wheter you take the small icon in the upper right corner, or the menu item under "View". Nothing happens.

The same goes for comparing two sheets. I have six revisions at the moment, no matter which two I select and click on compare, the page simply reloads, but doesn't do anything else. No comparison visible...

The history of Spreadsheet completely ignores all date und time rendering prefs, and renders timestamps in US format, see screenshot (attachment).

Also note that the "compare" button doesn't translate due to a missing tra().

Spreadsheet has many options. But I wondered why two of the "add" features translated the same, even though they are different. "insert before" and "after".

The reason lies in a logic error in the template (/templates/tiki-view_sheets_menu.tpl), most likely a copy&paste error.

{CODE(Colors="Tiki")}
<li><a onclick="sheetInstance.controlFactory.addRow(null, true); return false;" title="{tr}Inserts an additional row after currently selected row.{/tr}">{tr}Insert Row Before{/tr}</a></li>
<li><a onclick="sheetInstance.controlFactory.addRow(); return false;" title="{tr}Inserts an additional row after currently selected row.{/tr}">{tr}Insert Row After{/tr}</a></li>
{CODE}

Noticed here: https://dev.tiki.org/Tiki12

I am pretty sure Tiki11 was fine. I will make a screenshot of Tiki11 on another site

Perhaps jQuery.sheet should move to Composer and Packagist?

Use: jQuery.sheet 3.0
http://sourceforge.net/p/tikiwiki/code/48315/

Spreadsheets (jquery --s5-- sheets) do not work as expected in a productive environment, even not for use in an internal team.
This is a regression, as they have been working before.

Issue: __The edit menu and it's subitems had no effect (Edit | View | Style).__

--Before considering it a bug I want to test here with a show instance.--
__Tested. Fix needed.__

[http://torsten-11143-6133.show.tikiwiki.org/tiki-view_sheets.php?sheetId=1&parse=edit|try here (show/show => admin/12345)]

Regards,
Torsten

When filling cells with text, you can change color & font of the whole cell, but not single words.
It would be useful to have fully free styling of parts of cell content (to highlight those parts rather than whole cell).

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