[Libreoffice-bugs] [Bug 40993] New: Calc: Pulling down formula over merged cells unmerges them

[bugzilla-daemon at freedesktop.org]

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: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: dereinsameberg at gmx.net


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.