Thanks for your thorough considerations, I appreciate. For improving on the existing some further remarks: At the moment the >> biggest drawback for editing large tables with TableEditor is that it seems >> to be very resources demanding. But my computer isn't really powerful, >> and having FF with various tabs open and a OO calc file of several MBs >> makes either or both crash. However, just trying to copy and paste the >> counta calculation along the whole row made FF crash or freeze 2 times. And >> then it left a 0 byte TW again.. >> > > Hmmmm, that is some thing serious...but I am not sure how to improve > that...I will need suggestions from more experienced people here. > > >> Also it seems to create as much backups as cells edited (without autosave >> enabled!) - I don't understand why saving the whole TW with almost every >> cell edited is really necessary? >> > I think it shouldn't at all - even the tiddler should only be saved once >> the user decides to commit the changes made (kept in temporary memory >> before). Believe this would already reduce much of the strain it causes my >> poor browser. >> > > Sure that can be done in a few days. >
Great! Because that will already take off most of the strain which I believe is caused by saveChanges with every cell edited. Considering the crashes mostly happen after pasting the formula and clicking the next cell (while all the processing power at that time is busy with saving the whole TW). Instead using 'enter' after pasting a formula seems to give it enough pause to not causing crushes. Adding rows or columns (with a large table, for example, at the bottom and >> to the far right) causes a jump to the upper left corner and opens the cell >> at the bottom right corner of the browser window for editing. Deleting rows >> further up causes the same jump but the cell opening in edit mode is >> somewhere in the middle at the right edge of the jumped to visible window. >> > > This seems to be the effect of refreshing. But it is not happening in my > FF 14.0.1 so I have no idea what to do. Can you tell me your FF version so > I can get one to try? > Also FF14.01 the portable version on XP. But that's anyway really minor and no need to worry about. > Updating 24 columns from A to Z by adding or deleting works fine now. >> After Z the lettering condinues with [ \ ] ^ _ ` a b c ...calculating with >> theses cell-references still works, but aren't updated by copying formulas >> or by adding/deleting rows. >> > > It is because the plugin assumes only one letter in cell reference (like I > said I did not have a large table in mind during development). This can be > extended. > It's one of those cases you have to consider how much overhead code or further intricacies extending the TableCalculator abilities beyond 26 columns would bring. Since only few would need that large calculations in a TW. Of course, you could really show off without such limitations ;-) However, more than good enough as it is. Yes you are right. Thanks for reminding. In fact I am looking for a > suitable open source library (such as a jQuery plugin or the TableTools as > you suggested) to extend the capabilities of the plugin. But I don't know > much about them yet so will need some time to decide. > Actually just found out that TableTools2 comes with a combination of 'Strg' and 'right click' on any row or column to drag and drop these at any position in the table. With this little feature I didn't knew about (it isn't in the more complicated context menu) a fixed header or fist column isn't really that much needed anymore. I really like that addon, just as the small bookmarklets which lets you sort or transpose tables. That brings me to some other option I thought about: Trying QuickEditPlugin embedded with the table didn't worked to apply formating since it doesn't recognize the edit field open for editing a cell. But maybe it would to that if a dedicated edit field above the table could be created, similar to the calculation bar in spreadsheet software? This edit bar would be distinct to cell edit fields in that it makes all formatting visible, and in this case would have to be fixed so that the tables scrolls underneath when large tables are edited. Just a possibility to ponder. Regards. -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To view this discussion on the web visit https://groups.google.com/d/msg/tiddlywiki/-/S5DHPzmgA7MJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.
