https://bugs.freedesktop.org/show_bug.cgi?id=85551
Bug ID: 85551
Summary: LO Calc and MS Excel treat invalid OFFSET height and
width parameters differently
Product: LibreOffice
Version: 4.3.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Libreoffice
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108569
--> https://bugs.freedesktop.org/attachment.cgi?id=108569&action=edit
A sample reproducing and illustrating the issue.
Problem description:
The issue is caused by the difference in how MS and LO treat the INVALID
formula in the customer's file.
There is this OFFSET() method. It creates a cell range using the provided
origin cell, offset for this cell and a height and a width of the required cell
range. Height and width parameters are to be positive values as stated in the
method's specification in the MS Excel help file. Yet customer uses negative
value for the width parameter.
In MS Excel, negative value is honored no matter what documentation says: you
get a cell range going from the reference cell and to the right, if the
provided width value is negative.
In LO it is just set to default value (1), causing the difference in
calculation.
This results in different calculation results.
Steps to reproduce:
0. open a clean worksheet
1. create a vertical list of numbers
3. in a separate cell, enter the formula for =SUM(OFFSET()), where OFFSET is
provided with a reference cell of the END of the list of numbers and a NEGATIVE
cell range height.
Current behavior:
Sum will return 0, as the negative height is substituted with a default 1.
Expected behavior:
Sum of the numbers in the created list.
This behaviour is clearly illustrated in the attached document.
--
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
