Bug 145641 - Cell sum number with apostrophe
Summary: Cell sum number with apostrophe
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-11-12 09:53 UTC by Alberto
Modified: 2021-11-12 11:34 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alberto 2021-11-12 09:53:24 UTC
Strange sum from number and text
For example:

A1=1
A2='2
A3=3

A4=SUM(A1:A3) result = 4 correct (for me)
A5=A1+A2+A3   result = 6 is correct? Is a bug? For me is ambiguous
Note that A6='2 +'3 result Err:509

Thanks