News for hackers. Stuff that matters.

A comment on Inkscape 1.2 released. Parent comment

Re:Inkscape 1.2 released by m-p-3 on Monday May 16, 2022 @11:13PM (#31405671)
Gsheets offers some formulas I found quite useful and would be a pain to replicate in Excel.
[ Parent | on HN ]
Re:Inkscape 1.2 released by usr1106 on Tuesday May 17, 2022 @02:09AM (#31406599)
Excel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate steps.

I wasn't aware that Google has a different one. I have never used more than simple sums and differences in Google sheets. Can you give an example where Google offers better, incompatible functionality?

[ Parent | on HN ]
Re:Inkscape 1.2 released by m-p-3 on Tuesday May 17, 2022 @09:12AM (#31410025)
For example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now.

[1]: https://support.google.com/docs/answer/3093343

[2]: https://support.google.com/docs/answer/3094136

[3]: https://support.google.com/docs/answer/3093275

[ Parent | on HN ]
Re:Inkscape 1.2 released by goatlover on Tuesday May 17, 2022 @01:55AM (#31406498)
Excel has lambdas now.
[ Parent | on HN ]
Re:Inkscape 1.2 released by LegitShady on Tuesday May 17, 2022 @08:14AM (#31409347)
excel is fully programmable with vba.
[ Parent | on HN ]