https://bugs.freedesktop.org/show_bug.cgi?id=74538
--- Comment #2 from hgkamath <[email protected]> --- There is some serious problem I think this can be reproduced Version: 4.2.2.1 Try this 1) create a new spreadhseet 2) click cell B4 3) enter value 42 4) click +sign for new sheet which will automatically be sheet2 5) click cell B3 6) enter value =sheet1.$B$4 7) observe that it works and value 42 is shown 8) save worksheet as try.xslx filetype:"microsoft excel 2007/2010/2013 XML xslx" 9) close all 10) fresh start reopen file try.xslx 11) see sheet 2 B3 entered contents It has become =#REF!!$B$4 Its possible cell value is currently 42, which maybe cached/saved in with file but a Shift+Ctrl+F9 can cause to make value shown refresh to #REF! note that no other software except libreoffice-calc was used. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
