Category: Spreadsheet

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

I tried one of the simplest possible spread sheets to try the graph feature. After unfruitful attempts to make it run with bar graphs (always got "invalid series" or after five minutes my ISP timed my Tiki out), I tried a pie chart. With that I immediately got a fatal error:

Fatal error: Call to undefined method GD_GRenderer::httpHeaders() in MYHOMEPAGE/tiki-18.6/tiki-graph_sheet.php on line 131

Attached please see the simple spread sheet I wanted to be plotted as pie chart.

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.

Reproduced here:
http://stirus-11828-6082.show.tikiwiki.org/tiki-sheets.php
u: admin
p: 12345

I tried the following:

1-created a spreadsheet with two columns; row one had headings, row two data
* http://stirus-11828-6082.show.tikiwiki.org/tiki-view_sheets.php?sheetId=1
2-exported the spreadsheet in CSV format, UTF-8 character set
3-renamed the export file
4-edit the exported file with UltraEdit; changed one field; saved with UTF-8
5-created an empty spreadsheet
* http://stirus-11828-6082.show.tikiwiki.org/tiki-view_sheets.php?sheetId=2
6-ran import CSV with UTF-8
7-no data imported, and the sheet just says "Array".

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.

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

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

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

This tracker is made to help filtering and sorting the features vs categories vs options we need to tag a bug/regression/wish with.

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

Make PluginChart optionally reuse some other lib already in Tiki to make js-based charts (raphaeljs, chartjs, d3.js, etc)

By default PluginChart was able to produce these charts:
https://doc.tiki.org/Spreadsheet+Graphics+and+Charts#Select_the_Graphic_Type_and_Output_Format

But it would make total sense to have the option to produce js-based or svg-based charts, like the ones currently produced by the Spreadsheet js feature ( , reuing raphael.js lib), or the ones in theory available in the ((doc:PluginChartJS)) plugin and lib.

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

There is another request to have the png & jpg versions of the charts produced again (they are currently not shown), 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.
This request, though, is to have an some optional parameter added to get the chart produced with some JS lib already in Tiki like the ones cited above. And we will see elsewhere how to ensure that they can be included in the printed PDF, etc.

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.

Page with many PluginSheet calls should respect their own uses of parameter 'simple=y/n'

How to reproduce:
Apply profile ((pr:Spreadsheet demo)), and at the instructions page, many sheet plugin calls have -+simple=y+-, and only one has -+simple=n+-. However, all of the sheet plugin calls in the page inherit the -+simple=n+-

----
See it reproduced here:
Compare the page produced by the profile:
http://xavi-9794-6265.show.tikiwiki.org/tiki-index.php?page=Spreadsheet-demo-instructions
u: admin
p: 12345

with an equivalent page where all sheet plugins where set to simple=y:

http://xavi-9794-6265.show.tikiwiki.org/tiki-index.php?page=Spreadsheet-simple-only

http://xavi-9794-6265.show.tikiwiki.org/tiki-pagehistory.php?page=Spreadsheet+simple+only&newver=0&oldver=2

Please note the different UI surrounding all sheets in the earlier version (the one also coming from the profile: all simple=y but one simple=n )

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.

We use speadsheets in Tiki 12 since several years. Now we migrated two sites running on two different servers from 12.4 to 15.0 and from 13.0 to 15.0

In both cases I cannot view the list of spreadsheets. (already posted in the [https://tiki.org/forumthread59750|forum])

I tried to use the feature in the demo site. The Tiki 15 xersion there is 15.0alpha and spredsheets are running well.

I checked my error log and found
PHP Fatal error: Class 'PEAR' not found in ... /lib/sheet/excel/writer/format.php on line 44

I tried a workaround and inserted before line 44 in format.php
require_once('PEAR.php');
Now I could view and create spreadsheets

I tried to import a sheet from CSV, but it failed with
PHP Fatal error: Call to undefined method TikiSheet::setSize() in ... /lib/sheet/grid.php on line 1234