Loading...
 

Category: Spreadsheet

Spreadsheet
Show subcategories objects

Name Type
/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..
tracker item
1.10: possibly confusion in category vs. object permissions behavior
I wonder if this is a bug, or just some conflict of configuration, since the recent changes on category permissions.

This site: http://uniwiki.sima.ourproject.org is using a 1.10 from december 2007 (after some recent changes whre introduced in categories: see [http://doc.tikiwiki.org/Tikiwiki+1.10] )

I realized right now that my students (registered users with a couple of extra persmissions) could edit the Tiki sheets on that site (exemple: http://uniwiki.sima.ourproject.org/sheet14 ; private site: Sylvie has an account as admin on that site, and also to login through ssh to the server, if needed to test on site)

However, registered users didn't have any special perm. related to sheets, but the gneral perm to see categorized objects was given to registered.
No local perms to that sheet (or most others), but even so, students could edit them.

I had to add local perms to each sheet to avoid letting them edit the sheets.
I thought that without the global perm to edit sheets assigned to registered, it would have been enough to protext those sheets. Maybe this is some conlfict with the new perms. "tiki_p_edit_categorized"?.
tracker item
12.x - 15.x: Sheet profile Handler doesn't get sheet content added (following lastest available documentation)
tracker item
Caldrac
Contributors
tracker item
14.x & 15.x & doc.t.o: export sheet as CSV produces 'Array, Array, Array....'
tracker item
Sheet: Boolean expressions display wrong
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.
tracker item
eclvvin
Contributors
tracker item
omstefanov
Contributors
tracker item
4.0: editing tiki sheets at tw.o don't keep the changes made
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
tracker item
A SheetID is required shown when attempting to edit a sheet with jquery.sheet
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.
tracker item
A SheetID is required shown when attempting to edit a sheet with jquery.sheet
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.
tracker item
Add data from trackers in sheets
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.
tracker item
add jquery sheet plugin to tiki spreadsheets
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.
tracker item
Additional menus in spreadsheet do not operate
tracker item
Attempting to create a tikisheet results in DB error
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 ( ))
tracker item
cells in feature "spreadsheet" go blank when overflowed
tracker item
check for dependencies in (jquery) sheets and show some hint about using it when in spreadsheets
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.
tracker item
D3.js support in Tiki
tracker item
display a single chart with plugin sheet fails (with mode simple=y or n)
tracker item
Display row and col borders by default when tiki spreadsheets are printed in simple mode with mpdf
tracker item
doc.t.o 12.x: Spreadsheets displayed with large blank bottom section and rows out of sync with row numbers
tracker item
Editor can not create a Tiki Sheet
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 )
tracker item
Editor can not create a Tiki Sheet
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 )
tracker item
Errors in copying formulas with constants in spreadsheets
tracker item
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
tracker item
Export spreadsheet not working - I know how to fix
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.
tracker item
Fatal error in Spreadsheet:graphics
tracker item
fix sheets created directly from wiki SHEET plugin within wiki pages for managing tables visually
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.
tracker item
import csv not working
tracker item
insert column or row in spreadsheet requires ajax to work in 3.3, and broken in tiki 4.0
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...
tracker item
integrate a schedule coordination tool in tiki like doodle
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.
tracker item
integrate a schedule coordination tool in tiki like doodle
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.
tracker item
Issue with the back button (maybe not related to the spreadsheet-function)
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.
tracker item
Some of the Spreadsheet settings do not get saved.
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:
tracker item
Integration data from spreadsheet.
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
tracker item
MEbneter
Contributors
tracker item
Exporting Spreadsheets as csv
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.

tracker item
Trackers: have a spreadsheet view for multiple edits at once, and to use fill down and copy-paste from another Spreadsheet app
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.
tracker item
Spreadsheet formulas not working in Tiki 9

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
tracker item
Report shows html code in spreadsheet cells
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"}
tracker item
Wrong creation and modification date in spreadsheets' list
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
tracker item
Main Feature
Features Classification
tracker item
Layout & colors in TikiSheets are not 3.0 ready with strasa (see them in dev.tw.o)
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
tracker item
Make PluginChart optionally reuse some other lib already in Tiki to make js-based charts (raphaeljs, chartjs, d3.js, etc)
tracker item
More predefined mathematical functions
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 ...)"


tracker item
natokpe
tracker item
No email notification when table changed or watch ability
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.
tracker item
Page with many PluginSheet calls should respect their own uses of parameter 'simple=y/n'
tracker item
Page-ability with large spreadsheets
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.
tracker item
PHP errors using speadsheet in release 15.0 (not 15.0alpha)
tracker item
pie chart didn't work for me
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]
.
tracker item
Plugin Sheet data after TikiSheet is deactivated
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 "

tracker item
PluginChart doesn't produce the expected chart, just the legend
tracker item
recent 1.10cvs might have conflicts with some features
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.
tracker item
Save icon doesn't work, redirects back
Clicking "Save" icon in toolbar doesn't work.
tracker item
sheet graph engine fatal error (timeout) - abstract.gridbased.php on line 444
tracker item
sheet history: wrong diff + attributes changed cell to the old date instead of new
tracker item
Sheet: Boolean expressions display wrong
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.
tracker item
Sheets do not place charts properly (almost hidden, in doc.t.o sheet intended for documentation)
tracker item
simple multiline chart (tikisheet) produces many errors and no chart
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?
tracker item
Spreadsheet : No way to see the history of a sheet
tracker item
Spreadsheet : You cannot export or import a spreadsheet.
tracker item
Spreadsheet Column Headers don't match Column sizes in Full Screen mode
tracker item
Spreadsheet readily divides by zero
tracker item
Spreadsheet: Dropdown menus are in background
tracker item
Spreadsheet: Fullscreen view + compare without function
tracker item
Spreadsheet: History ignores date/time prefs
tracker item
Spreadsheet: Illogical edit options
tracker item
Spreadsheet: Potential CSS regression in Tiki12, with line-height
tracker item
Spreadsheet: update to latest stable version
tracker item
Spreadsheets testing for Tiki16
tracker item
styles in spreadsheets apply to whole cells rather than text parts of a cell
tracker item
tiki-graph_sheet.php?sheetId= produces WSOD
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
tracker item
tiki-list_object_permissions.php -> Needs tabs for missing features
tracker item
tiki-sheets.php layout is not ready for 3.0 (left column goes to the bottom)
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.
tracker item
TikiSheet doesn't remove or add columns
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."
tracker item
TikiSheet Enhancement: Clone feature
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
tracker item
tikisheet shows old sheet data (n-1) just after saving changes to version n
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.
tracker item
TikiSheet table won't dispaly in Wiki page
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."
tracker item
TikiSheet: a few bug and some minor enhancements
see ((tw:TikiSheetDev)) Louis-Philippe Huberdeau
tracker item
Too much loading when going into edit mode
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.
tracker item
Two most recent versions in the spreadsheet history should be pre-checked
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
tracker item
Unified Index: Add spreadsheet
tracker item
View a Spreadsheet in Mobile mode: tiki complains infinitely that jquery_ui is not enabled
tracker item
xavi
Contributors
tracker item

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.

Accessibility (WAI & 508)
Accounting
Administration
Ajax
Articles & Submissions
Backlinks
Banner
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Calendar
Category
Chat
Comment
Communication Center
Consistency
Contacts Address book
Contact us
Content template
Contribution
Cookie
Copyright
Credits
Custom Home (and Group Home Page)
Database MySQL - MyISAM
Database MySQL - InnoDB
Date and Time
Debugger Console
Diagram
Directory (of hyperlinks)
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
DogFood
Draw -superseded by Diagram
Dynamic Content
Preferences
Dynamic Variable
External Authentication
FAQ
Featured links
Feeds (RSS)
File Gallery
Forum
Friendship Network (Community)
Gantt
Group
Groupmail
Help
History
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
jQuery
Kaltura video management
Kanban
Karma
Live Support
Logs (system & action)
Lost edit protection
Mail-in
Map
Menu
Meta Tag
Missing features
Visual Mapping
Mobile
Mods
Modules
MultiTiki
MyTiki
Newsletter
Notepad
OS independence (Non-Linux, Windows/IIS, Mac, BSD)
Organic Groups (Self-managed Teams)
Packages
Payment
PDF
Performance Speed / Load / Compression / Cache
Permission
Poll
Profiles
Quiz
Rating
Realname
Report
Revision Approval
Scheduler
Score
Search engine optimization (SEO)
Search
Security
Semantic links
Share
Shopping Cart
Shoutbox
Site Identity
Slideshow
Smarty Template
Social Networking
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Staging and Approval
Stats
Survey
Syntax Highlighter (Codemirror)
Tablesorter
Tags
Task
Tell a Friend
Terms and Conditions
Theme
TikiTests
Federated Timesheets
Token Access
Toolbar (Quicktags)
Tours
Trackers
TRIM
User Administration
User Files
User Menu
Watch
Webmail and Groupmail
WebServices
Wiki History, page rename, etc
Wiki plugins extends basic syntax
Wiki syntax text area, parser, etc
Wiki structure (book and table of content)
Workspace and perspectives
WYSIWTSN
WYSIWYCA
WYSIWYG
XMLRPC
XMPP




Useful Tools