https://bugs.documentfoundation.org/show_bug.cgi?id=120948
Bug ID: 120948
Summary: Deleting large number of rows/cells breaks group
formula
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: psdasi...@yahoo.com
Description:
Having a large table (ex. 200000 rows) - may be a single column -, deleting a
large number of rows or cells breaks a formula (like sum, for example) that
refers to them.
Steps to Reproduce:
1. Create a big table of 200000 lines. For this example may be a single column
from A1:A200000 filled with 1.
This could be achieved by going to cell A200000, use ctrl+shift+uparrow to
select up to A1, type 1 followed by alt+shift+enter
2. Enter in cell A200001 (for example) the formula =SUM(A1:200000)
3. Delete rows (or cells - not their content) A2 to A199998 (for example)
Actual Results:
The entered formula (SUM), now in cell A4, gives Error:522 and contain formula
=SUM(A1:A196611)
Expected Results:
The formula should be
=SUM(A1:A3) with result 3.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
This happens with other formulas. Not only the SUM.
Versão: 6.0.6.2
ID da versão: 1:6.0.6-0ubuntu0.18.04.1
Processos do CPU: 8; SO: Linux 4.15; Gestão da interface: padrão; VCL: kde4;
Configuração regional: pt-PT (pt_PT.UTF-8); Calc: group
--
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
