Spreadsheet

• «
• 1
• 2 (current)
• »

• «
• 1
• 2 (current)
• 3
• »

Some issues reported in plain text

Add your issues below

1. 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
   
   .
2. 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
   
   .
3. (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
   
   .
4. 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)
5. 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

1. 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).
     • It's good now at https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html
2. 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
3. Text color now changes as soon as the tool is click, but text background only changes when we click out. Easy to fix?
   • No
     • It's good now at https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html
4. 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)
5. Hideable cells/columns/sheets
   • It's good now for columns and rows https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html
6. 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
7. formula update when inserting/deleting a row/column? (as in classic TikiSheet) (Robert)
   • Still buggy
     • Needs retesting on latest version
8. 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
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. jQuery.sheet menu
    • Bring all elements from the jQuery.sheet demo to Tiki
11. CSS abse, darkroom, darkshine, ohia: dark on dark text in cells
    • Try a different jQuery UI theme? (feature_jquery_ui_theme)
12. Let user change jQuery UI theme.
13. PluginSheet height and width parameters for spreadsheet mostly works, but bug with height when using %
    • Seems to work in edit mode
14. 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)
• 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 cells done 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/

• Sheet
• TikiSheet
• jQuery.Sheet
• jQuery Sheet
• jQuerySheet
• Spreadsheets