Category: Spreadsheet
Show subcategories objects| Name | Type |
|---|---|
|
/tiki-view_sheets.php doesn't display the sheet before clicking on "edit"
Formerly the sheet got displayed, when going to /tiki-view_sheets.php - it's not like that any more. I can edit it perfectly, etc. - but it doesn't get shown.. |
tracker item |
| 12.x - 15.x: Sheet profile Handler doesn't get sheet content added (following lastest available documentation) | tracker item |
|
Caldrac
Contributors |
tracker item |
| 14.x & 15.x & doc.t.o: export sheet as CSV produces 'Array, Array, Array....' | tracker item |
|
Sheet: Boolean expressions display wrong
In TikiSheet: I'm trying to have 'T' or 'true' shown when two other columns have the same value. But =(H3==K3) when saved shows "true=(H2=". Note the truncation; the truncated stuff shows up in the expression field on the edit screen. Before being saved the cell shows 'true'. Adding a conditional ("?:") ex Also, a spreadsheet could not have rows added to it until a similar expression was removed from the spreadsheet. |
tracker item |
|
eclvvin
Contributors |
tracker item |
|
omstefanov
Contributors |
tracker item |
|
4.0: editing tiki sheets at tw.o don't keep the changes made
editing tiki sheets at tw.o don't keep the changes made (no error nor warning message shown; everything apparently ok). But no sign of the changes made, not in the sheet, nor in the history of tiki sheet. Example: http://tikiwiki.org/tiki-view_sheets.php?sheetId=1 I did edit it as user "xavi", add some info the cell A2, save, and no record of the changes. Looking at the tiki sheet history, nothing is shown either about the edit. See a related post of users reporting other problems with tw.o sheets since tiki 4.0 (I couldn't reproduce their problem, though). http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=21908#threadId35330 |
tracker item |
|
A SheetID is required shown when attempting to edit a sheet with jquery.sheet
Using latesst trunk from today (Feb 1st 2010). Installed a new tiki, enabled tikisheets, created one. Edit it and save changes. Then enable jquery.sheet through Admin > Look & Feel > interface (or whatever name, I don't remember) > tick the jquerty sheet checkbox. also enable ajax. Create another sheet. Edit it with jquery.sheet, and it , and "A Sheet Id is required" type of message (or something similar) was shown. I remember it worked for me weeks ago, when I tested the first commits by jonny with jquery.sheet in trunk. But nowadays, it doesn't work for me. |
tracker item |
|
A SheetID is required shown when attempting to edit a sheet with jquery.sheet
Very similar to this bug that was fixed in Version 5: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=3017&trackerId=5&show=view Unfortunately, our host does not support version 5 yet, so I am dead in the water unless this same issue gets addressed in version 4.1 Basically, you can create sheets, but whenever you try to edit them, simply clicking on any of the links (Insert, Remove, etc.) causes a redirect to an error page stating: "A SheetId is required." I haven't been able to import simple spreadsheets either, but that's another issue. |
tracker item |
|
Add data from trackers in sheets
An idea expressed by Mike Kerr (Kerrnel22) at the Nov 2008 Montreal TikiFest: To include tracker output data in the spreadsheet. This would help make very flexible reports, with charts. |
tracker item |
|
add jquery sheet plugin to tiki spreadsheets
Nowadays that JQuery has been added to 3.0svn, there is big opportunity ("low hanging fruit"?) for improving the usability of tiki spreadsheets, adding (optionally, of course) one better interface for spreadsheets through jquery plugins. My proposal is __jQuery.sheet__: http://plugins.jquery.com/project/sheet http://jqueryplugins.weebly.com/jquerysheet.html demo: http://jqueryplugins.weebly.com/uploads/3/1/3/8/313814/jquery.sheet.html This would improve the editing UI (for sheets), as well as big tables, if created and managed through the plugin SHEET directly from the wiki page, as drawing could be created previously. |
tracker item |
| Additional menus in spreadsheet do not operate | tracker item |
|
Attempting to create a tikisheet results in DB error
Trying to create a spreadsheet results in DB error. Incorrect integer value: '' for column 'parentSheetId' at row 1 La requête était : INSERT INTO `tiki_sheets` ( `title`, `description`, `author`, `parentSheetId` ) VALUES( ?, ?, ?, ? ) Valeurs : Probo admin La requête construite était probablement : INSERT INTO `tiki_sheets` ( `title`, `description`, `author`, `parentSheetId` ) VALUES( 'Probo', '', 'admin', '' ) Stacktrace : * C:\inetpub\wwwroot\tiki\7.2\tiki-sheets.php : 0 -> {main}(array ( )) * C:\inetpub\wwwroot\tiki\7.2\tiki-sheets.php : 98 -> replace_sheet(array ( )) * C:\inetpub\wwwroot\tiki\7.2\lib\sheet\grid.php : 2358 -> query(array ( )) * C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb\Bridge.php : 29 -> query(array ( )) * C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb\Pdo.php : 120 -> handleQueryError(array ( )) * C:\inetpub\wwwroot\tiki\7.2\lib\core\TikiDb.php : 150 -> handle(array ( )) |
tracker item |
| cells in feature "spreadsheet" go blank when overflowed | tracker item |
|
check for dependencies in (jquery) sheets and show some hint about using it when in spreadsheets
Using latest trunk from today (Feb 1, 2010) Installed blank new tiki site, enabled tiki sheets. Wishes: (1) When adding a new sheet, some hint could be shown about the chance to use jquery.sheet interface. I enabled jquery.sheet plugin, but not ajax. (2) If ajax is required for jquery.sheet to work (that's what I've been told, but I don't know for sure myself), jquery.sheet should report that ajax is needed and show a link to enable it. |
tracker item |
| D3.js support in Tiki | tracker item |
| display a single chart with plugin sheet fails (with mode simple=y or n) | tracker item |
| Display row and col borders by default when tiki spreadsheets are printed in simple mode with mpdf | tracker item |
| doc.t.o 12.x: Spreadsheets displayed with large blank bottom section and rows out of sync with row numbers | tracker item |
|
Editor can not create a Tiki Sheet
User with Editor plus sheet edit permission tried to create a Tiki Sheet in v2.0RC4 -Arcturus-. An error occured in a database query! Context: File tiki-sheets.php Url tiki-sheets.php Query: INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( ?, ?, ? ) Values: 0 testsheet 1 this is a test 2 NULL Message: Column 'author' cannot be null Built query was probably: INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( 'testsheet', 'this is a test', NULL ) |
tracker item |
|
Editor can not create a Tiki Sheet
User with Editor plus sheet edit permission tried to create a Tiki Sheet in v2.0RC4 -Arcturus-. An error occured in a database query! Context: File tiki-sheets.php Url tiki-sheets.php Query: INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( ?, ?, ? ) Values: 0 testsheet 1 this is a test 2 NULL Message: Column 'author' cannot be null Built query was probably: INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( 'testsheet', 'this is a test', NULL ) |
tracker item |
| Errors in copying formulas with constants in spreadsheets | tracker item |
| 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 | tracker item |
|
Export spreadsheet not working - I know how to fix
I tried to export a sheet that I made and it didn´t work anyway. But I compared tiki-import_sheet.php and tiki-export_sheet.php and I found the error. |
tracker item |
;){kind=link}
;){kind=link}
;){kind=link}
;){kind=link}