https://bugs.documentfoundation.org/show_bug.cgi?id=149665
--- Comment #10 from Mike Kaganski <mikekagan...@hotmail.com> --- Fun thing is, that FormulaLocal property and getFormula method already return doubled apostrophe (although incorrectly): ThisComponent.Sheets(0).getCellByPosition(0,0).formulaLocal = "'abc" msgbox ThisComponent.Sheets(0).getCellByPosition(0,0).formulaLocal This code will output ''abc, while the cell and input line will only show one apostrophe (as in the string set in the first line). -- You are receiving this mail because: You are the assignee for the bug.