Bug 126463 - LibreOffice changed the formula and reported err510
Summary: LibreOffice changed the formula and reported err510
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-07-18 16:23 UTC by Greg
Modified: 2019-07-18 16:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Greg 2019-07-18 16:23:48 UTC 
Description:
if I typed =countif(b2:z2; <6) Libra changed it to =countif(b2:z2, <6) then placed an err510 message in the cell.

Actual Results:
type =countif(b2:f2; <6) in a cell

Expected Results:
Libra changed it to =countif(b2;f2, <6) than placed err510 in the cell


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 Oliver Brinzing 2019-07-18 16:41:00 UTC 
(In reply to Greg from comment #0)
> if I typed =countif(b2:z2; <6) Libra changed it to =countif(b2:z2, <6) then
> placed an err510 message in the cell.

please try:

=countif(b2:z2;"<6")

https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060181.html?System=WIN&DbPAR=CALC#bm_id3164909