https://bugs.documentfoundation.org/show_bug.cgi?id=167494
Bug ID: 167494
Summary: LO Calc v7.2 > 25.2x [EDITING] - error msg "you cannot
change only part of an array" - merged cells area lock
/ uncancellable
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hi,
The bug occurs when validating array formula (containing cells area param eg
A1:A100) with ctrl+alt+shift on merged cells area containing the formula. Uhe
used formula here is textjoin(),.
On the contrary, when merging the cells after validating the formula as an
array formula, the error message does not appear so I can modify the formula or
undo the cell merge but ONE TIME ONLY after array validating. Next try to edit
shows error message.
I know it is not necessary converting into array formula for this particular
formula, but it is an old habit of mine.
Despite this, I'm convinced this is an abnormal issue.
As a possible solution, I suggest preventing the transformation into an array
formula when it's not necessary (as in the case of textjoin()).
Furthermore, when the problem described is already written in the sheet's data
structure, it is necessary to allow the cancellation of the array formula
(removing the {} from either side of the formula by editing again) and to allow
undo of merged cells then to permit deletion of cells selected by the user.
Steps to Reproduce:
1. Type in a cell a formula with cells area param
2. Merge some cells following including the previous one
3. Enter merged cells area for editing then validate again the formula with
ctrl+alt+shift keys combination
Actual Results:
When you try to edit again the merged cell area, the error message "You cannot
change only part on an array" occurs. So you cannot modify formula anymore.
Likewise, the merged cells cannot be unmerged. Otherwise same error message pop
up.
Expected Results:
Normal editing formula content for modification and validation. Normal
unmerging merged cells group.
Reproducible: Always
User Profile Reset: No
Additional Info:
I dit not try to reset user profil on my personnal computer because bug also
occurs on libreoffice 7.2 and v25.2x on my computer office. Each user profil
are different ones since separate installation.
--
You are receiving this mail because:
You are the assignee for the bug.
