Ask Your Question
0

What is the meaning of "Recalculation on File Load" in Options?

asked 2018-10-19 01:16:38 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am looking at that feature as I can't make the program to bring a value in cell of file A from a cell in a file B. The value that is produced in file A is stubbornly "0" while cell in file B has value greater that "0".

edit retag flag offensive close merge delete

Comments

Edit your question and upload your file here. Anonymize the file beforehand.

ebot gravatar imageebot ( 2018-10-19 08:00:08 +0100 )edit

It would take too much time to anonymize the file. I am giving up on LibreOffice and considering WPS Spreadsheet or FreeOffice 2018. Nevertheless, do you know answer to my title's general question, regardless of a sample file presence? Thank you.

ZLibreOffice gravatar imageZLibreOffice ( 2018-10-19 16:08:01 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-19 16:43:35 +0100

ebot gravatar image

updated 2018-10-19 16:44:41 +0100

The title question: It's self-explanatory. Recalculate when loading the file. 1. For Excel 2007 and newer (files). 2. ODF spreadsheets saved by other programs (not LO). For 1. and 2. there is a choice: a) recalculate, b) never recalculate, c) ask users. What is not understandable?

Exampel: Write e.g. in cell B1 "= A1", if in A1 the sought value is located. It should show the same thing unless the formatting of the cells is different.

edit flag offensive delete link more

Comments

Thank you for the explanation. If one is using the program occasionally, it, the title wasn't explicit.

In my case, value B1 was called from a sheet in a different file and the result was "0", no matter what I did. I succeeded once after I saved the source file with XLSX extension. However, when I tried to call data from the same file but from another cel (e.g., A2), B2 was "0" again.

ZLibreOffice gravatar imageZLibreOffice ( 2018-10-19 18:33:57 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-19 01:16:38 +0100

Seen: 91 times

Last updated: Oct 19 '18