[Libreoffice-bugs] [Bug 42624] FILEOPEN particular .XLS shows Err:520 instead of values

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=42624

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
  Status Whiteboard|                            |CONFIRMED
                 CC|                            |LibreOffice at bielefeldundbus
                   |                            |s.de
     Ever Confirmed|0                           |1
            Summary|Formula Problem             |FILEOPEN particular .XLS
                   |                            |shows Err:520 instead of
                   |                            |values
            Version|unspecified                 |LibO 3.4.4 RC2
           Keywords|                            |NEEDINFO, regression

--- Comment #1 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2011-11-06 00:18:07 PDT ---
[Reproducible] with reporter's sample document and "LibreOffice 3.4.4RC2  -
WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:402)]",

Also reporducible with parallel installation of MinGW Master "LibO-dev 3.5.0 –
WIN7 Home Premium (64bit) English UI [(Build ID: 
2ba5d12-e8c71c5-41e7bcd-4b83b90)]
(daily/MinGW_cross-compilation2011-10-25_00.12.09)"

No Err:520 problem with "LibreOffice Portable 3.3.0  - WIN7  Home Premium
(64bit) German UI [OOO330m19 (Build:6 Tag 3.3.0.4)]" with "LibreOffice Portable
3.3.0  - WIN7  Home Premium (64bit) German UI [OOO330m19 (Build:6 Tag
3.3.0.4)], but some others in D20:D25 and may be elsewhere." 

MS EXCEL Viewer, OOo 3.1.1, OOo 3.3 and Gnumeric without Err:520 problem, OOo
3.3 also shows wrong (no) values in D20:D25

To find out the real reason of the problem is beyond my skills and patience,
the document contains lots of lots of lots of formulas referring to lots of
other formulas referring ...., and if 1 formula has as result "Err:520", that
will "infect" all other results referring to there.

Saving sample document as .ods, closing and reopening it changes the Err:520
problem to a #NAME#? problem; what ever that might mean

@Kohei
Please feel free to reassign (or reset Assignee to default) if it’s not your
area or if provided information is not sufficient. Please set Status to
ASSIGNED 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.