https://bugs.documentfoundation.org/show_bug.cgi?id=152107
Bug ID: 152107
Summary: Clicking on a cell shows garbage as the formula
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a spreadsheet containing my annual household budget. The sheet has a
multiple of cells that contain @SUM() statements. If I double click on the
cell (e.g. N35), I see the cell formula (as expected). If I double click on
another cell (e.g. N34), cell N35 is replaced with garbage that is a
combination of N45 and N45. If I repeat this sequence but hit the ESC key to
clear the contents of N34, cell N34 will display as expected (i.e. in N34 and
with the correct formula).
Steps to Reproduce:
1.Create a budget style spreadsheet. Mine has a description column, 12 monthly
expense columns and a final Total column. Populate some data in the 12 monthly
columns for several budget items. In the Total column, use the @SUM() formula
to calculate the sum of the 12 monthly values. Finally, create a new row which
is uses the @SUM() formula to summarize each column.
2. Double Click on the final cell in the Total column.
3. Double Click on the cell above the final cell in the Total column
Actual Results:
At Step (2), the selected Cell contains the correct formula.
At Step (3), the selected Cell contains garbage.
Expected Results:
At step (3), I expect the cell contents to be displayed correctly.
Reproducible: Always
User Profile Reset: No
Additional Info:
I can create screen shots of this sequence if that facilitates recreating the
issue.
Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
