[Libreoffice-bugs] [Bug 137203] New: Conditional Formats corrupted by save/exit/reload

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: jim.avera at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201002/de9b7950/attachment.htm>