I mostly work with LO Calc and LO Writer, and it crashes after doing what seem to be ordinary tasks (entering data, doing copy-paste, etc.), even with very basic (and small) files containing no special formatting at all (no Comments, Track Changes are off, etc.). It crashes every few hours, yes even after working with it for a few minutes. By selecting a value, the conditional formatting from above is applied and changes the cell in condition to the selected value.Over the last few weeks it has become increasingly difficult to work with LibreOffice on my computer. The cell lets you select one of the defined values. (Reuse us cond formatting as shown above)īuilding of the predefined values in 'Format-Cells'.

This cell is formatted conditionally as shown above, but reacts on value in ONE cell. Result of the above AND and new cells (100). (Sorry screenshots are in German - I hope they are 'self-explaining by visual identification'įour cells containing different values - each cell is formatted conditionally - just do it in ONE cell and then copy/paiste style on all others. Since some versions, as Pivots were added, conditional formatting is implemented and can be combined with Options/Selections/Slider features. Numbers doesn't (or didn't - not sure of late) support conditional formatting. Many of the people I work with have abandoned MS Office (due to cost) in favour of LibreOffice.Īssuming tolerance of adding an OT reply, just a couple of observations. This was not the case when I used Numbers, what I do not like about numbers is that it cannot be used on my Linux machines. Also I rarely, if ever, receive an Excel file that I cannot open (I guess I and the people I work with are not Excel Power Users).

Maybe I should have clarified, I use it instead of Excel, not in parallel. Maybe at some point all the desktop Office features will be implemented, but they aren't yet. Maybe that was before Libre Office version 7.Īs someone who uses Office 365 at work, I'd say it is less compatible than Libre Office. Interesting! I've heard many complaints about Libre Office, and Open Office before it, not being fully compatible with Microsoft Office. Great thing is, the files are compatible across Win, Mac and Linux versions of Libre / Open Office. I now use LibreOffice for almost everything. I love Numbers but had to give up on it as it was too incompatible with actual Excel (kept exploding complicated Excel files).

Libreoffice for mac m1