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

            Bug ID: 115654
           Summary: EDITING: Copied column/row labels reference wrong cell
                    until file is reloaded, Part 2
           Product: LibreOffice
           Version: 6.0.1.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: gilward.ku...@gmail.com

Description:
Copied column/row labels reference wrong cell until file is reloaded.

Steps to Reproduce:
1. Make a new spreadsheet
2. enable Tools -> Options... -> LibreOffice Calc -> Calculate -> Automatically
find column and row labels
3. Enter these data into the first sheet:
        A1: a
        A2: 1
        A3: 2
        A4: 3
        B2: ='a'
        B2 now correctly shows 1 because it references A2.
4. select B2:B4 
5. press Ctrl+D for Fill Cells Down.

alternative steps:
4'. go to B2
5'. drag the fill handle to B3 and B4

alternative steps:
4''. go to B2 and press Ctrl+C
5''. select B2:B4 or B3:B4 and press Enter or Ctrl+V



Actual Results:  
B3 and B4 wrongly also show 1 because they also reference A2.

Steps 4'' and 5'' only produce the bug in the first sheet.

Expected Results:
B3 should reference A3 and show 2.
B4 should reference A4 and show 3.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
When you save and reload the file it is correct.

Similar to the fixed bug
https://bugs.documentfoundation.org/show_bug.cgi?id=105245


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:56.0) Gecko/20100101
Firefox/56.0

-- 
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

Reply via email to