[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