<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - : Link to external .ods file returns incorrect data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131100#c11">Comment # 11</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - : Link to external .ods file returns incorrect data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131100">bug 131100</a> from <a class="email" href="mailto:g_e_fox@hotmail.com" title="Ed <g_e_fox@hotmail.com>"> Ed</a> <pre>(In reply to Buovjaga from <a href="show_bug.cgi?id=131100#c5">comment #5</a>) > (In reply to Ed from <a href="show_bug.cgi?id=131100#c4">comment #4</a>) > > The above said, I actually tried to fall back to OpenOffice, but guess what? > > It now behaves the same was as LibreOffice does! > > I opened Mar 2020 in LibreOffice 3.3, the first version ever released > (contains everything found in OpenOffice.org at the time) and B2 shows the > value as 2. > > Same result with versions 3.5.0, 4.4.7 and 5.4.0. The chained updating you > speak of sounds cool, but I am unable to find a version where it worked. If I open, save, and close successively September, then October, November, December, the value if B2 is correct for each month. Then if I open January, the value is -1. It should be 158. This makes absolutely no sense to me. Of course, succeeding months are then incorrect as well. If after the above, I repeat the same sequence of opening, saving, and closing with OpenOffice 4.1.3, then the correct values get posted to cell B2 for each month.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>