Spreadsheet

Xavi: using firefox 3.6.2pre Marc: using? jonnyb replies in purple

re-sort the list manually by cut&paste as needed to bring to the top the more important issues to make it work as usable and stable as possible in Tiki5. And if you can re-test things with a more recent revision in Tiki, please update this quick list if possible instead of creating a new a potentially partially duplicated one below

A. Bugs - JQuery.sheet interface

1. Dangerous: if you add a new sheet to a spreadsheet (through the facility at the bottom of the interface at sheet edition), you can successfully create a new sheet 2, but it seems to delete the data you had in sheet 1.
   duplicated repoort by marc?: "Adding a second spreadsheet (within ID1) replaces the data of the first"
   fixed? 5.x r 27874 (backports of various fixes in trunk)

B. Regressions - Jquery.sheet (when compared to former tikisheet interface)

1. links from Spreadsheet jq are not working (pluginsheet isn't jquery aware?)
   • pluginsheet is now jquery.sheet aware (5.0 b2), but i don't think jquery.sheet is enabled on doc.two
     • done
   
   .
2. adding columns and rows was better because we could say before or after. Now we can't add a first column or row. Perhaps jquery.sheet tools should add row or colums before the selection? It seems fixed June 26, 2010: Reopening: adding and deleting columns is unreliable, in Tiki 5.0 (at least, maybe related to cases where some cells are merged?).: Marc, you can reproduce with the spreadsheet available in the db dump from precarios.org (that one I sent you for tracker performance, etc.)
   • Sometimes it adds the columns a few columns before the focussed cell.. And it's not clear (sometimes impossible) to add a column to the right of the last column, when the focus is on just one cell of that column.
   • Deleting columns: sometimes the deleted columns are not the ones which have focus, but some others.
   
   .
3. Copy calculation feature (" Fill down") is missing to me (or I don't know how to do that). The former spreadsheet interface has that very useful feature.
   • On the Menu (click the word MENU top left while editing
   • Done by Robert, needs testing and put code in Tiki
   
   .
4. Contribution fields should be added to jquery-sheet interface, as they show up in non-jquery-sheet interface once "contribution" feature is on.
   .
5. Mergable cell (cosmetic) (Robert)
   • Done, but only on the menu again
   
   .
6. formula update when inserting/deleting a row/column? (as in classic TikiSheet) (Robert)
   • Done by Robert, needs testing and put code in Tiki
   
   .

C. Other feature requests (non-regressions) - JQuery.sheet

1. Multi-instance. Robert explains that this is the most important on his list at the moment.
   • Done by Robert, needs to have more dynamic javascript variable declaration when sheet is created.
   
   .
2. it would be easier if initial grid size (rows_x_columns) were specified at sheet creation (for both jquery and non-jquery interfaces).
   • Sheet no longer asks what size you'd like the sheet, should most likely be set a jQuery option. (i.e. newSheetSize: '5x10')
   
   .
3. Spreadsheet help should be added to the box at the question mark icon, for consistency with the help from other tiki sections. Nowadays, it is at the menu on the top left corner.
   • Once the help page (sheet) is opened, there are tabs for sheets at the bottom, as if different type of help was viewable on each sheet. Unluckily, I had problems the first time I tried to open them... mmmm. But one hour later (after doing other things in that tiki) I could (firefox 3.6.2pre all the time)
   
   .
4. jQuery cell width too large when editing (better old TikiSheet way?) This is more obvious when there are 10 columns or more fixed
   .
5. when you create new columns or rows, they are not saved them all unless you add content to the last ones also. I.e.: you have a 2x2 table, you add 3 new columns, and 3 new rows (so it will be A-B-C-D-E and 1-2-3-4-5 table), if you don't add any content inside columns D & E and rows 4 & 5, once saved and "done", the table loses those extra columns that you created.
   • In jQuery.sheet 1.1.0, xml & json now export all cells, in the past some were skipped to save bandwidth, but this is needed now for styling.
   
   .
6. Under firefox, cells in the table cannot be resized. so that if you add several lines of content (wiki plugins, etc.), the edition is not easy.
   • Possibly height is not being saved after page is resized and then saved, then reloaded.
   • With webkit-based browsers (Epiphany-webkit, Google Chrome, etc.), the edit area on top (corresponding to the cell with focus) is resizable, so this problem is solved there.
     There are CSS issues in that case:
     • the top zone in grey color has fixed height, so that when resized to be higher, the extra height is not grey but white (minor issue, but it exists).
     • resizing he edit area into a bigger space than the amount of cells (columns or rows) add white space to the right and underneath, so that cells are not resized. This is a minor look&fell issue, imho.
       • This should be resolved in v1.1.0
   
   .
7. Clipboard: copy-paste from Excel
   • Done by Robert, needs testing and put code in Tiki
   
   .
8. If formula has en error, say so instead of just being blank (Robert)
   • Done by Robert, needs testing and put code in Tiki
     • ML: works for me
   
   .
9. 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
   
   .
10. sorting
    .
11. locking cells
    .
12. hiding cells
    .
13. copy-paste from jQuery.Sheet to desktop spreadsheet
    .
14. http://plugins.jquery.com/project/issues/sheet?categories=feature
    .
15. Add statistical functions via http://plugins.jquery.com/project/jsanalysis

D. Feature requests - Jquery.sheet integration with Tiki

1. editing
   • Old data (from pre-upgrade) not kept
     • ok now?
     • Xavi: well, not for me: example where I can't edit it anymore after upgrade to tiki5rc1
   
   .
2. Have a full page spreadsheet edit mode (useful when large sheets)
   • Done
   
   .
3. Allow using in a wiki page the result from a spreadsheet cell! (that's going to be very powerful for dynamic reports in wiki pages, not only of graphs but also from specific results from calculations). Budgets for projects, shown in wiki pages dynamically, etc. Templates of invoices, etc. coming soon (once it's working better!)
   .
4. Add a link/tip to enable jquery.sheet when spreadsheets are being viewed or created without it, since new users will not know about jquery interface when they use the spreadsheet. Or the other way round if enabled by default in the future. Good idea - once it's out of experimental.
   .
5. Robert says: "Also, I really think you guys should use jquery.sheet to list the spreadsheet before it is editable by simply turning off editable functionality with option editable: false. It would look much more professional." Done?
   .
6. Fresh install. If you use bottom save before using Save button in toolbar, at your next edit, it appears that it didn't save. fixed later
   .
7. CSS
   • abse, darkroom, darkshine, ohia: dark on dark text in cells
     • Try a different jQuery UI theme? (feature_jquery_ui_theme)
   • thenews: cell width & height is problematic
   
   .
8. New sheet:
   • Start with 1x1 sheet? (looks weird, should be 5x5 or similar, or even better, allow setting initial size when creating the new spreadsheet in Tiki as other two params: # cols. & # rows, before entering jquery.sheet)
   
   .
9. 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.
   .
10. Make height and width parameters for spreadsheet used as plugin.
    .
11. Add the ability to be multi sheet outside of spreadsheet editor (plugin)
    .
12. Add multi sheet instance

E. Feature requests - Tikisheet

1. Spreadsheet export should allow to export the version you are seing, and not just the last one: At history of the sheet, you can see the previous content before that fatal edition, but there is no way to rescue that content. If you click at export sheet when viewing that previous version, you are not exporting that previous version but just the last (and empty) one. :-/
   .
2. 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.
   .
3. Allow deleting many sheets at once (multi-select them at view list and with select "delete") On my list
   .
4. (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
   .
   • Attention: plugin SHEET doesn't respect perms on Tiki 4.1.
     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
   
   .
5. see wiki diff & rollback, which is like Undo/Redo (Should coordinate with Jonny as I am not sure what part should be in Tiki vs jQuery.sheet). example of side-by-side colored diff, example of side-by-side source diff
   .
6. 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)