Onlyoffice sucks very bad with macros in my experience, lacks some advanced functions, and infuriatingly doesn’t seem to have options search, but other than that it’s fantastic, very intuitive, ergonomic and sleek option.
You might also find the Python library pandas useful. Its “DataFrames” can mirror your excel data 1:1 and you have convenience methods like to_excel(). Easy to combine with numpy for performant matrix math.
XLSX just becomes a container for storing/sharing your data, and while Python is used for analysis. I would use matplotlib for plotting rather than embedding in the sheet.
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !piracy@lemmy.dbzer0.com
⚓ Dedicated to the discussion of digital piracy, including ethical problems and legal advancements.
Onlyoffice sucks very bad with macros in my experience, lacks some advanced functions, and infuriatingly doesn’t seem to have options search, but other than that it’s fantastic, very intuitive, ergonomic and sleek option.
My own daily driver.
If I’m doing anything substantial, calculation-wise, I use openpyxl.
Interesting!
You might also find the Python library pandas useful. Its “DataFrames” can mirror your excel data 1:1 and you have convenience methods like to_excel(). Easy to combine with numpy for performant matrix math.
XLSX just becomes a container for storing/sharing your data, and while Python is used for analysis. I would use matplotlib for plotting rather than embedding in the sheet.