News for hackers. Stuff that matters.

A comment on Use Spreadsheets Everywhere. Parent comment

Re:Use Spreadsheets Everywhere by Zababa on Tuesday August 03, 2021 @12:55PM (#28051447)
About tables, do they work when you automate the data entry part? For example, copy from a speadsheet into your spreadsheet with the first macro, and then transform the data with a second? That's 90% of my use case for Excel. (I know that doing this in Python/whatever would be "better" but I have to distribute this to users, and the only thing they have on their computer is Excel, and they're gonna manipulate the data after in Excel anyways).
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by correcthorse123 on Tuesday August 03, 2021 @04:54PM (#28054063)
I think Libreoffice Calc supports python integration. Maybe that way one could have the best of both worlds. Unfortunately I suppose most users are stuck in the MS garden.
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by Arrath on Tuesday August 03, 2021 @03:23PM (#28053041)
They should...I think.

If anything add a 'ActiveSheet.Calculate' call to the end of your second macro and give it a test run?

[ Parent | on HN ]