Ton, On Monday, December 3, 2012 7:39:10 PM UTC+8, TonG wrote: > > Hi Vincent, > > Yes, the "spreadsheet" class can prevent a lot of trouble. >
Good! But I just found that I forgot to do calculations when the option chkTWtcalcAllTables is set to true...Will fix it in the next release. :-) > Disabling all add-ons and restarting FF 17 did not help: FF 17 does > not show the buttons with the "old" Dropbox prerelease file. > With the "new" Dropbox prerelease file I only see the C button, but > cannot "reach" it: as soon as I leave the table area the C button > disappears. > Sometimes - not always - after a reboot I see the buttons; lateron I > don't see them anymore. > Anyway, for testing I'm using now a separate "clean" FF17 (from the > Utilu Mozilla Firefox Collection). > I am worried about this because I wouldn't use these plugins myself if I have to get a clean copy for every upgrade...Shall spend some time on this... > > I don't know anything about the Javascript's eval() function, but by > accident I noticed that there is a difference in result when handling > "text" as "2,3" (indeed 2 comma 3): > > A1 A2=product(2*A1) A3=product(A1*2) > -------------------------------------- > 2,3 3 6 > 2,4 4 8 > 2,5 5 10 > > The need for some text "awareness" is there. > > Yes, there should be text awareness in a spreadsheet, I agree. And it should be included in the parser for calculations. However, this can take some time, so for now I put a primitive checker for simple arithmetic expressions to avoid such results. Will put up a pre-release file as soon as it is ready. Thanks for all the feedback to make the plugins better and better! Vincent I could Edit all the time with the "new" Dropbox prerelease file. > During playing with the plugin I noticed the "smart" copy/paste > behaviour: updated cell reference comparable with the "copy by > dragging" in Excel/OpenOffice Calc. Very nice. > Up till now no problems found with TWtcalc, but I did not test it > thoroughly, just playing with it. > Cheers, > > Ton > > On Nov 30, 6:01 pm, Vincent Yeh <qmo.w...@gmail.com> wrote: > > And yes, you need to either add class "spreadsheet" to the table that > wants > > calculations, or check the option TWtcalcAllTables to calculate all > tables. > > > > > > > > > > > > > > > > On Saturday, December 1, 2012 12:56:59 AM UTC+8, Vincent Yeh wrote: > > > > > Ton, > > > > > On Friday, November 30, 2012 2:31:48 AM UTC+8, TonG wrote: > > > > >> Hi Vincent, > > > > >> Sorry, but I could not try your Dropbox prerelease file in Firefox 17 > > >> since the Configuaration/Edit modes are not available to me (Win 7 > 64- > > >> bit + Firefox v17) > > >> When I hover with the mouse over the table, I only see cell > references > > >> like A1, B1 or formulas but no buttons at all. > > >> Are other users of Firefox v17 having the same problem? > > > > >> Like usual my FF 17 works fine on Win7 x64. Is it possible that some > of > > > your addons left something over and accidentally affects the behavior > of > > > the plugin? > > > > >> Since TiddlySnip stopped working for me with Firefox v17 (other > post), > > >> I have Firefox v16 available as well, and surprise: I see the H, C, > > >> and E buttons when hovering over the table. > > >> I do like it this way: no distracting buttons when you just view > > >> tiddlers with tables. > > > > >> And although "2,3" now shows as "2,3", I can "calculate" with it. I > > >> expected something like #VALUE! (as in OpenOffice), but got "strange" > > >> calculations (A1 containing "text", A2 =product(2*A1) ): > > >> A1 A2 > > >> ------------ > > >> 2,3 6 > > >> 3,4 8 > > >> 2,03 6 > > >> 2,003 4006 > > >> 2,013 4026 > > > > >> This way it will be difficult to "debug" wrong table entries (e.g. > "," > > >> instead of "."). Is it possible to mimic the #VALUE! error of > > >> OpenOffice? > > > > > The first three cases are, unfortunately, from Javascript's eval() > > > function, which the TWtcalc calls for final evaluation. I chose to use > the > > > eval() function because I thought it should be a good parser, which is > > > needed to handle wrong expressions. I have no idea why it returns 3 > when > > > you feed it with "2,3" (2 comma 3), which results in 6 in your first > and > > > third test cases and 8 in your 2nd. I did not plan to write a parser > for > > > TWtcalc for the reason I just said: I thought Javascript itself is a > good > > > parser. Guess I have to rethink about it... > > > > > The last two cases, 2,003 and 2,013, are from TWtcalc's thousands > > > separation codes, which considers 2,003 as the number two thousand and > > > three (since it happens to have the correct format of thousands > separation) > > > and gives the result of 4006. Same for the last case. This should be > > > somewhat fixed in the pre_release file available at > > >https://dl.dropbox.com/u/23745840/pre_release.html, as I now disable > the > > > thousands separation codes by default and enable it only when the > option > > > chkTWtcalcThousandSeparated is set to true. > > > > >> And all of a sudden I could not edit the cells anymore. I could go to > > >> edit mode of the tiddler by double clicking the table (or using the > > >> Edit button in the toolbar), but after clicking Cancel, editing the > > >> cells was still not possible. > > >> Only after reloading the TW everything worked again. > > > > > I might have fixed this in the pre-release file (link above), please > try > > > and let me know if I did. > > > > > Have fun! > > > Vincent > > > > >> I hope to do more testing in the weekend. > > > > >> Cheers, > > > > >> Ton > > > > >> On Nov 29, 4:53 pm, Vincent Yeh <qmo.w...@gmail.com> wrote: > > >> > Oh, and I forgot to mention that the buttons are now visible only > when > > >> > mouse enters the table or the table is in edit mode, and invisible > > >> > otherwise. > > > > >> > On Thursday, November 29, 2012 11:45:59 PM UTC+8, Vincent Yeh > wrote: > > > > >> > > Yakov, > > > > >> > > Thank you very much for so much detailed description of your > ideas, I > > >> > > actually haven't thought that deep yet! I will think more about > it > > >> and > > >> > > probably start working on it not far from now, though it seems > like a > > >> big > > >> > > project to me. > > > > >> > > About the bugs I think I have fixed a couple of them, > > > > >> > > - the wrong behavior in a closed slider panel, > > >> > > - the strange results in partial self transclusion, > > > > >> > > The keyboard navigation in a spanned cell shall be fixed soon. > > > > >> > > Ton, I should have fixed the TWtcalc bug you mentioned, too. > > > > >> > > A pre_release file is prepared at > > >> > >https://dl.dropbox.com/u/23745840/pre_release.htmlforyou to try. > > >> Please > > >> > > do try it and tell me if there are more I need to fix. Thanks. > > > > >> > > Have fun! > > >> > > Vincent > > > > >> > > On Wednesday, November 28, 2012 10:57:36 PM UTC+8, Yakov wrote: > > > > >> > >> Hello. > > > > >> > >> About sliders: the story seems to be rather complicated and may > be > > >> far > > >> > >> from usual usage. I put many tests in one tiddler and that's > where > > >> sliders > > >> > >> work incorrectly. I simplified the test and made it closer to > real > > >> cases. > > >> > >> Create tiddler 1 with couple of sections and a table in each: > > > > >> > >> !Section 1 > > >> > >> |table 1|c > > >> > >> |editable|k > > >> > >> |h-cell1|h-cell2||h > > >> > >> |c11|c12++|| > > >> > >> |c21|c22|| > > > > >> > >> !Section 2 > > >> > >> with merged cells: > > >> > >> |h-cell1|>|h-cell2|h > > >> > >> |c11|c12|c13| > > >> > >> |~|c22|c23| > > > > >> > >> then create another tiddler which transluces this sections, one > via > > >> > >> <<tiddler>> and another via <<slider>>: > > > > >> > >> <<tiddler [[Tiddler 1##Section 1]]>> > > >> > >> <<slider "" [[Tiddler 1##Section 2]] "*" "">> > > > > >> > >> And then try this: first, open the slider and click E on a > table. > > >> Each > > >> > >> table will enter the edit mode, no matter which E button was > > >> clicked. (then > > >> > >> click E again or reload the tiddler or go to edit mode and back) > And > > >> > >> second, close the slider, click E on the table which is > transcluded > > >> via > > >> > >> <<tiddler>>, then (or after clicking E once more) open the > slider. > > >> The > > >> > >> table disappears; if you click E on the first table again, the > > >> second table > > >> > >> appears once more, but with messed numeration. > > > > >> > >> Regarding the self transclusion. A usual case for it is when I > > >> create > > >> > >> sliders (without NestedSlidersPlugin) and tab sets like this: > > > > >> > >> <<slider "" [[This tiddler##section]] "somelabel" > "sometooltip">>/% > > >> > >> !section > > >> > >> some content > > >> > >> !end%/ > > > > >> > >> /% > > >> > >> !section 1 > > >> > >> ... > > >> > >> !section 2 > > >> > >> ... > > >> > >> !end > > >> > >> %/<<tabs .....>> > > > > >> > >> Although, I place the sections *after* the transclusion macros > most > > >> of > > >> > >> the times (this test case appear from that tiddler with many > tests > > >> in it). > > > > >> > >> As for the test, it doesn't work for me. What I did: > > >> > >> * downloaded the pre_release.html file via FireFox -> save -> > save > > >> all > > >> > >> * open it (in both FF 16.0.2, 17.0 with enabled and disabled > > >> TiddlyFox > > >> > >> and in Opera 12.11 without TiddlySaver.jar), opened the "test" > > >> tiddler > > >> > >> * click E, click c14, add "+" in there, click out (in edit mode > the > > >> > >> content is shown as "c14+"), then click E again (the content is > > >> shown as > > >> > >> "c14+c14" now) > > >> > >> * open edit mode of the tiddler (in there the table is > unchanged, > > >> the > > >> > >> content of the cell being "c14") > > >> > >> The behavoir is the same with all the combinations of > > >> browsers/saving > > >> > >> engines listed above. > > > > >> > >> Navigation with keyboard is very nice, thanks! I especially like > the > > >> > >> behavior of the cursor when navigating left and right. The thing > > >> that needs > > >> > >> some more tweaking is merged cells: currently arrows don't move > > >> focus into > > >> > >> the "~" and ">" cells; what I'd expect is that pressing left > always > > >> moves > > >> > >> to the cell on the left (including ones with ">" or "~"), not > down > > >> or jump > > >> > >> over a cell. > > > > >> > >> Another idea: instead of clicking E, it can be very convenient > to > > >> > >> double-click a table to toggle the edit mode. But this has to > > >> difficulties: > > >> > >> first, to implement this, it's necessary to stop handling even > of > > >> > >> double-clicking the tiddler which opens the edit mode of the > tiddler > > >> (set > > >> > >> by the fetchTiddler method of the story object [1]); and second, > > >> > >> touchscreens (or, better to say Android browsers) have some > > >> different event > > >> > >> handling (in Android, double-tap doesn't work for opening a > tiddler > > >> to > > >> > >> edit). > > > > >> > >> Then, about editing lists. > > > > >> > >> First, there are three basic things which should be handled: > > >> > >> * simple list > > >> > >> * list tree > > >> > >> * list tree with items with wrappers like this {{justDiv{ > > >> > >> > here goes, for instance, a quotation > > >> > >> * or > > >> > >> * another > > >> > >> * list > > >> > >> | or | a | > > >> > >> | table | > > >> > >> etc > > >> > >> }}} and then some more text. Unfortunately, there are other > > >> wrappers. In > > >> > >> some TWs I use NestedSlidersPlugin when makes +++[this wrapper] > > >> > >> some content > > >> > >> === and also /% > > >> > >> comment wrapper > > >> > >> %/ > > >> > >> and it is to be decided what parts are opened in the edit mode. > A > > >> simple > > >> > >> way would be to edit a list item with everything inside it, but > when > > >> > >> there's only a sublist inside, like this: > > > > >> > >> * item > > >> > >> ** sublist item > > >> > >> ** another sublist item > > > > >> > >> than it's more convenient to open only the > > > > >> > >> * item > > > > >> > >> part on editing the item. > > > > >> > >> Next, there should be some way to activate the edit mode. There > has > > >> to be > > >> > >> a method for each list item. There can be some buttons, or a > button > > >> can > > >> > >> appear on click, or double-click can activate the edit mode. > What I > > >> think: > > >> > >> * double-click is a very good solution but > > >> > >> ** this can have the same problems with touchscreens as I > mentioned > > >> above > > >> > >> ** there should be some way to activate other control elements > > >> (analogue > > >> > >> of C button, menu for moving up and down > > > > ... > > > > read more ยป > -- 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/-/988VoFiqsGcJ. To post to this group, send email to tiddlywiki@googlegroups.com. To unsubscribe from this group, send email to tiddlywiki+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.