https://bugs.documentfoundation.org/show_bug.cgi?id=153355
Bug ID: 153355
Summary: Merging vertically adjacent cells turns a formula into
data if the formula is the lower cell in the merge
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If two vertically adjacent cells contain a formula in the lower cell and those
two cells are "merged" it turns the formula into hard data in the merged cells.
It doesn't become apparent until the merged cells are drag filled to the right
to replicate the formulae. Then it just becomes an incremental increase of
"edited" data
Steps to Reproduce:
With the attached sample sheet observe the formula in the merged cells C9:C10
Observe that the formula has been replicated by drag-filling to the adjacent
cells.
Unmerge C9:C10 and observe that the formula is written into the upper cell C9
Observe the formula in C13
Select C12:C13 and merge
Looks OK but now drag-fill the merged cell structure to L12:L13
Observe that the formulae have become edited data in C12:C13 which was simply
incremented by 1 as it was dragged
2.
3.
Actual Results:
Formula in the merged structure is transmuted to data as if it were a paste
special operation
Expected Results:
Retained the Intact formula in the merged structure
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
