[Libreoffice-bugs] [Bug 51664] FILEOPEN .xls with matrix {row()} returns error message instead of result
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Tue Jul 3 07:49:11 CEST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=51664
Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
CC| |kohei.yoshida at gmail.com,
| |markus.mohrhard at 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 <LibreOffice at bielefeldundbuss.de> 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 at 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 at 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.
More information about the Libreoffice-bugs
mailing list