[Libreoffice-bugs] [Bug 142635] New: Copy+paste a sheet with chart results in incorrect chart's data ranges

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142635
           Summary: Copy+paste a sheet with chart results in incorrect
                    chart's data ranges
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: xiscofauli at libreoffice.org

Created attachment 172591
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172591&action=edit
Testdoc from sc/qa/uitest/data/chartWithDotInSheetName.ods

This is created from the test in
https://git.libreoffice.org/core/+/752a6d58a440e2cb84e0f84d3e12dd52efd016eb.

1. Open attached document, check that its chart's data series' values are like
"$'Sheet.1'.$B$12:$B$18".
2. On the sheet, select all (Ctrl+A), can copy (Ctrl+C).
3. Close the doc (not the application), and create a new spreadsheet.
4. In the new spreadsheet, rename the first sheet to "Sheet.1" (not really
necessary, but I'm just following the existing unit test).
5. Paste (Ctrl+V)
6. Inspect the pasted chart's data series.

Expected: the series are like "$'Sheet.1'.$B$12:$B$18".
Actual: they are like "'file:///D:/Documents/Sheet.1'#$Sheet1.$B$12:$B$18".

I assume this works as expected on Linux (the unit test likely runs on linus in
our CI). But this fails on Windows, with both Version: 7.1.4.1 (x64) /
LibreOffice Community
Build ID: f67b1ddedeb24fca1c5938e7cebfab73d708b35b
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

and current master Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 027c7b411389127d77a271e53922edb4d7095a2e
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL.

-- 
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/20210603/dff9ec28/attachment.htm>