Category: Spreadsheet

Missing Spreadsheet, Articles, Blog, Calendar, etc

Need to add Tabs for these objects to display their object permissions

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

Searching in spreadsheets is important :-)

View a Spreadsheet in Mobile mode: tiki complains inifinitely that jquery_ui is not enabled

You enable it, try again, and you get the same error message.

If you switch to non-mobile mode, the tiki sheet is there as usual. But when you switch back to mobile mode, you get the same error again.

If you visit the admin panel "Features", "Interface" tab, you can see that jquery_ui is disabled indeed in Mobile. However, if you switch to non-mobile mode, jquery_ui is shown as enabled.

In mobile mode, as a reference, these seem to be the css libraries loaded (no jquery-ui) when attempting to view a spreadsheet:
{CODE()}
<link rel="stylesheet" href="vendor/jquery/photoswipe/photoswipe.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/jquery-mobile/jquery.mobile-1.3.2.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/plugins/treetable/stylesheets/jquery.treetable.css" type="text/css" />
<link rel="stylesheet" href="styles/mobile.css" type="text/css" />
{CODE}

When in non-mobile mode, these are the ones loaded (they include jquery-ui):
{CODE()}
<link rel="stylesheet" href="css/cssmenus.css" type="text/css" />
<link rel="stylesheet" href="vendor_extra/elfinder/css/elfinder.full.css" type="text/css" />
<link rel="stylesheet" href="vendor/codemirror/codemirror/lib/codemirror.css" type="text/css" />
<link rel="stylesheet" href="lib/codemirror_tiki/codemirror_tiki.css" type="text/css" />
<link rel="stylesheet" href="temp/public/codemirror_modes.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/jquery-ui-themes/themes/flick/jquery-ui.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/jquery-timepicker-addon/dist/jquery-ui-timepicker-addon.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/plugins/cluetip/jquery.cluetip.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/plugins/colorbox/example1/colorbox.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/plugins/treetable/stylesheets/jquery.treetable.css" type="text/css" />
<link rel="stylesheet" href="vendor/jquery/jquery-sheet/jquery.sheet.css" type="text/css" />
<link rel="stylesheet" href="styles/fivealive.css" type="text/css" />
{CODE}

Te reproduce, login to view this spreadsheet here:
http://xavi-9794-4985.show.tikiwiki.org/tiki-view_sheets.php?sheetId=1

u: admin
p: 12345

Click at Switch to mobile mode. Done.
---
UPDATE: Closing item as outdated, since Tiki 15+ doesn't have this issue due to Bootstrap. {sign user="xavi" datetime="2017-01-29T14:37:58+00:00"}

{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