https://bugs.documentfoundation.org/show_bug.cgi?id=92841
--- Comment #7 from Eike Rathke <[email protected]> --- There's not much we could do about, in plagued_file.xlsx the defined name Lapa has the expression SUBSTITUTE(INDEX(Nosaukums,MATCH(#REF!!$C1,Nosaukums_sais,0))," ","_") where the #REF! is a result of a sheet being deleted where the original reference pointed to, presumably Sheet1. In the other files of the attached .zip there's no #REF! in all three files, the expression references Sheet1 and Sheet1 is present, so probably there even wasn't anything to repair. If someone could try out what MS-Excel exactly saves when saving such named expression that contains a reference to a deleted sheet we could mimic that if it differs. -- 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
