https://bugs.freedesktop.org/show_bug.cgi?id=67571
--- Comment #4 from [email protected] --- (In reply to comment #3) > (In reply to comment #2) > > Hi Georgi / * > > > > Any idea if this is a new problem, or if the problem happens in earlier > > versions too? > > > > Also: any idea whitch formulas causes the problems? > > > > Thanks, > > Cor > > Hello Cor, > I don't know if this was happening in earlier versions - it is just the > first time I've tried it with the latest one 4.1.0.4 > To come to your second question - I saw that the formula in column X is > wrongly copied in some rows from column Z to the right and thus replacing > there the original formulas as they are defined in the ODS file > > Regards, > Georgi Actually when I set the option "Treat empty strings as zero" to "True" it looks better, but still it is messed up with some formulas looks like it cannot handle #N/A value. I think this is the problematic formula: =IF(ISNA($G16);"";IF(INDEX($data.$A$2:$T$5009;$G16;H$2)=0;"";INDEX($data.$A$2:$T$5009;$G16;H$2))) the program replaces this formula =MATCH(A42;$data.$A$2:$A$5009;0) with something else like "=AT42" hope this will help Georgi -- 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
