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