Comment by eitland
1 day ago
I actively prefer Libre Office.
Yes, Excel is probably a lot better if you use English setup and advanced functions.
For me,
- not having to use Norwegian for formulas (my work machine has Norwegian setup and Excel insists on using Norwegian formulas)
and
- not having it trying to find something it can misinterpret as a date, preferably some random place in a list of thousands of items
makes it worth it.
Just change your windows display language to English?
Should I also change it on my mother's computer who doesn't speak English? We can also start distributing .bat files that change the system language along with our spreadsheets, for anyone who wants to open them. Maybe automate it with VBS, so it changes automatically when you open the spreadsheet. That's the solution.
The VBS should then also lock the spreadsheet to foreground while it's opened, because the global change may affect other apps, like Windows Calculator may swap the comma/thousand separator.
Will write a user story for that if you share the link /s