Bug 74680 - Calc object embedded in Impress does not update
Summary: Calc object embedded in Impress does not update
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Impress (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: ARM Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Embedded
  Show dependency treegraph
 
Reported: 2014-02-07 15:40 UTC by justin.barker
Modified: 2018-10-03 20:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description justin.barker 2014-02-07 15:40:36 UTC
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.
Comment 1 Buovjaga 2014-10-26 14:23:33 UTC
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.
Comment 2 justin.barker 2014-10-27 12:43:08 UTC
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.
Comment 3 Buovjaga 2014-10-27 13:37:48 UTC
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.
Comment 4 justin.barker 2014-10-27 13:48:57 UTC
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.