https://bugs.documentfoundation.org/show_bug.cgi?id=131828
--- Comment #4 from Heiko Tietze <heiko.tie...@documentfoundation.org> --- <18>Hello</18> World => 10 //cell content partly direct formatted as 18pt Hello <18>World</18> => 10 <18>Hello World</18> => 18 //all cell content direct formatted as 18pt <18>Hello World</18> => 10 //white space w/o formatting before <18>Hello World</18> => 10 //white space w/o formatting after The cell content here is <text:span text:style-name="T1">5</text:span><text:span text:style-name="T2">1</text:span> (with T1 <> T2). Sounds like NAB to me. PS: Ctrl+M clears direct formatting, and View > Value Highlighting helps to identify data mistakenly formatted as text. -- You are receiving this mail because: You are the assignee for the bug.