Autofill merged cells

Discuss the spreadsheet application

Autofill merged cells

Postby gebeleizis » Wed Apr 29, 2009 10:41 pm

I was wondering if is normal and if so why:
I am using merged cells and then I am trying to (auto)fill those as single cells. Now, the problem is that oo is filling the merged cells as they were the original cells:

Merged cells:
Image

Data for fill:
Image

Fill:
Image

PS: I just red that this is a bug (although it's filled as a bug for oo on ubuntu and I am on winXPsp3)
gebeleizis
 
Posts: 2
Joined: Mon Mar 17, 2008 2:14 am

Re: Autofill merged cells

Postby TheGurkha » Wed Apr 29, 2009 10:57 pm

Hi and welcome to the forums.

Looks like this one: Issue 57432.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Autofill merged cells

Postby gebeleizis » Thu Apr 30, 2009 10:34 pm

Thank u.
So, from 2005? And in the end is a enhancement request?
Anywho, manual fill is what it sure works (merda).
gebeleizis
 
Posts: 2
Joined: Mon Mar 17, 2008 2:14 am

Re: Autofill merged cells

Postby TheGurkha » Thu Apr 30, 2009 10:39 pm

Yes, 2005 and there's only 12 votes for it, so it isn't surprising it keeps getting bypassed for other fixes.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Autofill merged cells

Postby gonkawonka » Fri May 18, 2012 6:33 am

Has this been corrected yet?

I thought I'd add what I learned through my experiments. , if you un-merge your cells, and highlight the number of cells that will be skipped (these will be merged later) autofill will continue with the numerical series. You then will have to remerge your cells. I merge the first one and use the format brush tool over the others.

The problem I'm having however with this is that numerical series will continue, but with non-numerical series, autofill is only copying the same entry.
- gonks
OpenOffice 3.2.1
on Mac OS X (SnowLeopard)
gonkawonka
 
Posts: 1
Joined: Fri May 18, 2012 6:23 am

Re: Autofill merged cells

Postby kingfisher » Fri May 18, 2012 8:42 am

As far as I know, values other than numbers and cell references do not alter when filled. The series fill will not accept non-numerical values. A series fill may work for numbers in merged cells.

BTW, the issue remains. You may vote for it (up to 2 votes).
OpenOffice 3.3 on PCLinuxOS. There are 3 kinds of people: those who can count and those who can't.
User avatar
kingfisher
Volunteer
 
Posts: 1860
Joined: Tue Nov 20, 2007 10:53 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 32 guests