https://bugs.freedesktop.org/show_bug.cgi?id=73609
Priority: medium
Bug ID: 73609
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: wrong autofill of cell ranges in functions
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: silva...@katamail.com
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.0.2 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 92050
--> https://bugs.freedesktop.org/attachment.cgi?id=92050&action=edit
A spreadsheet with the sequential series of automatic sums going berserk every
3/4 instances
Problem description:
when you create a formula using the automatic sum tool, or the function wizard,
cell ranges created by default or by drag and drop are often wrong and result
in error messages.
When using the automatic sum, if data are nearby their cell ranges are usually
inserted by default. Now however this insertion if very often - but not always
- totally wrong.
Steps to reproduce:
I'm still struggling to find out a fully deterministic, reproducible mechanism
for this, it seems to happen about 1/3 of the times.
The file I am attaching shows a simple mechanism of sum insertions and the ugly
outcome:
- type 1 in A1 and move to A2
- insert an automatic sum in A2, then press return and move to A3
- insert an automatic sum in A3, then press return and move to A4
- repeat until you reach A30
The result should be a series of sums of the above column, each time with one
more value being added; instead it is a total nightmare as in the attached
file, with many autofill giving things like SUM(A7:#RIF!A7) (see attached
image).
When using some drag and drop cell range definition, like in the function
dialog, the same thing happens, sometimes in place of a thing like A7:#RIF!A7
you get a A3:Foglio3.B15 instead of an A3:B15 (which is wrong as well). And
when you select a single cell range this is wrongly indicated repeating twice
the single cell, so that A1 becomes A1:A1.
Current behavior:
All this is totally critical to use Calc with functions and formulas, making
4.2 RC2 substantially unusable. Having realized this was happening I
immediately uninstalled the 4.2 RC2, the risks of serious errors are too high.
Expected behavior:
Operating System: Windows 7
Version: 4.2.0.2 rc
Last worked in: 4.1.4.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
