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..

I applied current profile related to spreadsheets (as of September 2015) in profiles.t.o:

... https://profiles.tiki.org/Spreadsheet_Test_Profiles

and it does enable the spreadsheet feature and create the intended spreadsheet indeed, but the indicated contents do not seem to get added.

Syntax in that profile page is:
{CODE()}
objects:
-
type: sheet
data:
-
title: Test Title
- [ Test, =A1 ]
- [ =B2, =B1 + A1 ]
{CODE}

I tried with 12.x and 14.x with same results.

Maybe something needs to be tweaked in the profile handler code?:
{CODE()}
/lib/core/Tiki/Profile/InstallHandler/Sheet.php
{CODE}

In trunk (future tiki15) it also fails to add the data to the sheet. Help is needed. {sign user="xavi" datetime="2015-12-31T14:33:57+00:00"}

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

{BOX()}
14.x: export sheet produced WSOD (blank page). this used to work. (9.x, and 12.x)

error:
Fatal error: Call to a member function sheet_history() on a non-object in /var/www/xavi-9794-5723/tiki-export_sheet.php on line 48

And reproduced here:
https://doc.tiki.org/tiki-export_sheet.php?sheetId=2
(as registered user)

We need export this sheet from doc.t.o because it's the documentation of the feature, and we need a way to easily clone it in a trunk install, or tiki 12, to test regressions, etc.
{BOX}
Issue fixed in r57088 (trunk) and r57089 (14.x). {sign user="xavi" datetime="2015-12-31T15:54:46+00:00"}

However, when exporting in CSV format (either pure CSV, or Excel-CSV format), content is stored as "Array, Array, Array..." (as many times as values) {sign user="xavi" datetime="2015-12-31T15:54:46+00:00"}

Reproduced here:
http://xavi-9794-5723.show.tikiwiki.org/tiki-export_sheet.php?sheetId=1
u: admin
p: 12345

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.

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

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.

__Hey there Tikiwiki dev team !__

I've been looking all over for info about this, but even on the irc channel, no one seems to know what to do about my issue : I'm pretty new to all this, and I enabled spreadsheets in my tikiwiki platform. I can list spreadsheets, create new ones, edit them.

I chose a jquery theme that allows a pretty good display in spreadsheet (I can see multiple selections, all menus are displayed correctly). Only trouble is : none of the menus in the three drop-down menus in the upper-left corner (edit/view/style) seem to operate.

''__Other contextual menus__'' (when right-clicking on the sheet, or in the column labels) ''__work fine__'', but when I click any of the three above-mentionned buttons (edit/view/style), even though the submenus are displayed, ''it doesn't seem like I'm acutally clicking anything'' : nothing happens, and it doesn't "feel" like my clicking is even registered.

I have tried on my current platform which runs on Ubuntu in a Virtual Machine, I've also tried on the online 15.0 demo platform you provide on your website, and another person from your IRC has also tried and we all get the same result.

So I thought maybe you guys could help ?

thank you very much in advance,

Have a wonderfuk day,

Kind regards,

Nicolas AINETO.

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 ( ))

Intention is to (ab-)use SpreadSheets as replacement for really _BIG_ text tables, which otherwise would be too ugly to work with in regular tiki tables.

Adding "little" content works OK, but at some point the saved cell is cleared when too much content is put in the edited cell.

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.

See: https://tiki.org/forumthread51287
---
Addendum: Make a plugin in Tiki to display the basic d3.js-based charts already developed in the past (in through PluginChart or other means)

Related: https://dev.tiki.org/item6263 - Make PluginChart optionally reuse some other lib already in Tiki to make js-based charts (raphaeljs, chartjs, d3.js, etc)

See:
https://dev.tiki.org/Data+Visualization#d3.js

Basic d3.js-based charts already made in Tiki:
http://marclaporte-11197-5155.show.tikiwiki.org/
u: admin
p: 12345

display a single chart with plugin sheet fails (with mode simple=y or n)

Related to this other bug report:
https://dev.tiki.org/item6265 - "Page with many PluginSheet calls should respect their own uses of parameter 'simple=y/n' "

After bug6265 is fixed, you now display only the sheet which were displaying charts normally, but when shown in mode "simple=y" charts are not shown.

Well, in fact, chart is not shown even if simple=n.

How complicated is it to get the charts shown?
See:
* http://xavi-9794-6265.show.tikiwiki.org/tiki-index.php?page=Spreadsheet-demo-instructions#Show_Only_Charts
* http://xavi-9794-6265.show.tikiwiki.org/tiki-index.php?page=Spreadsheet-demo-instructions#Display_only_One_Chart
u: admin
p:12345

Thanks!

I printed in 20.x a tiki spreadsheet to pdf through mpdf (installed through the packages control panel), with the spreadsheet param -+simple=y+-

The printed sheet in the pdf page didn't display borders of rows and cols by default, which makes it difficult to distinguish rows or cols in some cases.
When choosing the print version of the wiki page, the cell borders where shown, and when printed locally through a locally installed pdf printer in the desktop computer, the borders where included in the pdf.

Is it difficult to add by default when making the pdf from mpdf directly? Or document somehow how to hack the code to add some custom css in the pdf files generated through mpdf?

Reproduced here:
http://xavi-9794-7140.show2.tikiwiki.org/tiki-index.php?page=Spreadsheet-demo-instructions
u: admin
p: 12345

See pdf generated here:
http://xavi-9794-7140.show2.tikiwiki.org/tiki-download_file.php?fileId=1

First sheet has simple=y, and borders are not shown.
Second sheet in the same page has simple=n, and borders are shown

Spreadsheets in doc.t.o (using 12.x r48406) are displayed with large blank bottom section and rows out of sync with row numbers.

See example here:
https://doc.tiki.org/tiki-view_sheets.php?sheetId=1

{img fileId="582"}

When you click at edit sheet, rows are in sync with row numbers, but the extra empty space at the bottom is still shown.

-----

See also http://dev.tiki.org/item4923 it is closed since its a duplication of this report

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 )

Scenario: Estimating a line formula Y = mX + c

Steps:
1. Create a spreadsheet.
2. In cells A1, B1, type in some numerical values, e.g.: 2.53 and 32.785 We will use them for constants m, c.
Note: can be any other value.
3. In column A, type in some (5) numerical values, starting row A2 to A6
4. In cell B2, type the formula "=$A$1*A2+$B$1" without the quotes. Then press Enter.
You should get the value of the equation.
5. Next try to replicate the formula in cell B2, by dragging the small square icon at the bottom-right corner of the cell (like you would do in Excel spreadsheet). Drag till B6.
6. Formula should be replicated and numerical values should show.

Error 1:
You get error message in the cell: Error: Parse error ... ----^Expecting '('

Error 2:
The cells to be replicated by dragging the formula have incorrect formula of type "=ANaN*B3+ANaN"
Edit --> Undo does not work. The error values in the cells cannot be removed by click on Edit --> Undo

This is a major drawback of the Spreadsheet feature. Reduces considerably, the usability of this important feature.

Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart

Reproduced when attempting to export sheet4 in doc.t.o, which is part of the sample charts generated from the tiki spreadsheet feature:
https://doc.tiki.org/tiki-export_sheet.php?sheetId=4

When exported (as csv with comma, and utf8) the content is like:
{CODE(colors="htmlmixed")}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13),<div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1,4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13),<div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116,,6,Feb,2002
Pie,"=LINECHART(D2:D8, F2:F6)",<div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A,7.2,Mar,2003
Line,"=PIECHART(D2:D8, E2:E8)",<div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5,7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

And in my honest opinion, it should be something like:
{CODE()}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13)",=BARCHART(D2:D13),4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13)",=HBARCHART(D2:D13),6,Feb,2002
Line,"=LINECHART(D2:D8, F2:F6)",=LINECHART(D2:D8, F2:F6),7.2,Mar,2003
Pie,"=PIECHART(D2:D8, E2:E8)",=PIECHART(D2:D8, E2:E8),7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

{syntax type="tiki" editor="plain"}
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.