Rectangular table (or grid) of information with some cells than can handle calculations
![[Show/Hide Left Column]](styles/strasa/pics/icons/oleftcol.png "[Show/Hide Left Column]"){kind=icon}
![[Show/Hide Right Column]](styles/strasa/pics/icons/orightcol.png "[Show/Hide Right Column]"){kind=icon}
Spreadsheet
Table of contents
Open
[-]| Rating | Subject | Priority | Category | Created | |
|---|---|---|---|---|---|
 |   (1) | Sheet: Boolean expressions display wrong | 7 | Bug: Consistency | 2008-08 |
| (1) | Add data from trackers in sheets | 7 | Feature request | 2008-12 |
| (3) | integrate a doodle tool in tiki | 7 | Feature request | 2009-10 |
| (1) | tikisheet shows old sheet data (n-1) just after saving changes to version n | 6 | Bug: Error | 2007-01 |
| (1) | check for dependencies in (jquery) sheets and show some hint about using it when in spreadsheets | 6 | Bug: Consistency Bug: Usability | 2010-02 |
| (1) | fix sheets created directly from wiki SHEET plugin within wiki pages for managing tables visually | 5 | Bug: Usability Feature request | 2009-03 |
| (1) | tiki-graph_sheet.php?sheetId= produces WSOD | 5 | Bug: Error Bug: Regression | 2010-02 |
| (0) | TikiSheet Enhancement: Clone feature | 3 | Bug: Usability Feature request | 2008-12 |
| (0) | Plugin Sheet data after TikiSheet is deactivated | 2 | Bug: Error | 2005-06 |
| (0) | No email notification when table changed or watch ability | Bug: Usability | 2008-12 |
Pending
[+]
Closed
[+]
Quick list with r25938
Xavi: using firefox 3.6.2pre
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.
- non-jquery spreadsheet interface seems to work fine (Except for graphs)
using jquery for spreadsheet:
- saving data works!
- wiki parsing works (also wiki plugins!
inside cells.
- it would be easier if initial grid size (rows_x_columns) were specified at sheet creation (for both jquery and non-jquery interfaces).
. - header and footer markup (if you set 1 row for header and one for footer) semms to be shown in jquery-sheet edit interface (kinf-of-wysiwyg???).
. - Contribution fields should be added to jquery-sheet interface, as they show up in non-jquery-sheet interface once "contribution" feature is on.
. - 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.
. - buttons: to me, "save" should work as "save" button works in wiki: save content and leave edit mode to display the parsed result (or resulting tale, if no parsing). Thus, "Done" button, could be safely renamed to "Cancel", as it is in the non-jquery spreadsheet interface.
. - 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.
- 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.
. - 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.
- the jquery-sheet drop down menus (under the MENU link in the top left corner of the edit area) are very fast under webkit based browsers, and extremely slow under firefox (on the same computer, OS, etc.). In case this is easy to fix. However, it works on all browsers I've tested, afaik, so that is a minor issue.
. - Allow using in a wiki page the result from a spreadsheet cell! (that's going to be very powerfull for dynamic reports in wiki pages, not only of graphs but also from specific results fro calculations). Budgets for projects, shown in wiki pages dynamically, etc. Templates of invoices, etc. coming soon (once it's working better!)
. - 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.
. - (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
. - Allow deleting many sheets at once (multi-select them at view list and with select "delete") On my list
. - Add a link/tip to enable jquery.sheet when spreadsheets are being viewed or created without it, since new users will not now 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.
- 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
- http://sima.pangea.org/sheet20
Congratulations for the work so far!
Sheet
TikiSheet
Contributors to this page: xavi
,
jonnybradley
and
marclaporte
.
Page last modified on Friday 05 March, 2010 18:37:39 UTC by xavi .
Sidebar
Main Menu
![[toggle]](pics/icons/module.png "[toggle]")
![[toggle]](javascript:icntoggle('mod-menu_DevMenul4','module.png'); "[toggle]"){kind=small}
Bugs and Wishes
Report a Bug (or suggest a feature enhancement)
About Development
- Tiki5
- Tiki4
- 30 minutes fixes
- 3Rules
- DevTips
- Submit a Patch
- Pending text corrections
- Projects
- SVNTips
- TikiDevNewbie
Mailing lists
Extra Stuff
- SVN view (4.x)
- SVN view trunk (future 5.x)
- CIA SVN stats
- IRC logs
- ConnectingToIrc
- Sourceforge SVN stats
- Changelog (4.x)
- Changes on this site
- How to release
- Upcoming events
Teams
External Links
Full list of Wiki Pages
TikiWiki on Social Networks
Sidebar
To register
![[toggle]](javascript:icntoggle('mod-registration_infor2','module.png'); "[toggle]"){kind=small}
To have an account at this site, please register at Tikiwiki.org, and then use that user name and password to log in here.
, and then use that user name and password to log in here.
Search a Wiki Page
![[toggle]](javascript:icntoggle('mod-search_wiki_page_newr3','module.png'); "[toggle]"){kind=small}
Search Tracker Items Subject
![[toggle]](javascript:icntoggle('mod-Search_tracker_summaryr4','module.png'); "[toggle]"){kind=tracking}
Last Changed Items
- More granular control of recurring events in Calendar
- Users can't deleter his own account
- Add New User - Gen Password - Validate By Email is Broken in 4.1 and 4.2
- Email notification don't work except if "watch minor" is checked
- ssl_error_rx_record_too_long when using "Require Secure (HTTPS) login" (CPANEL self-signed cert.)
- Project name: TikiWiki CMS/Groupware
- Developers on project: 444
- Activity percentile (last week): 99.97%
- Downloadable files: 826391 total downloads to date
- Mailing lists (public): 5
Theme: Strasa
[ Execution time: 0.34 secs ] [ Memory usage: 7.68MB ] [ 170 database queries used in 0.0 secs ] [ Server load: 0.08 ]
Last update from SVN(4.2): Thursday 11 March, 2010 22:36:10 UTC
- REV 26071
Last Comments