Bug 92981 - Wrong error in bracketing from xls file
Summary: Wrong error in bracketing from xls file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.4.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS Calc-DataRange
  Show dependency treegraph
 
Reported: 2015-07-28 14:38 UTC by Rpnpif
Modified: 2019-02-05 14:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
File example from link (10.35 KB, application/vnd.ms-excel)
2019-02-05 14:22 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rpnpif 2015-07-28 14:38:13 UTC
In some calc file, a formula gets bracketing errors, but there are not real errors, I think.

To reproduce that, load the file from http://www.calculette.net/file/taux.xls.

The formula =(B1*Taux/12*(1+Taux/12)^B3)/(((1+Taux/12)^B3)-1) has bracketing in B4 cell.

If I click on formula icon to edit, then I click on OK, the error disappears. But errors are still here in B12 cell. The automatic calculate and manual with F9 seem not work.

Same procedure with the formula icon on each erroneous cells seems resolve the errors.

This should not be.
Comment 1 m.a.riosv 2015-07-28 19:57:36 UTC
Hi @Rpnpif, thanks for reporting.

Even hard recalc doesn't solve the issue, only edit manually does.

Win7x64Ultimate
Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99
Version: 5.0.0.4 (x64) Build ID: cf112dc905650fb985306a7a03d2fe3fcc6c978f
Comment 2 Rpnpif 2015-12-27 11:00:32 UTC
Same issue with :
Version: 5.1.0.1 (x64) Build ID: bcace328aabc4c8c10b56daa87da0a2ee6579b5a
on Debian 8.2 (amd64).
Comment 3 Rpnpif 2016-04-18 14:02:32 UTC
This issue is still existing in 5.0.6.1.
Comment 4 QA Administrators 2017-05-22 13:22:42 UTC Comment hidden (obsolete)
Comment 5 m.a.riosv 2017-05-22 22:20:20 UTC
Still.
Version: 5.3.3.2 (x64)
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Comment 6 Rpnpif 2017-05-23 12:49:50 UTC
Yes still here in 5.3.3.2, but with a little change :
I must change the formulas, for example, deleting the last bracket then restoring this, to fix the formulas.

So the bug is still here.
Comment 7 QA Administrators 2018-05-24 02:46:18 UTC Comment hidden (obsolete)
Comment 8 Rpnpif 2018-05-25 08:22:15 UTC
This issue is still present in LO 6.0.4.

Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
Threads CPU : 2; OS : Linux 4.9; UI Render : par défaut; VCL: gtk2; 
Locale : fr-FR (fr_FR.utf8); Calc: group
Comment 9 Roman Kuznetsov 2019-02-05 14:22:32 UTC
Created attachment 148925 [details]
File example from link
Comment 10 Roman Kuznetsov 2019-02-05 14:30:42 UTC
still repro in

Version: 6.3.0.0.alpha0+
Build ID: ed707a4806a489467c6d9be7d1b787dab94b5f78
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded