I’m currently using LibreOffice (Calc) on Linux. But my team all use MS Excel on Windows.
We are only working with database (.ods), google doc, some simple functions, maybe some tables, formatting but not VB Script.
What is the best way for me to work with them.
Thank you
my team all use MS Excel
A side question: why not suggest them to use OpenOffice?
Maybe better LibreOffice.
Honestly, everyone here use MSOffice. Telling them to change maybe not a good idea.
Basically:
Always create and save your files in LibreOffice and save them in ODF format (ODT, ODS, etc.).
Always keep these files as their source. If you need other formats for distribution to partners, you can open an ODF file and save and distribute another format with ″ Save as… ″.
This way, you always have working files available in your system environment.
See:
https://wiki.documentfoundation.org/Faq/General/118
========================
Please report an unexpected behavior as a bug in Bugzilla .
Please announce the link from the bug here.
To do this, edit your initial question. Thank you.
Based on my own experience, I prefer Apache OpenOffice that shows slightly better compatibility in visualization of spreadsheets and much better stability with large files (especially with lots of formulas). However, AOO can’t save to XLSX, this may be a stopper. Using both AOO and LO, though, I have never had any issue with XLS(X) files shared with other people using M$O (meaning no complains from peers).
So, I think that the only good advise is to install both suites and see which one will better suit your workflow and habits.
And yes, as ebot points, **
** and only after finishing your work export to any foreign format.
@gabix: I’m not a user anymore, so cannot actually compare “compatibility in visualization of spreadsheets” between AOO and LO - but every case where LO is worse, I’d consider a bug. Could you please file those cases to bugzilla? Thanks!