Bug 145641

Summary: Cell sum number with apostrophe
Product: LibreOffice Reporter: Alberto <benedetto.alberto>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED NOTABUG    
Severity: normal    
Priority: medium    
Version: 7.2.2.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

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