https://bugs.documentfoundation.org/show_bug.cgi?id=165383
Bug ID: 165383
Summary: Rules resolution on save break format conditioning on
load
Product: LibreOffice
Version: 24.8.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When the spreadsheet is saved (at lead on Excel xlsx format) the specific
formula, e.g., `SUM($K$9:K9)` is resolved to `SUM($K$9:K9)`. This is not a
problem when it is used to expand through the column.
The problem lies when I use such formula for a column in a Conditioning Format
in the RANGE K9:Kinf. To the cell K9, as typed in the dialog, must be applied
the rule `SUM($K$9:K9) > 10`, for example, wich implies in `SUM($K$9:K10)` to
cell K10 and so on.
This construction works fine until ans save and resolve the file: all this kind
of formula `SUM($K$9:K9)` became `SUM($K$9)`, which is not a problem in the
spreadsheet cells it self. But it broke the Condition Formatting behavior
intended, as above.
I just checked save to ODS file and it appear fine
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 4:24.8.5~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
Steps to Reproduce:
1. Create a spreadsheet and fill the K9:K12 column with values [0, 5, 10, 15];
2. Add a conditining format SUM($K$9:K9) > 10`;
3. Save the file.
Actual Results:
The conditioning format get applied to K11 and K12, because of the resolution
of `SUM($K$9:K9) > 10`. But after reopen the saved XLSX file the formula became
`SUM($K$9) > 10`and the rule incorrect applied.
Expected Results:
The first result before save the file.
Reproducible: Always
User Profile Reset: No
Additional Info:
Since the error appear not be present at ODS file, it may be the save/open
XLS/XLSX routines.
It is necessary to check if the Microsoft Excel present save issue to "keep the
issue compatibility"?
--
You are receiving this mail because:
You are the assignee for the bug.
