Spreadsheet toggle (=) converts *all* Tables to spreadsheets then loses existing Table data.

[nshivaraman]

Hey there,

I made a Hurmet with several tables, e.g. Table 1, Table 2. I created a new table (Table 3) that I intended to make into a spreadsheet (Spreadsheet 1). I input all my formulas, then captioned Table 3, and hit the Toggle button (=).

This then formats all Tables (Table 1, Table 2 and Table 3) in the Hurmet as Spreadsheets (and not just Table 3). Although the editor then continues to display the content in Table 1 & 2... looking at the .md code, the content from Table 1 & 2 disappears and becomes blank. Then Hurmet becomes glitchy trying to salvage the Table content as there's a disconnect between the editor and the .md.

I'm using Chrome.

I really enjoy using Hurmet, it's a very powerful tool, thank you for making it. It's very useful and the presentation is beautiful. Thanks again

[ronkok]

I have followed your example. So far, I have not been able to reproduce the problem. I see one table that toggles back and forth from table to spreadsheet. The top two tables remain unchanged.

I will investigate a little longer. This would be a serious bug.

[nshivaraman]

I'm still getting the issue so I tried experimenting a bit more... In my above example, you can make the content in Table 1 & Table 2 appear in the .md file again by captioning those tables and converting them to spreadsheets. Strangely, this will then insert a second "spreadsheet" in the .md code like so:

{#spreadsheetname ."grid spreadsheet spreadsheet" colWidths="null null null"}

While I'm here, I'd also love a unit for metric tonnes force (tonnef) - (similar to the already built-in kilograms force kgf, and imperial tonf) .

Thanks again!

[ronkok]

@nshivaraman, I have fixed a spreadsheet bug. I don't know if it is the same bug, because I have not been able to exactly reproduce your experience. But I would like you to try the updated version.

To get the updated version, you'll have to close all tabs that contain Hurmet, then open Hurmet (that puts new code into a cache on your computer). Then once again close all tabs that include Hurmet and reopen Hurmet a second time. (Then the updated version is read from the cache.)

I have also added tonnef to the units.

[nshivaraman]

Thanks Ron, I'm still getting the same issue unfortunately. No stress/urgency - I can just use tables for my work. Thanks for adding tonnef :)