OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[Spreadsheet] How to join cells

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
Guest






PostPosted: Thu Feb 05, 2004 3:13 am    Post subject: [Spreadsheet] How to join cells Reply with quote

In M$ excel I can join some cells. How can I do for do this in spreadsheet???

Thanks and sorry for my poor English Laughing
Back to top
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Thu Feb 05, 2004 3:21 am    Post subject: Reply with quote

Do you mean "Merge" cells?

If so select the cells you want to merge and select:
Format > Merge Cells > Define

HTH
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
bhomass
General User
General User


Joined: 02 Mar 2004
Posts: 23

PostPosted: Thu Mar 11, 2004 8:24 pm    Post subject: merge cells disabled Reply with quote

when I open an Excel file in Calc, the merge cell button and menu item both become disabled. does some know why this happens?

Thanks

Bruce
Back to top
View user's profile Send private message Send e-mail
antonbijl
OOo Advocate
OOo Advocate


Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa

PostPosted: Fri Mar 12, 2004 3:41 am    Post subject: Reply with quote

Bruce

In order for merge cells to be used, you have to first select multiple adjacent cells (i.e. cells that can be merged). So select cells A1 and A2 for instance and the merge cell button/menu item should become available, but if only 1 cell is selected (e.g. A1) it will be disabled (because it is impossible to merge one cell). Likewise the split cells function will only be available if a merged cell is selected.

HTH

Anton
Back to top
View user's profile Send private message
esperantisto
Super User
Super User


Joined: 26 Dec 2003
Posts: 779
Location: Belarus

PostPosted: Fri Mar 12, 2004 6:16 am    Post subject: Reply with quote

There is one little detail, that I've noticed to be different from MS Excel: if you have merged some cells and want to add more cells to the merged range, first, you'll have to unmerge the already merged and only then perform the merge operation over the new range (in Excel you just select the merged range, the new cells and do new merge).
Back to top
View user's profile Send private message
bhomass
General User
General User


Joined: 02 Mar 2004
Posts: 23

PostPosted: Fri Mar 12, 2004 8:31 am    Post subject: Reply with quote

Thanks for these tips. but I already know what are stated, and they are not the problem I am looking at. there is one large Excel file which, when opened in Calc would have the merge cell button and menu item both disabled, no matter what cell range I select. when I open any other smaller Excel file, the button remains active even when there is only one cell selected. the sheet is not protected either. any one ever seen this before?
Back to top
View user's profile Send private message Send e-mail
antonbijl
OOo Advocate
OOo Advocate


Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa

PostPosted: Fri Mar 12, 2004 9:25 am    Post subject: Reply with quote

Bruce

How large is the file?

If it's smaller than 2MB (I think that's the yahoo max), you can e-mail it to me on antonbijl AT yahoo.co.uk and I can tell you if I get the same behaviour. If its bigger try zipping it, xls files tend to compress quite a lot.

I've certainly not seen this. And on my system when only one cell is selected the merge cells button is always disabled.

But if you can, send me the file and I'll have a look.

Cheers

Anton
Back to top
View user's profile Send private message
bhomass
General User
General User


Joined: 02 Mar 2004
Posts: 23

PostPosted: Fri Mar 12, 2004 5:32 pm    Post subject: Reply with quote

I appreciate the offer, but it is a client file that I can not release. Maybe I will get a chance to work another large file later which I could.

Bruce
Back to top
View user's profile Send private message Send e-mail
freiheit
OOo Advocate
OOo Advocate


Joined: 06 Sep 2003
Posts: 372
Location: California

PostPosted: Sat Mar 13, 2004 12:09 am    Post subject: Anything unusual about the file? Reply with quote

Other than the file's size, is there anything unusual about the file? Is it password protected or set read-only? I was just in an office where someone had an open MS Word file that they could not save to itself, but they could freely save it as a new file in the same directory. I guessed there was some form of copy protection or read-only attribute either on the file or within the file (perhaps a Word/Excel feature, I'm not sure since I don't use them).

Don Eitner
Back to top
View user's profile Send private message Visit poster's website
bhomass
General User
General User


Joined: 02 Mar 2004
Posts: 23

PostPosted: Sat Mar 13, 2004 10:58 pm    Post subject: Reply with quote

I have checked all the possibilities that I am aware of. it is possible to protect a sheet in Excel, which would disable all of the tool buttons. but this is not the case I have. this particular file behaves fine in Excel. all tool buttons are active. it is only in OO that it disables the merge button. the more I work and program OO, the more parcularities I find. a features that ususally works could fail in a paritcular sheet. this merge problem remains a mystery.
Back to top
View user's profile Send private message Send e-mail
davida
Newbie
Newbie


Joined: 23 Aug 2004
Posts: 1

PostPosted: Mon Aug 23, 2004 12:35 pm    Post subject: Reply with quote

I found out how to get the cell merge feature working on an excel file. Go to
Edit->Changes->Record
and make sure the checkbox is off. Then you should be able to see the menu items in
Format-Merge Cells

Hope that helps.

-David
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group