https://bugs.documentfoundation.org/show_bug.cgi?id=171165
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Documentation |Calc Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #7 from Mike Kaganski <[email protected]> --- So, the bug is: for a SMP character, a formula like =LENB("🙁") gives 2 in Excel, 4 in Calc. Excel also considers code units (it does not handle the emoji as DBCS: it simply counts the two surrogates); but Excel does not consider surrogates DBCS, which is unlike Calc. The expected result is: functions LENB and others, introduced for interoperability, should match what Excel does. That (1) matches their ODFF definition; and (2) improves interoperability. -- You are receiving this mail because: You are the assignee for the bug.
