When I have two instances of libreoffice calc open, and I click on a cell in one instance, the formula bar that was showing the contents of a cell in the other instance goes blank. This is very annoying when trying to compare a particular formula in two different spreadsheets, editing one while viewing the other. Is there a way to prevent this from happening?
The current controller has only one active sheet.
As workaround you could enable
Display: Formulas for one of the spreadsheets…