AutoFill not filling and incrementing merged cells

Bug #153150 reported by David Genest on 2007-10-16
12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LibreOffice
New
Undecided
Unassigned
OpenOffice
Confirmed
Unknown
libreoffice (Ubuntu)
Medium
Unassigned
openoffice.org (Ubuntu)
Low
Unassigned

Bug Description

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) wrote :

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.

Changed in openoffice.org:
status: New → Incomplete
Parthan SR (parth-technofreak) 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.

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.
>

Chris Cheney (ccheney) on 2008-03-14
Changed in openoffice.org:
status: Incomplete → New
Chris Cheney (ccheney) on 2008-03-26
Changed in openoffice.org:
importance: Undecided → Low
status: New → Confirmed
Changed in openoffice:
status: Unknown → Confirmed
Chris Cheney (ccheney) on 2008-06-13
Changed in openoffice.org:
status: Confirmed → Triaged

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.

Chris Cheney (ccheney) on 2009-09-11
summary: - [Upstream] [hardy] AutoFill not working down merged cells
+ [upstream] AutoFill not working down merged cells
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix

[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.

summary: - [upstream] AutoFill not working down merged cells
+ AutoFill not working down merged cells
  • example.ods Edit (7.0 KiB, application/vnd.oasis.opendocument.spreadsheet)

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.

description: updated
summary: - AutoFill not working down merged cells
+ AutoFill not filling and incrementing merged cells
Changed in libreoffice (Ubuntu):
importance: Undecided → Medium
status: New → Triaged
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Related questions

Remote bug watches

Bug watches keep track of this bug in other bug trackers.