Updating formula values

10 views
Skip to first unread message

Konrad

unread,
Oct 23, 2019, 4:59:59 AM10/23/19
to jOpenDocument
Hi, 
I'm filling spreadsheet which have formula. Formula copies value from other sheet but copied value is 0. It works with CTRL + SHIFT + F9 but it's not enough for me. Is there any way to do it automatically? 

Guillaume Maillard

unread,
Oct 23, 2019, 5:12:36 AM10/23/19
to jopend...@googlegroups.com
Hi,

This behaviour is not in the hands of jOpenDocument, it depends of the program which open the spreadsheet.
I suspect that you could do that in LibreOffice using a macro calling the L.O. API.

Regards,
Guillaume

Le mer. 23 oct. 2019 à 11:00, Konrad <konrad.n...@gmail.com> a écrit :
Hi, 
I'm filling spreadsheet which have formula. Formula copies value from other sheet but copied value is 0. It works with CTRL + SHIFT + F9 but it's not enough for me. Is there any way to do it automatically? 

--

---
You received this message because you are subscribed to the Google Groups "jOpenDocument" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jopendocumen...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jopendocument/70edd619-8324-43d7-9553-afcec17f69f8%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages