Docs: document apostrophe as an explicit string literal trigger

[sequba]

Description

It's an undocumented feature

By starting the cell content with ' character (apostrophe) our parser treats the rest of it as string. It is a way to prevent automatic conversion strings to number, date and time values.

Links

https://handsoncode.slack.com/archives/C031GBX62SE/p1667382294314379 (internal discussion)
#959

hyperformula/test/CellContentParser.spec.ts

Lines 128 to 135 in fd0a405

	it('starts with \'', () => {
	expect(cellContentParser.parse('\'123')).toEqual(new CellContent.String('123'))
	expect(cellContentParser.parse('\'=1+1')).toEqual(new CellContent.String('=1+1'))
	expect(cellContentParser.parse('\'\'1')).toEqual(new CellContent.String('\'1'))
	expect(cellContentParser.parse('\' 1')).toEqual(new CellContent.String(' 1'))
	expect(cellContentParser.parse(' \'1')).toEqual(new CellContent.String(' \'1'))
	expect(cellContentParser.parse('\'02-02-2020')).toEqual(new CellContent.String('02-02-2020'))
	})

Type of issue

• Missing documentation
• Error in the documentation
• Request for a demo
• Request for a tutorial, guide etc.
• Other issues, suggestions or ideas

[sequba]

Possible duplicate: #1087

[sequba]

Another question related to that: #1326

[AMBudnik]

Fixed with #1334 in HyperFormula 2.6.1