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:
: 162214 (view as bug list)
Depends on:
Blocks: Formula-Object
  Show dependency treegraph
 
Reported: 2024-07-17 12:17 UTC by Piotr Osada
Modified: 2024-07-26 16:25 UTC (History)
3 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

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. ***