Bug 158155

Summary: Formula expressions not supporting Unicode symbols
Product: LibreOffice Reporter: Simon Mikkelsen <simonmik2006>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WONTFIX    
Severity: normal CC: ilmari.lauhakangas
Priority: medium    
Version: 7.6.2.1 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Simon Mikkelsen 2023-11-10 09:37:11 UTC 
Description:
the formula bar doesn't support the unicode symbols × ÷ ² (pivoted version of number, not fx ^2) used for calculations.

Steps to Reproduce:
1. open either writer or calc 
2. open a formula bar(an = in a cell in calc or by pressing F2 in writer)
3. use × or ÷ or ³ or ² in any calculaion


Actual Results:
**expession is faulty** error message in writer
Err:501 in calc

Expected Results:
that the equation would be calculated


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-DK (en_DK.UTF-8); UI: en-US
Flatpak
Calc: threaded
Comment 1 Eike Rathke 2023-11-10 10:50:29 UTC 
Unrelated to "formula bar" (in Calc it's the Input Line btw and Writer is completely different anyway) or not, these Unicode math signs and superscript digits are not accepted in formula expressions. I also don't see a compelling reason to do so. Next step someone would be complaining about =3² not being accepted and resulting in 9, or square/cube/fourth root characters, and so on. And then all the 50 MATHEMATICAL * DIGIT * characters. In any case, such characters would not be preserved after input once tokenized and transformed to operators and numbers, least when storing to file because the formula standard does not allow them.
Comment 2 Buovjaga 2023-11-27 09:16:19 UTC 
Let's close.