CellValue that starts with an apostrophe is used as plain text

[wojciechczerniak]

Description

Cell values with an apostrophe as the first characters are of a special kind. Example:
'1234
'=SUM(1, 2, 3)
Those are numbers or formulas that are stored as a text.

	A (value)	B (formula)	Expected	Result
1	`1234	=A1+2	1236	Error
2	`1234	=A2&"text"	1234text	'1234text
3	1234	=A3&"text"	1234text	1234text
4	`=SUM(1,2,3)	=A4&text	=SUM(1,2,3)text	`=SUM(1,2,3)text

ODFF

I can't find a spec for this behavior. Although all spreadsheet apps are handling this as an escape character for the whole cell.

Links

Use VALUE function to get the value: https://libreofficehelp.com/convert-text-to-number-in-libreoffice-calc/

[izulin]

solved??? #169