Bug 162070 - Some single characters in formulas are displayed as error (U+00BF ¿ INVERTED QUESTION MARK)
Summary: Some single characters in formulas are displayed as error (U+00BF ¿ INVERTED ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Formula Editor (show other bugs)
Version:
(earliest affected)
24.8.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 53358 76541 95230 98948 139194 151931 157157 162214 (view as bug list)
Depends on:
Blocks: DOCX-Formula Formula-Object
  Show dependency tree / graph
 
Reported: 2024-07-17 12:17 UTC by Piotr Osada
Modified: 2024-11-02 12:26 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:

Attachments
tdf#162070 single character formulas.pptx (79.93 KB, application/vnd.openxmlformats-officedocument.presentationml.presentation)
2024-07-17 12:28 UTC, Piotr Osada 		Details
Single character formulas.pdf (65.89 KB, application/pdf)
2024-07-17 12:29 UTC, Piotr Osada 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Piotr Osada 2024-07-17 12:17:23 UTC 
1    _
2    "
3    [
4    ]
5    /
6    \
7    &
8    #
9    `
10    ^
11    +
12    <
13    =
14    >
15    |
16    ~

These are single characters that could be displayed in MS Office formulas (Word, PowerPoint) but broken in LibreOffice formulas.

I'm aware, that most of them have some functions when building formulas, but IMHO in LO there should also be possibility to display these characters in single sign formulas. Such improvement would lead to MSO ⇋ LO interoperability.

Version: 24.8.0.1 (X86_64) / LibreOffice Community
Build ID: 6fd6cae02baed1e82d14ed2da1f2458092354dab
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: en-US
Calc: threaded
Comment 1 Piotr Osada 2024-07-17 12:28:24 UTC 
Created attachment 195348 [details]
tdf#162070 single character formulas.pptx
Comment 2 Piotr Osada 2024-07-17 12:29:19 UTC 
Created attachment 195349 [details]
Single character formulas.pdf

Demonstration graphics.
Comment 3 Piotr Osada 2024-07-17 12:37:03 UTC 
Parentheses "(" and ")" would also cause this problem if the Bug 158023 hadn't been resolved.
Comment 4 Mike Kaganski 2024-07-17 12:39:57 UTC 
We only need to import them in correct way, i.e. adding empty arguments (e.g.,  "/" in PPTX must get imported as "{}/{}"). No need to create more special cases.

This is import problem.
Comment 5 Mike Kaganski 2024-07-17 12:44:49 UTC 
(In reply to Piotr Osada from comment #3)
> ... Bug 158023 ...

Or escape them, like in that fix, yes.
Comment 6 Mike Kaganski 2024-07-26 16:25:44 UTC 
*** Bug 162214 has been marked as a duplicate of this bug. ***
Comment 7 Mike Kaganski 2024-11-02 05:50:40 UTC 
*** Bug 53358 has been marked as a duplicate of this bug. ***
Comment 8 Mike Kaganski 2024-11-02 06:05:19 UTC 
*** Bug 76541 has been marked as a duplicate of this bug. ***
Comment 9 Mike Kaganski 2024-11-02 06:09:45 UTC 
*** Bug 95230 has been marked as a duplicate of this bug. ***
Comment 10 Mike Kaganski 2024-11-02 06:17:39 UTC 
*** Bug 151931 has been marked as a duplicate of this bug. ***
Comment 11 Mike Kaganski 2024-11-02 06:17:59 UTC 
*** Bug 157157 has been marked as a duplicate of this bug. ***
Comment 12 Mike Kaganski 2024-11-02 06:50:39 UTC 
*** Bug 139194 has been marked as a duplicate of this bug. ***
Comment 13 Mike Kaganski 2024-11-02 12:26:39 UTC 
*** Bug 98948 has been marked as a duplicate of this bug. ***