Documentation: Spreadsheet
See also: Merge Tiki Spreadsheet into Tiki Trackers
Wishes
Open
[-]| Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| (0) | Page-ability with large spreadsheets | robertplummer | 5 | 25 |
| robertplummer | 2011-02-11 | 2011-02-11 | 0 | ||
| (2) | D3.js support in Tiki | Marc Laporte | 7 | 3 | 21 |
| Victor Emanouilov | 2014-02-25 | 2017-01-30 | 7 marclaporte-03 Jun 18 | |
| (0) | No email notification when table changed or watch ability | space_egd | 7 | 35 |
| 2008-12-05 | 2013-06-05 | 0 | |||
| (0) | Trackers: have a spreadsheet view for multiple edits at once, and to use fill down and copy-paste from another Spreadsheet app | Marc Laporte | 6 | 5 | 30 |
| 2012-05-18 | 2013-10-28 | 0 | ||
| (0) | Spreadsheet: update to latest stable version | Marc Laporte | 6 | 5 | 30 |
| 2013-09-10 | 2013-11-14 | 0 | ||
| (0) | Sheets do not place charts properly (almost hidden, in doc.t.o sheet intended for documentation) | Xavier de Pedro | 6 | 5 | 30 |
| 2015-12-31 | 2015-12-31 | 0 | ||
| (0) | import csv not working | stirus | 8 | 7 | 56 |
| 2016-08-09 | 2019-07-01 | 2 drsassafras-28 Jan 17 | ||
| (0) | Spreadsheets testing for Tiki16 | Torsten Fabricius | 8 | 2 | 16 |
| 2016-10-13 | 2017-01-27 | 1 luci-19 Oct 16 | ||
| (0) | Make PluginChart optionally reuse some other lib already in Tiki to make js-based charts (raphaeljs, chartjs, d3.js, etc) | Xavier de Pedro | 8 | 4 | 32 |
| 2017-01-27 | 2017-01-30 | 2 marclaporte-03 Jun 18 | ||
| (0) | 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 | Xavier de Pedro | 8 | 8 | 64 |
| 2017-01-27 | 2017-01-27 | 0 | ||
| (0) | cells in feature "spreadsheet" go blank when overflowed | RadoS | 6 | 30 |
| 2017-02-10 | 2017-02-10 | 0 | |||
| (0) | styles in spreadsheets apply to whole cells rather than text parts of a cell | RadoS | 1 low | 1 difficult | 1 |
| 2017-02-10 | 2017-02-10 | 0 | ||
| (0) | Additional menus in spreadsheet do not operate | Padlock | 25 |
| 2017-03-01 | 2017-03-01 | 0 | ||||
| (0) | display a single chart with plugin sheet fails (with mode simple=y or n) | Xavier de Pedro | 7 | 6 | 42 |
| 2017-08-16 | 2017-08-16 | 0 | ||
| (0) | Display row and col borders by default when tiki spreadsheets are printed in simple mode with mpdf | Xavier de Pedro | 3 | 9 | 27 |
| 2019-07-23 | 2019-07-23 | 0 | ||
| (0) | Spreadsheet readily divides by zero | hman | 4 | 6 | 24 |
| 2020-08-07 | 2020-08-07 | 1 hman-07 Aug 20 | ||
| (0) | Spreadsheet: Fullscreen view + compare without function | hman | 4 | 8 | 32 |
| 2020-08-07 | 2020-08-08 | 0 | ||
| (0) | Spreadsheet: Illogical edit options | hman | 6 | 10 easy | 60 |
| 2020-08-07 | 2020-08-07 | 2 hman-07 Aug 20 | ||
| (0) | Fatal error in Spreadsheet:graphics | hman | 6 | 5 | 30 |
| 2020-08-07 | 2020-08-07 | 0 | ||
| (0) | Add data from trackers in sheets | Marc Laporte | 7 | 35 |
| 2008-12-14 | 2008-12-14 | 0 |
Pending
[+]| Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| (0) | Exporting Spreadsheets as csv | Loll78 | 8 | 7 | 56 |
| 2012-03-11 | 2017-01-29 | 0 | ||
| (0) | PluginChart doesn't produce the expected chart, just the legend | Xavier de Pedro | 8 | 5 | 40 |
| Jonny Bradley | 2017-01-27 | 2017-05-01 | 1 marclaporte-23 Sep 18 | |
| (0) | Spreadsheet : You cannot export or import a spreadsheet. | Adrien | 7 | 35 |
| Benoit Roy | 2019-06-28 | 2019-07-03 | 2 benoit.roy-03 Jul 19 | ||
| (0) | Export spreadsheet not working - I know how to fix | gcosilveira | 6 | 30 |
| 2011-05-04 | 2015-12-31 | 0 | |||
| (0) | Spreadsheet formulas not working in Tiki 9 | JustKen | 6 | 5 | 30 |
| 2012-10-19 | 2017-01-29 | 1 marclaporte-03 Nov 13 | ||
| (0) | Errors in copying formulas with constants in spreadsheets | nirvanesque | 7 | 4 | 28 |
| 2014-06-12 | 2017-01-29 | 0 | ||
| (0) | Some of the Spreadsheet settings do not get saved. | Lusserall | 5 | 25 |
| 2011-12-12 | 2017-01-29 | 2 Lusserall-04 Nov 13 | |||
| (0) | Integration data from spreadsheet. | DeVox | 25 |
| 2011-12-29 | 2017-01-29 | 0 | ||||
| (0) | Spreadsheet : No way to see the history of a sheet | Adrien | 5 | 25 |
| Benoit Roy | 2019-06-28 | 2019-07-03 | 1 benoit.roy-03 Jul 19 | ||
| (0) | More predefined mathematical functions | annanna | 4 | 20 |
| 2010-09-22 | 2011-02-01 | 0 |
Closed
[+]| Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| (0) | doc.t.o 12.x: Spreadsheets displayed with large blank bottom section and rows out of sync with row numbers | Xavier de Pedro | 8 | 9 | 72 |
| robertplummer | 2013-11-13 | 2015-12-31 | 2 xavi-20 Nov 13 | |
| (0) | Wrong creation and modification date in spreadsheets' list | Frank Guthausen | 7 | 10 easy | 70 |
| manivannans | 2012-11-09 | 2013-11-23 | 1 pascalstjean-23 Nov 13 | |
| (0) | PHP errors using speadsheet in release 15.0 (not 15.0alpha) | bfw25 | 8 | 7 | 56 |
| 2016-05-30 | 2017-01-28 | 7 xavi-11 Jul 16 | ||
| (0) | Page with many PluginSheet calls should respect their own uses of parameter 'simple=y/n' | Xavier de Pedro | 6 | 9 | 54 |
| 2017-01-29 | 2017-08-16 | 5 xavi-16 Aug 17 | ||
| (0) | Two most recent versions in the spreadsheet history should be pre-checked | annanna | 1 low | 5 |
| 2010-09-22 | 2011-02-03 | 0 | |||
| (0) | sheet graph engine fatal error (timeout) - abstract.gridbased.php on line 444 | Xavier de Pedro | 5 | 1 difficult | 5 |
| 2013-11-07 | 2013-11-18 | 0 | ||
| (0) | Save icon doesn't work, redirects back | robertplummer | 9 high | 45 |
| 2011-05-18 | 2011-05-30 | 0 | |||
| (0) | Spreadsheet: Potential CSS regression in Tiki12, with line-height | Marc Laporte | 5 | 9 | 45 |
| manivannans | 2013-10-27 | 2013-11-02 | 0 | |
| (0) | recent 1.10cvs might have conflicts with some features | Xavier de Pedro | 8 | 40 |
| 2007-04-10 | 2007-04-12 | 0 | |||
| (0) | View a Spreadsheet in Mobile mode: tiki complains infinitely that jquery_ui is not enabled | Xavier de Pedro | 8 | 5 | 40 |
| 2013-11-25 | 2017-01-29 | 1 marclaporte-27 Nov 13 | ||
| (0) | TikiSheet: a few bug and some minor enhancements | 7 | 35 |
| Louis-Philippe Huberdeau | 2005-04-19 | 2005-10-11 | 0 | |||
| (0) | /tiki-view_sheets.php doesn't display the sheet before clicking on "edit" | amette | 7 | 35 |
| 2005-10-09 | 2005-10-21 | 0 | |||
| (0) | simple multiline chart (tikisheet) produces many errors and no chart | Xavi (as xavidp - admin) | 7 | 35 |
| amette | 2005-05-26 | 2011-02-03 | 0 | ||
| (0) | Sheet: Boolean expressions display wrong | SEWilco | 7 | 35 |
| 2008-08-01 | 2010-10-21 | 2 robertplummer-02 Apr 10 | |||
| (0) | add jquery sheet plugin to tiki spreadsheets | Xavier de Pedro | 7 | 35 |
| 2009-03-04 | 2011-02-03 | 1 marclaporte-31 Jan 10 | |||
| (0) | integrate a schedule coordination tool in tiki like doodle | Hans.Reil | 7 | 35 |
| 2009-10-03 | 2012-04-14 | 3 xavi-21 Oct 11 | |||
| (0) | 14.x & 15.x & doc.t.o: export sheet as CSV produces 'Array, Array, Array....' | Xavier de Pedro | 7 | 5 | 35 |
| 2015-09-30 | 2016-02-15 | 0 | ||
| (0) | TikiSheet table won't dispaly in Wiki page | kwow | 6 | 30 |
| 2005-08-18 | 2011-02-03 | 0 | |||
| (0) | tikisheet shows old sheet data (n-1) just after saving changes to version n | Xavier de Pedro | 6 | 30 |
| 2007-01-15 | 2011-02-03 | 0 | |||
| (0) | Editor can not create a Tiki Sheet | SEWilco | 6 | 30 |
| 2008-07-31 | 2010-02-21 | 4 space_egd-16 Jul 09 |
jQuery.sheet updates
other updates: http://code.google.com/p/jquerysheet/feeds
Old page content (to be deleted?)
[+]Some issues reported in plain text
Add your issues below
- add a link to create new sheets at the main app. menu (right now just "list sheets") Really? Ok. I intend to rename the menu item Spreadsheets, rather than TikiSheets so people will know what it is.
- Since there is not a dedicated URL to create, it makes an ugly URL. Low priority in my opinion --MarcLaporte
. - Allow deleting many sheets at once (multi-select them at view list and with select "delete") On my list 😀
- Low priority in my opinion --MarcLaporte
. - (tested with jquery.sheet disabled) Creating a graph doesn't auto-display the wiki text underneath as it used to do. The "Wiki Plugin section displays nothing even if you type range of cells for label and data. http://localhost/tiki_trunk/tiki-graph_sheet.php?sheetId=1&graphic=PieChartGraphic&width=500&height=400&renderer=PNG .. presumably old bugs - not looked at that bit at all
- Won't fix as Tiki7 will see overhaul of graphs
. - With Tiki 5.0: When jquery.sheet is off, but spreadsheet and ajax are on, I see the never-ending ajax "loading" icon and shadowed square over the spreadsheet table, and I can't click to any button (edit, etc.) because the shadowed square from ajax "loading" doesn't seem to allow clicking underneath. It can be reproduced in http://precarios.org/sheet1 (once upgraded to Tiki5). Using Arcturus.css + smartiki.css.
Fixed? 5.x r27874 (backports of various fixes in trunk) - Xavi testing with this SHEET HISTORY as an example in trunk and REV 28956: http://demo.tiki.org/trunk/tiki-history_sheets.php?sheetId=1&readdate=1284113147|1284112683|
- (0) the Pipe character in tiki url's like above doesn't allow to hide url and write a label instead. I.e.: [http://www.spreadsheet.com|foo] produces foo, but the url 1284112683 doesn't seem to get parsed properly. If you remove the trailing pipe, sheet history is displayed anyway in the same way (afaik) but the parsing of that link is not the expected: it shows the second text. And adding some text at the end after the second pipe, doesn't change the result with revision 28956, at least: 1284112683
- (1) show version number on top of each sheet
- (2) allow the user to place sheets side to side, or above and below. There is no perfect solution: some sheets or editions add lots of content to columns, and some other times, it's to rows
- (3) By default, I would show sheets above and below, aas in the beginning, because most tiki sites use side columns, and some tiki sites are starting to use "fixed width" for the tiki display, and annoying to have to scroll so much even if you have a huge and wide screen.
- (4) ensure that you can let the admin decide whether one or two of the tiki side columns have to be shown when you are in the feature spreadsheet. This can be handled for most features through "Admin > Look and Feel >Miscellaneous > Layout per section (tiki-admin_layout.php)"
- BTW: I notice that I can't see the changes in style/markup (column width or bg color, etc.). FYI
- (5) In some cases, I don't understand what was the change about (and it was my change, I know I changed something!): http://demo.tiki.org/trunk/tiki-history_sheets.php?sheetId=1&readdate=1284113147|1284112958|
- (6) display the table with the list of versions and the buttons to coompare some other combination also below the side by side comparison of two versions (like inn Wiki history)
- (7) in order to let the user decide when comparing two sheet versions if he/she wants to see (a) the original wiki text in the sheet , or (b) the parsed text-html or (c) Output text only - no html tags, you could look at what jörn ott did at tiki-page-contribution.php. More information (Screenshot: http://doc.tiki.org/ContributionsByAuthor )
- A few notices on a site using strasa and r29358 (Xavi, here: http://iesbarcelona.org/esso350/tiki-view_sheets.php?sheetId=11 )
PHP (5.2.6-1+lenny8) ERROR (E_WARNING):
File: lib/sheet/grid.php
Line: 1303
Type: Missing argument 2 for TikiSheetDatabaseHandler::TikiSheetDatabaseHandler(), called in /path/tiki-view_sheets.php on line 142 and defined
PHP (5.2.6-1+lenny8) NOTICE (E_NOTICE):
File: lib/sheet/grid.php
Line: 1306
Type: Undefined variable: date
PHP (5.2.6-1+lenny8) ERROR (E_WARNING):
File: lib/sheet/grid.php
Line: 1303
Type: Missing argument 2 for TikiSheetDatabaseHandler::TikiSheetDatabaseHandler(), called in /path/tiki-view_sheets.php on line 188 and defined
PHP (5.2.6-1+lenny8) NOTICE (E_NOTICE):
File: lib/sheet/grid.php
Line: 1306
Type: Undefined variable: date
Priorities from Marc
Robert
-
Resize bars are too hard to grab (use coordinates)-
Usability issue still: no icon is shown so is not clear that firefox will allow the user to resize that cell. It does, but it's not clear how (until you try, just in case).
-
- Default color selection
- Color UI is better now than before on https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html but I still think there are too many colors
-
Text color now changes as soon as the tool is click, but text background only changes when we click out. Easy to fix?- No
- Figure out a way for spreadsheet help icon to be available (like the rest of Tiki)
- Nowadays, it is at the menu on the top left corner.
- Nowadays, it makes me lose my current edits (but I need when I am editing)
-
Hideable cells/columns/sheets- It's good now for columns and rows https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html
-
Numbers need to increment with autoFiller-
If the cell only has a number OR a letter and doesn't start with "=", auto increment!- Numbers now auto-increment at https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html
-
- formula update when inserting/deleting a row/column? (as in classic TikiSheet) (Robert)
- Still buggy
- Needs retesting on latest version
- Still buggy
-
Mergable cell (cosmetic)-> now only in the menu, so add to toolbar-
I didn't find out how to merge cells. Xavi. Sept. 5, 2010.- Now works beautifully at https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html
-
- Color & border: Make cells style-able and exportable through xml/json (Robert)
- Done for text and background, still todo for borders and put code in Tiki
- jQuery.sheet menu
- Bring all elements from the jQuery.sheet demo to Tiki
- CSS abse, darkroom, darkshine, ohia: dark on dark text in cells
- Try a different jQuery UI theme? (feature_jquery_ui_theme)
- Let user change jQuery UI theme.
- PluginSheet height and width parameters for spreadsheet mostly works, but bug with height when using %
- Seems to work in edit mode
- Create a new type of button to link spreadsheets and trackers
Sylvie
- Review sheet permissions, including PluginSheet and Category Permissions .
- Attention: plugin SHEET doesn't respect perms on Tiki 4.1 nor in trunk.
Example: - http://sima.pangea.org/sheet20 is not visible for anons.
- But if included in a public page, it is shown. e.g.:
http://sima.pangea.org/SIMA.Exercicis
That's a regression, as far as I remember
I tried to fix wikiplugin_sheet.php with this: http://pastebin.com/ChmZz7zE but it's not fully fixed. A user without local perm on that sheet can still see the sheet through sheet plugin in a wiki page. Xavi (Sept. 5, 2010) - Attention: plugin SHEET doesn't respect perms on Tiki 4.1 nor in trunk.
- Use the Time_sheet profile, and find a way for the the calculated value (only one number) from PluginTrackerlist to be used in a cell sheet.
- Contribution fields should be added to jquery-sheet interface, as they show up in non-jquery-sheet interface once "contribution" feature is on.
Select box Viewable in the sheet interface, contribution type added to mysql tables, but contribution not viewable in the action log interface. Xavi (Sept. 5th, 2010).
Big things for Tiki7
- Sorting (ex.: http://mottie.github.io/tablesorter/docs/ (which is already in Tiki))
- Better integration between Trackers and Spreadsheet
- Add data from trackers in sheets
- Integration with tracker data, ability to import / export data from trackers to spreadsheets. Pending evaluation and quote by Louis-Philippe Huberdeau may be funded by Biomedcom. Contact P Campbell for futher information.
- locking cells
-
hiding cellsdone in https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html - copy-paste from jQuery.Sheet to desktop spreadsheet
- http://plugins.jquery.com/project/issues/sheet?categories=feature
- Realtime Collaborative Spreadsheet with TowTruck ?
other bugs
related
- Slideshow
- http://en.wikipedia.org/wiki/Online_spreadsheet
- http://gelsheet.sourceforge.net/demo
- (Interesting article for context) http://www.pcworld.com/businesscenter/article/217063/why_some_companies_are_ditching_their_spreadsheets.html
- http://framacalc.org/ (in French)
- http://www.lastcalc.com/
Openhub
alias