https://bugs.freedesktop.org/show_bug.cgi?id=51664
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW CC| |[email protected], | |markus.mohrhard@googlemail. | |com Summary|[XLS] array formula |FILEOPEN .xls with matrix |regression from 3.5 to 3.6 |{row()} returns error | |message instead of result Version|3.6.0.0.beta2 |Master old -3.6 --- Comment #4 from Rainer Bielefeld <[email protected]> 2012-07-03 05:49:11 UTC --- [Reproducible] with reporter's sample and "LibreOffice 3.5.5.2. German UI/Locale [Build-ID: 24b32b4-b87ec2e-85c8e98-87a4e20-9a1b8c1] on German WIN7 Home Premium (64bit) Steps how to reproduce with parallel installation of Master "LOdev " 3.7.0.0.alpha0+ - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 3985521]" (tinderbox: W2008R2@16-minimal_build, pull time 2012-06-24) 1. open new CALC document from LibO Start Center 2. Select B10:B20 3. Type "=row()" > will show "row()" function in B10 4. <control+shift+Enter> Creates matrix {row()} for B10:B20, showing row number 5. Save as "sample.ods" 6. Save as "sample.xls" (MSO97) 7. Close all documents 8. Open both "sample.xxx" documents (one by one) Bug: in "sample.xls" B10 shows "FALSE", other row results are "#NV" (also saw: "#N/A") Works fine with "sample.ods" In attached "370fromscratch.xls" often scrolling down until values invisible and scrolling back heals the problem. Always inserting a row anywhere above or below matrix healed the problem for me. Already Reproducible --------------------- 3.6.0.0.beta1 Server installation of Master "LOdev 3.6.0alpha0+ – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 7175cee]" (tinderbox: Win-x86@6-fast, pull time 2012-05-16 22:07:37) Still worked fine ----------------- Server installation of Master "LOdev 3.6.0alpha0+ – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 475d0c5-829fc92-39746e8-206648e-fefd87]" (2012-02-14) @Kohei, @Markus: Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
