https://bugs.documentfoundation.org/show_bug.cgi?id=47588
--- Comment #5 from Luca <[email protected]> --- Just to give one more feedback: the bug is still present in version 5.0.2. This is not only a visualization problem, consider this real example (happened to me yesterday): =IF(ISNA(VLOOKUP($B3,$'Check NoProd'.A$1:A$983040,1,FALSE())),"NO",VLOOKUP($B3,$'Check NoProd'.A$1:A$983040,1,FALSE())) It is a legitimate formula, coming from Excel 2010. After saving and reopening the document not only cell value displays #REF, but even the formula is altered: =IF(ISNA(VLOOKUP($B3, $'CheckNoProd'.#REF!$#REF!:#REF!$#REF!,1,FALSE())),"NO",VLOOKUP($B3, $'CheckNoProd'.#REF!$#REF!:#REF!$#REF!,1,FALSE())) And there is no way to detect the corruption quickly, you have to close and reopen the document. Data corruption undermines confidence in open source productivity software, at least for my boss ;-) -- 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
