https://bugs.documentfoundation.org/show_bug.cgi?id=94540
--- Comment #22 from Robert Gonzalez MX <[email protected]> --- Hello. I can reproduce the problem in Version: 5.0.2.2 Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale: es-MX (es_MX) on Windows 10 Version: 5.1.0.0.alpha1+ Build ID: f830600ece806ec365a4839e79afabe183c5e36d-GL TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-10-06_22:49:09 Locale: es-MX (es_MX) On windows 10 Steps Enter on L2 =VLOOKUP(A2,Parametros.C3:E14,3), correct result displays Add absolute reference to C3:E14 L2 =VLOOKUP(A2,Parametros.$C$3:$E$14,3) correct result displays Save and close file open again and the result is preserved copy L2 with ctrl – c paste to range L3:L100 (98 rows) with ctrl -v correct result displays save and close the file open again and the result is preserved Erase the formulas and start again, but paste 99 rows to range L3:L101 #VALUE error displays After the pasting click in the undo arrow or ctrl – z The first formula entered that was displaying correctly, now displays a #VALUE error If the copiying is applied by parts smaller than 99 rows the correct result displays but when the file is saved, closed and opened again The #VALUE error displays -- 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
