Bug 86999 - Calc add a "0" in the cell reference when the argument are separated by a colon "," rather than a semi-colon ";"
Summary: Calc add a "0" in the cell reference when the argument are separated by a col...
Status: RESOLVED DUPLICATE of bug 69479
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-04 10:36 UTC by Pierre van Male
Modified: 2015-04-25 15:41 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Simple Calc sheet with the formula (11.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-04 10:36 UTC, Pierre van Male 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre van Male 2014-12-04 10:36:26 UTC 
Created attachment 110449 [details]
Simple Calc sheet with the formula

when inserting a new LEFT() function, Calc insert the "0" character at the cell formula and the function return the Err:509

For example, I enter the formula "=LEFT(A2,2)", click on "Enter". The cell containing the formula shows "Err:509" and if I select it, the formulat contained is "=LEFT(A20,2)". Editing the formula does not helps.
Comment 1 Pierre van Male 2014-12-04 10:43:02 UTC 
Made the formula with the wizard and I realized that in Calc, the parameters must be separated by a semi-colon ";" and not a colon alike in Excel...

Still, Calc should not add the "0" in the formula, but at least, once entered properly, it works...

Should the bug b
Comment 2 Urmas 2014-12-04 15:49:43 UTC 

*** This bug has been marked as a duplicate of bug 69479 ***