https://bugs.documentfoundation.org/show_bug.cgi?id=149665
--- Comment #13 from Eike Rathke <er...@redhat.com> --- Yes, an input of ''1 in a not as Text formatted cell should produce '1 that when edited is presented as ''1 again if the cell is not formatted as Text. I wouldn't change the behaviour though that an input of 'text is literally taken as text input without stripping the ' apostrophe. It works like this for decades and people are used to. Accordingly, ''text is literal, not replacing the double '' with a single '. There's no compelling reason to change that. Of course ThisComponent.Sheets(0).getCellByPosition(0,0).formulaLocal in the example giving ''abc is wrong in that context. -- You are receiving this mail because: You are the assignee for the bug.