https://bugs.documentfoundation.org/show_bug.cgi?id=137203
Bug ID: 137203
Summary: Conditional Formats corrupted by save/exit/reload
Product: LibreOffice
Version: 7.1.0.0.alpha0+ Master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jim.av...@gmail.com
Description:
If a Conditional Format uses a formula which references columns via Named
Ranges, and the Named Ranges are not sheet-specific, then:
If a Save, Exit, and restart is done, the Conditional Formats are corrupted by
changing all the column references from non-sheet-specific to referencing a
*different* sheet (I suspect it is the last sheet).
However, just doing Save and Reload does _not_ cause the problem.
Steps to Reproduce:
0. Download attached "t.ods" and "tickers.csv" into /tmp
t.ods must be writable.
tickers.csv MUST be at the path /tmp/tickers.csv
Set Macro Security to "Medium" (Tools->Options->Security->Macro Security).
1. /path/to/soffice t.ods ; Enable macros when prompted
2. Click the yellow "Reload csv" button
(sheet looks correct);
3. File->Save
4. File->Exit
5. /path/to/soffice t.ods
(sheet looks wrong)
Actual Results:
After Step #2 (clicking "Reload csv"),
File->Format->Conditional->Manage
shows correct formulas which reference named columns like "Shading".
However after Save/Exit/Newstart/Load, the Conditional Format
formulas have been changed to specify another sheet, e.g. "TSLA.Shading".
Since the sheet references is not the same sheet, the results are
"interesting".
Expected Results:
.
Reproducible: Always
User Profile Reset: No
Additional Info:
(The "Reload csv" button runs a macro which reads /tmp/tickers.csv into the
SVXY sheet and copies the formats (but not data) from the _PROTO sheet,
including Conditional Formats.)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
