Bug ID: 115654
           Summary: EDITING: Copied column/row labels reference wrong cell
                    until file is reloaded, Part 2
           Product: LibreOffice
           Version: release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

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

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

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to