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) | Spreadsheet: Dropdown menus are in background | hman | 3 | 10 easy | 30 |
| 2021-02-05 | 2021-02-05 | 0 | ||
(0) | Spreadsheet: Fullscreen view + compare without function | hman | 4 | 8 | 32 |
| 2020-08-07 | 2020-08-08 | 0 | ||
(0) | Spreadsheet: History ignores date/time prefs | hman | 4 | 10 easy | 40 |
| 2020-08-07 | 2020-08-07 | 0 | ||
(0) | Fatal error in Spreadsheet:graphics | hman | 6 | 5 | 30 |
| 2020-08-07 | 2020-08-07 | 0 | ||
(0) | Spreadsheet: Illogical edit options | hman | 6 | 10 easy | 60 |
| 2020-08-07 | 2020-08-07 | 2 hman-07 Aug 20 | ||
(0) | Spreadsheet readily divides by zero | hman | 4 | 6 | 24 |
| 2020-08-07 | 2020-08-07 | 1 hman-07 Aug 20 | ||
(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) | 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) | Additional menus in spreadsheet do not operate | Padlock | 25 |
| 2017-03-01 | 2017-03-01 | 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) | cells in feature "spreadsheet" go blank when overflowed | RadoS | 6 | 30 |
| 2017-02-10 | 2017-02-10 | 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 | ||
(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) | 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) | Spreadsheets testing for Tiki16 | Torsten Fabricius | 8 | 2 | 16 |
| 2016-10-13 | 2017-01-27 | 1 luci-19 Oct 16 | ||
(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) | Spreadsheet: update to latest stable version | Marc Laporte | 6 | 5 | 30 |
| 2013-09-10 | 2013-11-14 | 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) | No email notification when table changed or watch ability | space_egd | 7 | 35 |
| 2008-12-05 | 2013-06-05 | 0 |
Pending
[+]Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
---|---|---|---|---|---|---|---|---|---|---|---|
(0) | More predefined mathematical functions | annanna | 4 | 20 |
| 2010-09-22 | 2011-02-01 | 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) | 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) | Spreadsheet formulas not working in Tiki 9 | JustKen | 6 | 5 | 30 |
| 2012-10-19 | 2017-01-29 | 1 marclaporte-03 Nov 13 | ||
(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 : 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 |
Closed
[+]Rating | Subject | Submitted by | Importance | Easy to solve? | Priority | Category | Volunteered to solve | Created | LastModif | Comments | |
---|---|---|---|---|---|---|---|---|---|---|---|
(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) | 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 |
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/