Loading...
 

Category: Spreadsheet

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 ("?:") expression wrapper did not help.

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

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.

Accessibility (WAI & 508)
Accounting
Administration
Ajax
Articles & Submissions
Backlinks
Banner
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Calendar
Category
Chat
Comment
Communication Center
Consistency
Contacts Address book
Contact us
Content template
Contribution
Cookie
Copyright
Credits
Custom Home (and Group Home Page)
Database MySQL - MyISAM
Database MySQL - InnoDB
Date and Time
Debugger Console
Diagram
Directory (of hyperlinks)
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
DogFood
Draw -superseded by Diagram
Dynamic Content
Preferences
Dynamic Variable
External Authentication
FAQ
Featured links
Feeds (RSS)
File Gallery
Forum
Friendship Network (Community)
Gantt
Group
Groupmail
Help
History
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
jQuery
Kaltura video management
Karma
Live Support
Logs (system & action)
Lost edit protection
Mail-in
Map
Menu
Meta Tag
Missing features
Visual Mapping
Mobile
Mods
Modules
MultiTiki
MyTiki
Newsletter
Notepad
OS independence (Non-Linux, Windows/IIS, Mac, BSD)
Organic Groups (Self-managed Teams)
Packages
Payment
PDF
Performance Speed / Load / Compression / Cache
Permission
Poll
Profiles
Quiz
Rating
Realname
Report
Revision Approval
Scheduler
Score
Search engine optimization (SEO)
Search
Security
Semantic links
Share
Shopping Cart
Shoutbox
Site Identity
Slideshow
Smarty Template
Social Networking
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Staging and Approval
Stats
Survey
Syntax Highlighter (Codemirror)
Tablesorter
Tags
Task
Tell a Friend
Terms and Conditions
Theme
TikiTests
Timesheet
Token Access
Toolbar (Quicktags)
Tours
Trackers
TRIM
User Administration
User Files
User Menu
Watch
Webmail and Groupmail
WebServices
Wiki History, page rename, etc
Wiki plugins extends basic syntax
Wiki syntax text area, parser, etc
Wiki structure (book and table of content)
Workspace and perspectives
WYSIWTSN
WYSIWYCA
WYSIWYG
XMLRPC
XMPP




Useful Tools