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) | 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) | Spreadsheet: Illogical edit options | hman | 6 | 10 easy | 60 |
| 2020-08-07 | 2020-08-07 | 2 hman-07 Aug 20 | ||
(0) | import csv not working | stirus | 8 | 7 | 56 |
| 2016-08-09 | 2019-07-01 | 2 drsassafras-28 Jan 17 | ||
(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) | Spreadsheet: History ignores date/time prefs | hman | 4 | 10 easy | 40 |
| 2020-08-07 | 2020-08-07 | 0 | ||
(0) | No email notification when table changed or watch ability | space_egd | 7 | 35 |
| 2008-12-05 | 2013-06-05 | 0 | |||
(0) | Add data from trackers in sheets | Marc Laporte | 7 | 35 |
| 2008-12-14 | 2008-12-14 | 0 | |||
(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) | Spreadsheet: Fullscreen view + compare without function | hman | 4 | 8 | 32 |
| 2020-08-07 | 2020-08-08 | 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) | cells in feature "spreadsheet" go blank when overflowed | RadoS | 6 | 30 |
| 2017-02-10 | 2017-02-10 | 0 | |||
(0) | Fatal error in Spreadsheet:graphics | hman | 6 | 5 | 30 |
| 2020-08-07 | 2020-08-07 | 0 | ||
(0) | Spreadsheet: Dropdown menus are in background | hman | 3 | 10 easy | 30 |
| 2021-02-05 | 2021-02-05 | 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) | Page-ability with large spreadsheets | robertplummer | 5 | 25 |
| robertplummer | 2011-02-11 | 2011-02-11 | 0 | ||
(0) | Additional menus in spreadsheet do not operate | Padlock | 25 |
| 2017-03-01 | 2017-03-01 | 0 | ||||
(0) | Spreadsheet readily divides by zero | hman | 4 | 6 | 24 |
| 2020-08-07 | 2020-08-07 | 1 hman-07 Aug 20 | ||
(2) | D3.js support in Tiki | Marc Laporte | 7 | 3 | 21 |
| Victor Emanouilov | 2014-02-25 | 2017-01-30 | 7 marclaporte-03 Jun 18 |
Pending
[+]Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
---|---|---|---|---|---|---|---|---|---|---|---|
(0) | Errors in copying formulas with constants in spreadsheets | nirvanesque | 7 | 4 | 28 |
| 2014-06-12 | 2017-01-29 | 0 | ||
(0) | Export spreadsheet not working - I know how to fix | gcosilveira | 6 | 30 |
| 2011-05-04 | 2015-12-31 | 0 | |||
(0) | Exporting Spreadsheets as csv | Loll78 | 8 | 7 | 56 |
| 2012-03-11 | 2017-01-29 | 0 | ||
(0) | Integration data from spreadsheet. | DeVox | 25 |
| 2011-12-29 | 2017-01-29 | 0 | ||||
(0) | More predefined mathematical functions | annanna | 4 | 20 |
| 2010-09-22 | 2011-02-01 | 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) | Some of the Spreadsheet settings do not get saved. | Lusserall | 5 | 25 |
| 2011-12-12 | 2017-01-29 | 2 Lusserall-04 Nov 13 | |||
(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) | 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) | Spreadsheet formulas not working in Tiki 9 | JustKen | 6 | 5 | 30 |
| 2012-10-19 | 2017-01-29 | 1 marclaporte-03 Nov 13 |
Closed
[+]Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
---|---|---|---|---|---|---|---|---|---|---|---|
(0) | Layout & colors in TikiSheets are not 3.0 ready with strasa (see them in dev.tw.o) | Xavier de Pedro | 6 | 30 |
| 2009-05-27 | 2011-02-03 | 1 chibaguy-28 May 09 | |||
(0) | insert column or row in spreadsheet requires ajax to work in 3.3, and broken in tiki 4.0 | Xavier de Pedro | 6 | 30 |
| 2010-01-02 | 2010-01-02 | 0 | |||
(0) | A SheetID is required shown when attempting to edit a sheet with jquery.sheet | Xavier de Pedro | 6 | 30 |
| 2010-02-01 | 2010-02-21 | 0 | |||
(0) | check for dependencies in (jquery) sheets and show some hint about using it when in spreadsheets | Xavier de Pedro | 6 | 30 |
| 2010-02-01 | 2011-02-01 | 0 | |||
(0) | A SheetID is required shown when attempting to edit a sheet with jquery.sheet | joemacd | 6 | 30 |
| 2010-05-05 | 2010-06-26 | 1 xavi-05 May 10 | |||
(0) | Attempting to create a tikisheet results in DB error | tvader | 6 | 30 |
| Philippe Cloutier | 2011-06-01 | 2011-09-29 | 1 Chealer9-29 Sep 11 | ||
(0) | Report shows html code in spreadsheet cells | Xavier de Pedro | 6 | 5 | 30 |
| 2012-10-30 | 2021-10-10 | 1 marclaporte-10 Oct 21 | ||
(0) | sheet history: wrong diff + attributes changed cell to the old date instead of new | Xavier de Pedro | 7 | 4 | 28 |
| 2013-11-04 | 2013-11-24 | 1 pascalstjean-24 Nov 13 | ||
(0) | pie chart didn't work for me | Xavi (as xavidp - admin) | 5 | 25 |
| 2005-05-26 | 2007-01-16 | 0 | |||
(0) | fix sheets created directly from wiki SHEET plugin within wiki pages for managing tables visually | Xavier de Pedro | 5 | 25 |
| 2009-03-04 | 2013-11-07 | 1 marclaporte-05 Sep 10 | |||
(0) | 4.0: editing tiki sheets at tw.o don't keep the changes made | Xavier de Pedro | 5 | 25 |
| 2009-11-21 | 2011-02-03 | 2 xavi-21 Nov 09 | |||
(0) | tiki-graph_sheet.php?sheetId= produces WSOD | Xavier de Pedro | 5 | 25 |
| 2010-02-01 | 2011-02-01 | 1 marclaporte-05 Sep 10 | |||
(0) | Unified Index: Add spreadsheet | Marc Laporte | 5 | 5 | 25 |
| 2013-11-04 | 2013-11-10 | 0 | ||
(0) | Spreadsheet Column Headers don't match Column sizes in Full Screen mode | Pascal St-Jean | 25 |
| 2013-11-14 | 2013-11-15 | 1 pascalstjean-15 Nov 13 | ||||
(0) | tiki-sheets.php layout is not ready for 3.0 (left column goes to the bottom) | Xavier de Pedro | 4 | 20 |
| 2009-03-04 | 2010-02-01 | 0 | |||
(0) | 12.x - 15.x: Sheet profile Handler doesn't get sheet content added (following lastest available documentation) | Xavier de Pedro | 5 | 4 | 20 |
| rjsmelo | 2015-10-01 | 2023-10-27 | 0 | |
(0) | TikiSheet doesn't remove or add columns | 3 | 15 |
| Beestje | 2006-08-06 | 2009-05-18 | 2 Beestje-14 Apr 09 | |||
(0) | TikiSheet Enhancement: Clone feature | space_egd | 3 | 15 |
| 2008-12-05 | 2011-02-01 | 0 | |||
(0) | tiki-list_object_permissions.php -> Needs tabs for missing features | Marc Laporte | 3 | 4 | 12 |
| manivannans | 2013-11-03 | 2013-11-20 | 3 marclaporte-20 Nov 13 | |
(0) | Plugin Sheet data after TikiSheet is deactivated | Marc Laporte | 2 | 10 |
| Louis-Philippe Huberdeau | 2005-06-21 | 2010-09-04 | 0 |
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 ?
- 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/