Fullscreen
[Show/Hide Right Column]

Rectangular table (or grid) of information with some cells than can handle calculations Type of page »  Feature page
Print

Spreadsheet

there are many links not working on this particular page.

I located, that the problems might have to do with the PluginTabs, introduced in page version 283
Did not yet find the actual problem.
S.b. who has time or knowledge should check this.
Thx

--ToF


About


See some screenshots at: Spreadsheet jq

jQuery.sheet updates

Subversion commits to project jquerysheet on Google Code

other updates: http://code.google.com/p/jquerysheet/feeds

Bug Tracking

Open

[-]
 RatingSubjectImportanceCategoryCreated
open -2 -1 0 1 2 (0) Help No email notification when table changed or watch ability7Bug: Usability
Feature request
Request		2008-12
open -2 -1 0 1 2 (2) Help Add data from trackers in sheets7Feature request2008-12
open -2 -1 0 1 2 (0) Help Exporting Spreadsheets as csv7Bug: Error
Bug: Usability
Problem		2012-03
open -2 -1 0 1 2 (2) Help Export spreadsheet not working - I know how to fix6Bug: Error2011-05
open -2 -1 0 1 2 (1) Help fix sheets created directly from wiki SHEET plugin within wiki pages for managing tables visually 5Bug: Usability
Feature request		2009-03
open -2 -1 0 1 2 (0) Help Page-ability with large spreadsheets5Feature request2011-02
open -2 -1 0 1 2 (0) Help Some of the Spreadsheet settings do not get saved.5Bug: Usability
Bug: Regression		2011-12
open -2 -1 0 1 2 (0) Help Integration data from spreadsheet.Bug: Usability2011-12

Pending

[+]

Closed

[+]
Triage
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 biggrin
    • 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 [http://www.spreadsheet.com|foo], but the url [http://demo.tiki.org/trunk/tiki-history_sheets.php?sheetId=1&readdate=1284113147|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: [http://demo.tiki.org/trunk/tiki-history_sheets.php?sheetId=1&readdate=1284113147|1284112683|test]
    • (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 )
    • Quote:
      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).
  2. Default color selection
  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
  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
  6. Numbers need to increment with autoFiller
    • If the cell only has a number OR a letter and doesn't start with "=", auto increment!
  7. [http://plugins.jquery.com/node/14301|formula update when inserting/deleting a row/column?] (as in classic TikiSheet) (Robert)
    • Still buggy
  8. [http://plugins.jquery.com/node/14303|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.
  9. [http://plugins.jquery.com/node/14294|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 TikiWiki
  11. CSS abse, darkroom, darkshine, ohia: dark on dark text in cells
  • Try a different jQuery UI theme? (feature_jquery_ui_theme)
  1. Let user change jQuery UI theme.
  2. PluginSheet height and width parameters for spreadsheet mostly works, but bug with height when using %
  • Seems to work in edit mode
  1. Create a new type of button to link spreadsheets and trackers




Sylvie

  • Review sheet permissions, including PluginSheet and Category Permissions .
    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


other bugs

Image

related

alias

Page last modified on Tuesday 24 April, 2012 18:08:41 UTC

SourceHistoryComments

Search Wishes (subject only) [toggle]

Categorize Spreadsheet

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.