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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
