[Libreoffice-bugs] [Bug 130374] New: In CALC, References to data with autofilter get wrong after the filter is used.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130374
           Summary: In CALC, References to data with autofilter get wrong
                    after the filter is used.
           Product: LibreOffice
           Version: 6.3.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: luis.marcone at gmail.com

Description:
1 I have a very simple set of data: A,B,C and D with values 10,20,30,40.
2 define a filter for it 
3 Copy the values to another section of the sheet.
4 Use the filter in the source data (I only sort A-Z or Z-A)2 or 3 times
5 Some of the cells referencing the source data get his reference or his value
wrong. The attached case: 2 cells show as both are referencing the C9 cell but
show different values.
I am sure the references get messed after using the filter.

See attached sheet.

Steps to Reproduce:
1 I have a very simple set of data: A,B,C and D with values 10,20,30,40.
2 define a filter for it 
3 Copy the values to another section of the sheet.
4 Use the filter in the source data (I only sort A-Z or Z-A)2 or 3 times
5 Some of the cells referencing the source data get his reference or his value
wrong. The attached case: 2 cells show as both are referencing the C9 cell but
show different values.
I am sure the references get messed after using the filter.

See attached sheet.

Actual Results:
2 cells show as both are referencing the C9 cell but show different values.


Expected Results:
all references to data with a filter setting are ok after using the filter


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: es
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes

Versión: 6.3.4.2 (x64)
Id. de compilación: 60da17e045e08f1793c57c00ba83cdfce946d0aa
Subprocs. CPU: 2; SO: Windows 6.1; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
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/20200203/39d728dd/attachment.htm>