https://bugs.documentfoundation.org/show_bug.cgi?id=169082
Bug ID: 169082
Summary: Overwriting a formula hides the contents of cells
adjacent to it.
Product: LibreOffice
Version: 25.2.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I select a cell containing a formula and overwrite it by entering, for
example, a numerical value, the cells to its right are “hidden,” meaning that
their contents are not displayed for the length of the formula that was present
in the cell in question. For example, if I have a cell with this formula:
=ROUND(ROUND(D218*((100-E1)/100);2)*3;2) and I overwrite it by entering 40, the
cells to its right no longer show the content up to the length of the formula
(the length can be seen by double-clicking in the cell and entering the formula
edit mode).
To make the cells visible again, just click on them.
I have tried various new and old versions and changed the file save type, but
the problem persists.
Translated with DeepL.com (free version)
Steps to Reproduce:
1.Enter a long formula in a cell, such as
=ROUND(ROUND(D218*((100-E1)/100);2)*3;2)
2.enter random data in at least two or three cells to the right of it
3.Click in the cell with the formula and type in any number to overwrite it.
Actual Results:
The values entered in the cells to the right of the cell with the formula will
be hidden.
Expected Results:
The values entered in the cells to the right of the cell with the formula
should not disappear.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 14; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
Skia/Vulkan; VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
