| Summary: | Error calculating in LibreOffice Calc | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jeez <brampapashi> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | major | CC: | jbfaure, serval2412 |
| Priority: | medium | ||
| Version: | 4.2.4.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | All | ||
| Whiteboard: | (target:4.2.5) | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Error calculating in LibreOffice Calc
Full document |
||
Please, could you explain how this spreadsheet is build. I see many reference errors. Set status to NEEDINFO, please, reset status to UNCONFIRMED when you have provided requested informations. Best regards. JBF Created attachment 100502 [details]
Full document
Here's the full version of the document. In line "39", column "EL" MS Office and Open Office give value 192684596.00. It is true. Libre Office Calc,version 4.2.4.2, give value 181830171.00. It is wrong. How this table is built is unknown (In reply to comment #3) > Here's the full version of the document. > In line "39", column "EL" MS Office and Open Office give value 192684596.00. > It is true. > Libre Office Calc,version 4.2.4.2, give value 181830171.00. It is wrong. Thank you for the full document. For me LO 4.2.6.0.0+ and LO 4.3.0.0.beta2+ under Ubuntu 14.04 x86-64 give the correct value. Please, could you, try LO 4.2.5 RC1 : https://www.libreoffice.org/download/libreoffice-fresh/?version=4.2.5 ? Best regards. JBF Could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile) and give it a new try? (Even if it can sound weird, it helped someone on a tracker some days ago) (In reply to comment #6) > Could you rename your LO directory profile (see > https://wiki.documentfoundation.org/UserProfile) and give it a new try? > (Even if it can sound weird, it helped someone on a tracker some days ago) Rename LO directory profile (No longname, redirect to C:\Temp)did not bring the desired result, sorry. (In reply to comment #5) > (In reply to comment #3) > > Here's the full version of the document. > > In line "39", column "EL" MS Office and Open Office give value 192684596.00. > > It is true. > > Libre Office Calc,version 4.2.4.2, give value 181830171.00. It is wrong. > > Thank you for the full document. For me LO 4.2.6.0.0+ and LO 4.3.0.0.beta2+ > under Ubuntu 14.04 x86-64 give the correct value. > Please, could you, try LO 4.2.5 RC1 : > https://www.libreoffice.org/download/libreoffice-fresh/?version=4.2.5 ? > > Best regards. JBF Yes, LO 4.2.5.1 give value 192684596.00, it is correct. This bug I was looking in version 4.2.4.2 for Windows and 4.2.3.3 3.13.0-27-generic x86_64 GNU/Linux. So, bug is fixed? Jeez: following your last comment, let's consider it's fixed. You can reopen this tracker if you still reproduce this of course. |
Created attachment 100496 [details] Error calculating in LibreOffice Calc The amount of cell EL1 is considered not true. MS Excel and OOo_3.2.1_Win_x86_portable give another correct value.