I create some document with =RANDBETEEN(0;9) and store it in the native LO format ODF 1.3. extended. The function has become volatile in recent versions.
Then I open the document with OpenOffice and the function remains volatile although it is a non-volatile function when I use the same function in a new OpenOffice document. How is the volatility transfered to the other application?
The actual function call in OpenOffice and LO is =com.sun.star.sheet.addin.Analysis.getRandbetween(0;9)
Checked the claim with a .ods file created in LibO V 7.3.3.2, containing (in A1) =RANDBETWEEN(1;9), opened then with AOO V4.1.7 (PortableApp), and completed with the second (identical) =RANDBETWEEN(1;9) (in A11).
Both the formuals are treated non-volatile.
If you keep the original LO file untouched, the function is volatile in AOO. It updates with F9. Non-volatile functions update with Ctrl+Shift+F9.
I kept the original LO file (more than 1h old at the moment), and even before I enter the second formula, the first one in A1 is NOT volatile in AOO 4.1.7. It neither updates (recalculates) with F9 nor with ‘any action of editing’ as volatile functions do in LO.
The file:
randbetweenvolatileTest.ods (8.9 KB).
You may check the generator and the D-T of generation. The D-T of the manifest.xml is (UTC) 2022-07-20 08:52. You surely know how to find the name and version of the generating software.
My bad. I noticed the strange phenomenon with a more complicated file where volatile TODAY was involved.