Printable embedded spreadsheets

Sean Boyle

unread,

Jan 6, 2020, 2:26:39 PM1/6/20

to TiddlyWiki

I would like to be able to use tw to create a printable report with embedded spreadsheet. The best I can do now is use MathCell, but it has limitations (like not being able to sum(range) ). Socialcalc is quite nice and I can import / export, but it cannot be directly printed (yes, including "Open in new window". Has anyone cracked this nut?

TonyM

unread,

Jan 6, 2020, 5:49:05 PM1/6/20

to TiddlyWiki

Sean,

Evans solution https://evanbalster.com/tiddlywiki/formulas.html has the full set of functions to use sophisticated spreadsheet calculations. However when using a range you need to consider how your data is organised.

I currently print sophisticated tables via open in new window (Although I do not use Socialcalc) however I find generating a csv file of row column data and pasting it into a spreadsheets template more practical.

Regards

Tony

Sean Boyle

unread,

Jan 7, 2020, 2:27:21 PM1/7/20

to TiddlyWiki

Thanks Tony.

That plugin is also quite nice, but...

I would like to do is set up a spreadsheet with calculations which can operate on a range of cells (e.g. =sum(A1:A4)) (and be able to print them, of course.

TonyM

unread,

Jan 7, 2020, 8:34:48 PM1/7/20

to TiddlyWiki

Sean,

Search for other TiddlyWiki spreadsheet tools however Evans solution discusses row column addresses here https://evanbalster.com/tiddlywiki/formulas.html#Spreadsheet%20Prototype

However it will not operate on a range.

However for you to make some data appear in a spreadsheet you no doubt used a filter. You can use this filter again in a macro to calculate the value for that range.