Bug 69479 - Formula is getting corrupted after input
Summary: Formula is getting corrupted after input
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.6.2 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
: 86999 (view as bug list)
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2013-09-17 16:43 UTC by Urmas
Modified: 2018-12-31 15:36 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
The formula (6.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-18 13:31 UTC, Urmas
Details
Screenshot with the error in the status bar. (87.10 KB, image/png)
2014-03-03 00:46 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Urmas 2013-09-17 16:43:13 UTC
Enter in any cell:
=sum(5,11,26,38,17,55)
Calc will translate that formula into:
=SUM(5,110,260,38,17,55)
Extra zeroes cannot be deleted.
Comment 1 Tomaz Vajngerl 2013-09-17 19:10:59 UTC
Shouldn't it be =SUM(5;11;26;38;17;55)
Comment 2 Doug Naphas 2013-11-18 09:24:16 UTC
@Urmas, I entered the formula exactly as shown here, and it was not corrupted.  Please attach a spreadsheet with 0's added that cannot be deleted.

@Tomaz Vajngerl, Calc of the version in this bug on my system (Ubuntu 12.04) accepts commas.
Comment 3 Urmas 2013-11-18 13:31:38 UTC
Created attachment 89408 [details]
The formula
Comment 4 Urmas 2013-11-18 13:33:00 UTC
Additionally, after loading a saved document, there are periods (.) appearing in the formula.
Comment 5 GerardF 2013-11-18 14:42:01 UTC
I'm reproducing the result =SUM(5,110,260,38,17,55) in formula bar and ERR509 in the cell when using the wrong parameter separator according to my locale. (comma instead of semi-colon)

If I use the correct separator (semi-colon for French_FR) formula and his result is correct.
Comment 6 m.a.riosv 2014-03-03 00:25:38 UTC
I have the same results as Gerard.

Changing the separator in Menu/Tools/Options/LibreOffice calc/Formula - Separator - Functions, to comma then there is no issue with the formula.

For me there is not a bug.
Comment 7 Urmas 2014-03-03 00:37:52 UTC
If the formula is incorrect, it should be reported as such, and not be transformed arbitrarily. That is definitely a bug.
Comment 8 m.a.riosv 2014-03-03 00:46:33 UTC
Created attachment 94994 [details]
Screenshot with the error in the status bar.

In the status bar is showed an error:
'Error: Invalid name'
I think for calc it is a text without quotes and try to find a range name, what of course it doesn't find.
Comment 9 m.a.riosv 2014-03-03 01:11:42 UTC
But you are right, adding zeroes is a bug and the change with save and reopen.
Comment 10 Urmas 2014-12-04 15:49:43 UTC
*** Bug 86999 has been marked as a duplicate of this bug. ***
Comment 11 QA Administrators 2016-09-20 10:17:54 UTC Comment hidden (obsolete)
Comment 12 Stanislav Horacek 2016-09-21 20:32:01 UTC
Reproducible in 5.2.1 and current master (Kubuntu 16.04).

Also checked in old versions: 3.5.4 and 3.6.5 not reproducible, 4.0.6 reproducible -> regression between 3.6 and 4.0.
Comment 13 m.a.riosv 2016-09-21 23:26:30 UTC
Hi @Stanislav, what is you default separator?
Comment 14 Stanislav Horacek 2016-09-22 18:50:47 UTC
I tested this with the same setup as bug reporters had: semicolon as the separator and incorrectly used commas in formula. (There was a change from comma to semicolon in the default separator between 3.6 and 4.0, so it might be related to the regression.)
Comment 15 QA Administrators 2017-11-14 08:58:14 UTC Comment hidden (obsolete)
Comment 16 Stanislav Horacek 2017-11-16 21:59:32 UTC
Still reproducible with the same result in 5.4.1 and in:
Version: 6.0.0.0.alpha0+
Build ID: 141fe1c5e7fbf67a083b34e49e19b6ea78a0eb2b
Comment 17 Xavier Van Wijmeersch 2018-04-29 16:33:33 UTC
Still reproducible with the same result

Version: 6.1.0.0.alpha1+
Build ID: 212807f77b78c69263f8aae51dcdc73e8017c53a
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 18 Buovjaga 2018-06-30 16:34:07 UTC
(In reply to Stanislav Horacek from comment #14)
> I tested this with the same setup as bug reporters had: semicolon as the
> separator and incorrectly used commas in formula. (There was a change from
> comma to semicolon in the default separator between 3.6 and 4.0, so it might
> be related to the regression.)

I was going to bibisect this, but I do not reproduce the appearing of zeroes, when I do it from scratch. Also, I can delete the extra zero from the example file in any version.
Comment 19 Stanislav Horacek 2018-12-31 14:17:14 UTC
For me it is still reproducible with the addition of extra zeros in:

Version: 6.3.0.0.alpha0+
Build ID: ac7508c31873d79e56b406c9bf931caae63d4975
CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-12-14_16:04:08
Locale: cs-CZ (cs_CZ.UTF-8); UI-Language: en-US
Calc: threaded
Comment 20 Xavier Van Wijmeersch 2018-12-31 15:36:35 UTC
formula with semi-colon i have 152 as result, but with comma error code 509 and extra zeroes

Version: 6.3.0.0.alpha0+
Build ID: aeb54120a47768ca3dc92f5bbb715ee491646e48
CPU threads: 2; OS: Linux 4.19; UI render: default; VCL: gtk2; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded