[Libreoffice-bugs] [Bug 42697] New: Calculation - formula operator does not work
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Tue Nov 8 10:26:35 CET 2011
https://bugs.freedesktop.org/show_bug.cgi?id=42697
Bug #: 42697
Summary: Calculation - formula operator does not work
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs at lists.freedesktop.org
ReportedBy: dcclayton at bataltd.co.uk
Created attachment 53280
--> https://bugs.freedesktop.org/attachment.cgi?id=53280
Sheet where operations are not performed on referenced cells
Hi all,
quite a weird one - the attached Calc sheet has a number of very simple
operations, multiply and addition. The cells are referenced properly (click and
see the red/blue cells). you can add more numbers to the first two columns, and
get the same behaviour when you drag the calculations down.
What seems to be happening is that the value returned is the value from the
first referenced cells - and not the cells that on that row.
I think that this bug must be in the existing file because if I copy and paste
special the numbers and formulas into a new Calc sheet, the calculations work
as expected.
you can get the expected behaviour by re-typing the formula.
... I ended up creating a new sheet, but I was just curious to know how this
has came about.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Libreoffice-bugs
mailing list