https://bugs.documentfoundation.org/show_bug.cgi?id=153281
--- Comment #2 from Eike Rathke <[email protected]> --- Note that the input of 1/4 getting converted to U+00BC ΒΌ happens already on editing level, hence the input the cell receives is already text. Whatever number format is applied to the cell does not matter at that stage. To prevent that from happening, disable Tools -> AutoCorrect Options..., tab Options, "Use replacement table"; or disable individual fraction replacements in the Replace tab's table. Also, if AutoCorrection was already applied, pressing Ctrl+Z once will undo that step and the original input of 1/4 will be re-fed to the cell, resulting in date. CELL("FORMAT") returns date because that is the cell's number format. All other functions you list work on the _content_ of the cell, which is of type Text. -- You are receiving this mail because: You are the assignee for the bug.
