https://bugs.freedesktop.org/show_bug.cgi?id=40993

           Summary: Calc: Pulling down formula over merged cells unmerges
                    them
           Product: LibreOffice
           Version: LibO 3.4.3 release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: NEW
          Severity: minor
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


Created an attachment (id=51318)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=51318)
ODS file to reproduce behavior

Hi,
I am using LibreOffice 3.4.3 OOO340m1 (Build:302) on Ubuntu 11.04_64bit. It
seems Calc resplits merged cells when you draw a formula over it with the lower
right handle. What I did is: 
1.) create two adjacent cells with e.g. 1 and 2 in it. 
2.) When you merge & center cells below it and add e.g. =AVERAGE(). You will
get a centered value of 1.5 in the cell. That is fine. 
3.)Drawing the formula down over more merged cells will split them and align
the value of 1.5 into the left slice.

See attached file to try it for yourself.

This behavior seems odd. I guess it's probably an unwanted behavior or not?

Cheers

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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

Reply via email to