Bug 166525 - [25.8] Editing a formula, the results are displayed at the same time
Summary: [25.8] Editing a formula, the results are displayed at the same time
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2025-05-11 11:53 UTC by nobu
Modified: 2025-05-21 09:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sample png (30.23 KB, image/png)
2025-05-13 00:51 UTC, nobu
Details
sample file (16.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-05-13 00:52 UTC, nobu
Details
Screenshot (15.03 KB, image/png)
2025-05-13 06:09 UTC, m_a_riosv
Details
Screenshot with 25.8 (7.67 KB, image/png)
2025-05-13 06:40 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nobu 2025-05-11 11:53:15 UTC
Description:
Editing a formula, the results are displayed at the same time.

Steps to Reproduce:
1. Open new Calc.
2. Insert formula "=1" in Cell [ A1 ].
3. Edit cell formula by [F2] key.

Actual Results:
4. The formula and the results are displayed at the same time.

Expected Results:
4. No results will be displayed in the cell.


Reproducible: Always


User Profile Reset: No

Additional Info:

It may be useful for short formulas and short results, but they overlap and become difficult to see in general formulas.

Not reproduced with
 (2025-04-26)
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e4fb32ffef1630ceaf5a0a77307e02ae93c9f8f4
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded

Reproducible with
[2025-05-09]
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9bc5b89c149497a83117edfadc3fb0b96d2f9899
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded
Comment 1 m_a_riosv 2025-05-12 00:29:17 UTC
Please attach a screenshot on how do you see it.
Comment 2 nobu 2025-05-13 00:51:56 UTC
Created attachment 200760 [details]
sample png

I don't understand the meaning of the question.
However, I'll attach a sample that I think is unnecessary.
Attach the image when editing cell [A2].
Comment 3 nobu 2025-05-13 00:52:44 UTC
Created attachment 200761 [details]
sample file
Comment 4 m_a_riosv 2025-05-13 06:09:34 UTC
Created attachment 200764 [details]
Screenshot

Please test modifying, even disabling Skia options.
Menu>Tools>Options>LibreOffice>View
Comment 5 m_a_riosv 2025-05-13 06:40:35 UTC
Created attachment 200766 [details]
Screenshot with 25.8

Ok the previous screenshot was with 25.2.3

In other test I can see it with
Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 19f3b72f34c487dc97d582712d21734a7e055fd5
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-GB
Calc: CL threaded
Comment 6 m_a_riosv 2025-05-13 06:42:11 UTC
BTW changing Skia options or disabling doesn't solve the issue.
Comment 7 nobu 2025-05-13 07:04:47 UTC
(In reply to m_a_riosv from comment #6)
> BTW changing Skia options or disabling doesn't solve the issue.

Yes.
Comment 8 nobu 2025-05-14 18:41:43 UTC
For the most obvious explanation, I have explained it in formulas and results, but there is a similar problem with text and numbers.
This problem must be more important.
And it may have been created with the same commit as the bug below.

https://bugs.documentfoundation.org/show_bug.cgi?id=166520
https://bugs.documentfoundation.org/show_bug.cgi?id=166559
Comment 9 Saburo 2025-05-15 03:01:35 UTC
(In reply to nobu from comment #8)
> For the most obvious explanation, I have explained it in formulas and
> results, but there is a similar problem with text and numbers.
> This problem must be more important.
> And it may have been created with the same commit as the bug below.
> 
> https://bugs.documentfoundation.org/show_bug.cgi?id=166520
> https://bugs.documentfoundation.org/show_bug.cgi?id=166559

right.
bibisected with linux-64-25.8

author	Armin Le Grand (Collabora)
commit f678ec9a65c4d7ae2d4dda4599a06fc4b66a27d8

CEOO: CellEditOnOverlay
Instead of using EditView's Paint directly to Window I
changed this now to using the Overlay that is available in
all applications. This allows to have less repaints of the
Calc View since the Overlay has a copy of the area it is
working overlayed.
It also allows to get away from one of the last areas where
XOR selection was used since EditView/EditEngine have no
better way to do this. Selection is now visualized using the
OS'es choosen SelectionColor, as in all other apps.
I could also get rid of the flush() of the OverlayManager
that was needed before and caused some problems (see
tdf#165621 and associated tasks).
A failing UnitTest showed that OverlayManagerBuffered needs
to be aware when no CompleteRedraw was done yet and thus no
background data exists and refresh makes no sense. This may
happen when there is no redraw/UI e.g. UnitTests, but still
an OverlayManager is used and together with a Reschedule
(many possible reasons) that refresh might be triggered.
Made access to EditView in OverlayObject no longer dependent
on ActiveView, that is not always the one with the EditView.
Now using a combination of ScTabView and ScSplitPos for
accesses. Asserting now if no EditView -> is mandatory.
Continuing going through CppunitTest_sc_tiledrendering UTs,
one more identified.
Have to re-activate EditViewInvalidate rect forwarding
since the Invalidate is needed for sc tiled rendering
tests, but not for sd tiled rendering tests. Added that
to the impl of EditViewCallbacks using
LibreOfficeKit::isActive().

Change-Id: I41f5448bfbabfaae4858c7617478771053c2cd77
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/184830