AutoFill not filling and incrementing merged cells

[David Genest]

1) lsb_release -rd
Description: Ubuntu 12.04 LTS
Release: 12.04

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.5.2-2ubuntu1
  Candidate: 1:3.5.3-0ubuntu1
  Version table:
     1:3.5.3-0ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main i386 Packages
 *** 1:3.5.2-2ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages

3) What is expected to happen in Calc via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/153150/+attachment/3142909/+files/example.ods && localc --nologo example.ods

is when one highlights the merged cells A1-A5 -> use the mouse to grab the bottom right corner of the cells -> drag it to cell A10, cells A6-10 are merged, and the number increments to 2 in A10. Just as it does in Excel 2010. A screenshot of how it should look in Calc: https://launchpadlibrarian.net/12607059/autoFillExpected.png .

4) What happens instead is cells A6-A10 are not merged, and each cell has a number incremented.

[Chris Cheney (ccheney)]

Does the new version of openoffice.org 1:2.4.0~rc2 in Ubuntu hardy resolve your problem? I was not completely sure how to do the layout since it appears the ascii formatting screwed up what you were trying to draw.

[Parthan SR (parth-technofreak)]

Can you provide us with a screen shot of what you were expecting to see and what you actually got by trying to get it? This will help us in better understanding your bug and confirming it. Thanks in advance.

[David Genest (david-genest)]

When the cell are merged, I would expect that autofill would take into
account the mereged cells, and not increase as if the cells were not
merged. This would be handy for making header rows that are bigger
that one cell.

I was trying to have merged cells that contained dates, and did not
want to type the consecutive dates for every merged cell. I thought
autofill would know about the merged cells.

This applies to 1:2.3.0-1ubuntu5.3

I haven't found how to upgrade from the repositories to the 2.4
version. Can you point me in the direction? I'm using 7.10 and have
the backport repositories enabled.

Thank you for your time,

D.

On Wed, Mar 12, 2008 at 4:19 AM, Parthan <email address hidden> wrote:
> Can you provide us with a screen shot of what you were expecting to see
> and what you actually got by trying to get it? This will help us in
> better understanding your bug and confirming it. Thanks in advance.
>
>
>
> --
> AutoFill not working down merged cells
> https://bugs.launchpad.net/bugs/153150
> You received this bug notification because you are a direct subscriber
> of the bug.
>

[m4cph1sto (dlreid)]

Is there any update on this bug? It still exists in openoffice.org-core 1:3.0.1-9ubuntu3. It is extremely annoying for anyone trying to autofill across merged cells, e.g. to make a simple spreadsheet calendar with tasks.

[penalvch (penalvch)]

Attachment from OOo upstream bug:
http://qa.openoffice.org/issues/show_bug.cgi?id=57432

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[penalvch (penalvch)]

David Genest, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance.

[Marcus Tomlinson (marcustomlinson)]

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

[Marcus Tomlinson (marcustomlinson)]

This bug has sat incomplete for 6 months. Marking invalid.