Recalculation with F9 key only works very sporadic. Using formatting right alignment (CRTL R) updates cell content. Happend with nested sheets calculating time durations with date and time functions (german HEUTE() and JETZT())
Please Marting, could you attach a sample file.
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you You can also try ctrl+shift+F9
Please, could you describe step by step a scenario where you see that F9 does not work? And attach your test file (with all personal data removed) to this bug report. Do not forget to check options that influence recalculation: 1/ on loading the file: menu Tools > Options > LibreOffice Calc > Formula > Recalculation on Load File 2/ menu Data > Calculate > AutoCalculate Best regards. JBF
Options like recalculation on loading and autocalculate are always on. Problem was reported with LO 4.4.5.2. Behaviour becomes better with LO 5.0.x.y, works o.k. for the first recalc and then stops working. With LO 5.1.3.2 I've not problems anymore, works everytime with F9.
Since there is no specific commit fixing this issue, setting to WORKSFORME. FIXED is used only when a commit exists.