Mohammad Yes I have used Tobias's tools and it is of great value for a lot of applications. It is a good way to populate tiddlywiki with content from other sources. However here I am interested only in the simpler CSV export, which is a direct match to a table, Columns rows and cells.
Regards Tony On Saturday, February 1, 2020 at 3:02:38 PM UTC+11, Mohammad wrote: > > Hi Tony, > Thank you for your comments. > > Tobias beer <https://tobibeer.github.io/tb5/#convertable> has made a > converter can accept csv or Excel file and create tables based on that! By > the way having a two direction tools is a good idea! > > Regarding math operators, I agree with you to do such sophisticated > calculation in spreadsheet apps. Here I just tried to have some a summary > row shows some basic > statistics like mean, sum, max, ... > > I believe we should keep it simple and I think Dynamics Tables are getting > complex and complex as I add more features. > > Best > Mohammad > > > > On Saturday, February 1, 2020 at 7:00:31 AM UTC+3:30, TonyM wrote: >> >> Mohammad >> >> Especialy once there are simple maths within a table something I have for >> my client is a separate form of the same table which is a csv with header >> row of column names and each row as a comma delimited record. >> >> If we could have a copy to clipboard button that copies any table to csv >> users can take data generated in their tiddlywiki database and paste into a >> spreadsheet app for more complex calculations. >> >> I and my business clients do this kind of thing a lot. One trick is to >> past the csv into its own data worksheet and have a second report or >> analysis sheet that does a lookup to the data sheet. It is then simple to >> update the spread sheet with current data without touching the report or >> analysts sheet. >> >> Perhaps one day I will make it possible to re import the csv to >> tiddlywiki and apply changes. >> >> While I like the idea tiddlywiki can do everything it makes sense to let >> it delegate functionality to built for purpose tools like excel. >> >> With a set of calculations available in tables we reduce the need to go >> external to tiddlywiki but to be able to quickly go external allow people >> to use the best tool to do the job, and leverage user skills in their >> existing tools. >> >> I would like us to adopt this approach more often. >> >> Regards >> Tony >> >> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/1f337d0b-e907-44d3-994e-48d02ba53ca5%40googlegroups.com.