Bug 34466 - ** Expression is faulty ** in every cell in Writer tables
Summary: ** Expression is faulty ** in every cell in Writer tables
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: high critical
Assignee: Cédric Bosdonnat
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-18 16:54 UTC by Guillermo Belli
Modified: 2011-03-03 01:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
A test file that reflects the bug (8.94 KB, application/vnd.oasis.opendocument.text)
2011-02-18 16:54 UTC, Guillermo Belli
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Guillermo Belli 2011-02-18 16:54:49 UTC
Created attachment 43541 [details]
A test file that reflects the bug

When opening a Writer document that has a table with formulas, every cell shows ** Expression is faulty **, as apparently one of the formulas is copied into every cell.

This is reproducible every time.

How to reproduce:

1. Create a new Writer document.
2. Insert a table
3. Enter some values
4. Enter a formula, eg: =<A1>+<B1>
5. Save and close the document
6. Open the document

It seems that the stored data is intact, and the error occurs during or after the document loads.

I've experienced this some time before (prior to LibreOffice fork), but I didn't pay much attention as I thought the document was corrupt. Then since every LibreOffice 3.3 RC did I se this bug.

I'm running ArchLinux 64bits, with LibreOffice version 3.3.0.4 ArchLinux build-2.

I'm adding a test file.
Comment 1 Jorendc 2011-02-19 05:51:43 UTC
This isn't a bug.

Function in A1 (first row, first column) is <A1> + <B1>. So you're adding the function value of A1 ... but A1 is your function itself ...

<A1> = <A1> + <B1> = correct faulty error.
Comment 2 Guillermo Belli 2011-02-19 08:45:39 UTC
(In reply to comment #1)
> This isn't a bug.
> 
> Function in A1 (first row, first column) is <A1> + <B1>. So you're adding the
> function value of A1 ... but A1 is your function itself ...
> 
> <A1> = <A1> + <B1> = correct faulty error.

The original values of the test file were:

A1: 1
A2: 2
B1: =<A1>+<B1>

But when you open the file, every cell has =<A1>+<B1>

How come that is not a bug!
Comment 3 Guillermo Belli 2011-02-19 08:57:03 UTC
This might be related:

https://bugs.freedesktop.org/show_bug.cgi?id=31999
Comment 4 Guillermo Belli 2011-02-24 17:47:50 UTC
Updated today to version 3.3.1, and the bug is still present.
Comment 5 Cédric Bosdonnat 2011-02-25 05:11:47 UTC
this one is for me
Comment 6 Cédric Bosdonnat 2011-03-03 01:11:50 UTC
Duplicate of https://bugzilla.novell.com/show_bug.cgi?id=664516 that has been fixed already. in 3.3 branch
Comment 7 Cédric Bosdonnat 2011-03-03 01:12:45 UTC
*** Bug 31999 has been marked as a duplicate of this bug. ***