When a Calc spreadsheet range is copied into Impress, the formulas do not update even after the presentation is closed and re-opened. This should at least be an option since it would add very little overhead.
Setting as enhancement and NEW. From what I understand, you want Calc-copied ranges to work in Impress like they work in Writer. In Writer, you can use and change formulas like you were in Calc. In Impress, the formulas are not there.
No. What I meant was if I put a formula in the object like TODAY(), it will not update while the presentation is running. Even if left to run for several days it will still only show the value of the formula when it was originally added to the slide.
Others can verify with Insert > Object > Ole Object - Create new LibreOffice Spreadsheet. You can use f.ex. =RANDBETWEEN(0;5000) The recalculation is afterwards done only, if you double click the object to edit it.
That's my point. Shouldn't date-valued functions change in real time with the date or time? The use case would be a kiosk or display board that does calculations based on the date or time. (In reply to Beluga from comment #3) > Others can verify with Insert > Object > Ole Object - Create new LibreOffice > Spreadsheet. You can use f.ex. =RANDBETWEEN(0;5000) The recalculation is > afterwards done only, if you double click the object to edit it.
Same in OOo 3.3 and a recent trunk build, testing with =NOW(). But if the value only updates in Calc when the spreadsheet is reloaded or modified, I'm not too surprised the value doesn't update as long as the embedded OLE object is not entered or modified.