https://bugs.documentfoundation.org/show_bug.cgi?id=91842
Bug ID: 91842
Summary: EDITING: Moving a cell with Table structured
references change the reference.
Product: LibreOffice
Version: 5.0.0.0.beta1
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 116265
--> https://bugs.documentfoundation.org/attachment.cgi?id=116265&action=edit
Sample ods file to test Table structured references.
Steps to reproduce the issue with the attached file.
To regenerate Table Reference formulas:
1 Open sample file
2 Copy M3:M10 to K3
3 Find & Replace
4 Find: .+
5 Replace: &
6 Mark: Current selection only and Regular expressions
7 Replace all
How to reproduce the issue:
Original value in K7 273,5
Original formula in K7 =AVERAGE(population[DoubYears])
1 Cut K7
2 Paste in L1
Actual value in L1 18139433,5714286
Actual formula in L1 =AVERAGE(population[DoubYears])
3 Cut L1
4 Paste in K7 again
Actual value in K7 43571,42857
Actual formula =AVERAGE(population[DoubYears])
5 Cut K7 [Ctrl+X]
6 Paste in K7 again
Actual value in K7 273,5
Actual formula in K7 =AVERAGE(population[DoubYears])
Cut & paste gives a different result value even the formulas seems the same.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
