| Summary: | ** Expression is faulty ** in every cell in Writer tables | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Guillermo Belli <gbelli> |
| Component: | Writer | Assignee: | Cédric Bosdonnat <cedric.bosdonnat.ooo> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | CC: | gbpacheco |
| Priority: | high | ||
| Version: | 3.3.0 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | A test file that reflects the bug | ||
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. (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! This might be related: https://bugs.freedesktop.org/show_bug.cgi?id=31999 Updated today to version 3.3.1, and the bug is still present. this one is for me Duplicate of https://bugzilla.novell.com/show_bug.cgi?id=664516 that has been fixed already. in 3.3 branch |
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.