▲ 194 ▼ Worth the effort to obtain a copy of MS Office on the high seas? *SOLVED (sh.itjust.works) submitted 2 years ago* (last edited 2 years ago) by Reverendender@sh.itjust.works to c/piracy@lemmy.dbzer0.com 101 comments fedilink hide all child comments It's for my mother, who so far cannot stand LibreOffice.
[–] Proteus@lemmy.dbzer0.com 2 points 2 years ago (1 child) 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. permalink fedilink source parent hideshow 2 child comments replies: [–] cestvrai@lemm.ee 2 points 2 years ago (1 child) If I’m doing anything substantial, calculation-wise, I use openpyxl. permalink fedilink source parent hideshow 2 child comments replies: [–] Proteus@lemmy.dbzer0.com 2 points 2 years ago (1 child) Interesting! permalink fedilink source parent hideshow 2 child comments replies: [–] cestvrai@lemm.ee 2 points 2 years ago* 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. permalink fedilink source parent
[–] cestvrai@lemm.ee 2 points 2 years ago (1 child) If I’m doing anything substantial, calculation-wise, I use openpyxl. permalink fedilink source parent hideshow 2 child comments replies: [–] Proteus@lemmy.dbzer0.com 2 points 2 years ago (1 child) Interesting! permalink fedilink source parent hideshow 2 child comments replies: [–] cestvrai@lemm.ee 2 points 2 years ago* 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. permalink fedilink source parent
[–] Proteus@lemmy.dbzer0.com 2 points 2 years ago (1 child) Interesting! permalink fedilink source parent hideshow 2 child comments replies: [–] cestvrai@lemm.ee 2 points 2 years ago* 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. permalink fedilink source parent
[–] cestvrai@lemm.ee 2 points 2 years ago* 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. permalink fedilink source parent
