Bug 158155 - Formula expressions not supporting Unicode symbols
Summary: Formula expressions not supporting Unicode symbols
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-10 09:37 UTC by simonm-personal
Modified: 2023-11-27 09:16 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description simonm-personal 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 (retired, only occasionally showing up) 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.