[Libreoffice-bugs] [Bug 131938] New: If a data range is defined in a document, it is partly translated in formulas into the normal cell range after saving and re-opening the document

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131938

            Bug ID: 131938
           Summary: If a data range is defined in a document, it is partly
                    translated in formulas into the normal cell range
                    after saving and re-opening the document
           Product: LibreOffice
           Version: 7.0.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dscheikey at gmail.com

Description:
If a data range is defined in a .ods document, it is in formulas partly
translated into the normal cell range (A1:A30) after saving and re-opening the
document. 
This happens in formulas in which only a part of the data range has been
addressed. So in my case with 'data[columnA]' a column of my data range. If you
then want to change the data range, this does not work for the previously
defined part of the data range. Formulas with the whole data range (in my case
'data') survive the save and reopen process.
If you save the document in .xlsx the data part of the data range is kept. This
is also the reason why I uploaded the example document in .xlsx. So you can see
the before/after effect. Please open the document and save it as .ods. Note the
differences in the cells d4, d7 and d10.
It does not matter if the data range is connected to a data source. There the
effect is the same.

Also I am annoyed that I address the whole range with data also with column
headers. See formula COUNTA.
With the exact specification of the column it is done correctly in my eyes. It
is counted without column headers.

Steps to Reproduce:
1. Define Range: a Cell range in your sheet
2. write a formula like COUNTA with the name of the range with the name of the
column. E.g. data[columnA]
3. save your document ind ods format.
4. Re-open the document


Actual Results:
The formula is translated to cell area like A1:A30

Expected Results:
still the name from the data range with the name of the column


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: d43d2662ff64c613740080e166d1046214edb0f0
CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-GB
Calc: threaded

-- 
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/20200406/5d5959f1/attachment-0001.htm>