LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 02-22-2010, 03:21 PM   #1
Dogs
Member
 
Registered: Aug 2009
Location: Houston
Distribution: Slackware 13.37 x64
Posts: 105

Rep: Reputation: 25
MS Excel/OOo Calc question


I have an assignment in my MS office class to format some data in a .xlsx spreadsheet, but her directions don't make much sense to me, and I'd like a second opinion.

Quote:
Change the color of the Semi-Annual tab to blue. Change the color of the Monthly tab to yellow.

(bold is my emphasis)
For both worksheets, select the text in cell A1 and center it across rows A through I. In addition to that, make the font bold and change its font size to 12 on both worksheets. Also change the background color of the merged cells to Gray—25% on both worksheets. Change the font color of this cell to match the tab color for each worksheet as selected in Step 3 above.


So, first things first, I'm using OOo which doesn't save in .xlsx, but hopefully that won't matter.

There are two tabs (just like tabs in a web browser) that need to be changed to blue and yellow respectively, but I don't much care about that right now..

The most important pieces that don't make any sense to me are the ones in bold.

It sounds like she wants me to take cell A1 (which is the name of the thing), and copy it across the top like a title, but "center it across"? WTF is center it across?

Also, she never specifically states a cell number anywhere in her instructions, except for A1, but am I supposed to change cell A1 to the tab color, or all the text under the tab to the tab color?
 
Old 02-22-2010, 03:32 PM   #2
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 422Reputation: 422Reputation: 422Reputation: 422Reputation: 422
Just a guess on my part, but it sounds like she wants you to merge A1 through I1 and have the text in A1 centered.

Quote:
I'm using OOo which doesn't save in .xlsx, but hopefully that won't matter.
It does save in .xls and I suspect that the instructor won't notice the difference. Just to be annoying, whenever someone sends me a file in office open format (or whatever the official MS name for that crapola is), I send it back and ask for a real format.

Quote:
Also, she never specifically states a cell number anywhere in her instructions, except for A1, but am I supposed to change cell A1 to the tab color, or all the text under the tab to the tab color?
You might have to ask about this one. She could mean either the entire sheet or maybe just the tab (however I have no idea if Excel can change just the color of the tab).

Though I do have to say Dogs, I tip my hat to you for using OOo in an MS Office class. That is pleasantly cheeky.
 
Old 02-22-2010, 04:46 PM   #3
PunksUndead
LQ Newbie
 
Registered: Jan 2009
Location: Central California
Distribution: Kubuntu 10.10 and BackTrack4
Posts: 22

Rep: Reputation: 16
Quote:
For both worksheets, select the text in cell A1 and center it across rows A through I.
Merge cells A1 through I1, then center the text, change it to bold and increase the text size to 12.


Quote:
Also change the background color of the merged cells to Gray—25% on both worksheets. Change the font color of this cell to match the tab color for each worksheet as selected in Step 3 above
Change the fill color of the merged cells to "Gray-25%" on both pages.
Change the font color of the text in the merged cells to match the colors of their corresponding tabs (blue and yellow).
 
Old 02-22-2010, 05:17 PM   #4
MrCode
Member
 
Registered: Aug 2009
Location: Oregon, USA
Distribution: Arch
Posts: 864
Blog Entries: 31

Rep: Reputation: 148Reputation: 148
Quote:
Originally Posted by Hangdog42
Though I do have to say Dogs, I tip my hat to you for using OOo in an MS Office class. That is pleasantly cheeky.
Yeah, how do you get away with something like that? Is the class online?
 
Old 02-22-2010, 05:17 PM   #5
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 952

Rep: Reputation: 217Reputation: 217Reputation: 217
MS Excel has got an option called "Center across selection" in the format-->Cells options for which there is no identical option in OO. So since you use OO (and can save-as excel) you might lose some marks if the the instructor notices the difference between what she asked and what you submitted (merge the cells).

Anyway, all the best.

End
 
Old 02-23-2010, 07:09 AM   #6
moxieman99
Member
 
Registered: Feb 2004
Distribution: Dabble, but latest used are Fedora 13 and Ubuntu 10.4.1
Posts: 425

Rep: Reputation: 147Reputation: 147
1. You can center text in a cell in Open Office. Same text justification symbols work in Calc as in Writer.

2. Merging cells in OpenOffice is the same as in Excel, so merging cells A1 through I1 inclusive is no problem.

3. In the web site Open Office Ninja there is an add-on for Calc (the spreadsheet) called Color2Rows. I don't know if it will change tab colors, but check it out.

3. There are also add-ons for office open format files in Open Office, but I have to agree, I boycott the office open stuff when I can.
 
Old 02-23-2010, 12:46 PM   #7
Dogs
Member
 
Registered: Aug 2009
Location: Houston
Distribution: Slackware 13.37 x64
Posts: 105

Original Poster
Rep: Reputation: 25
Thanks for the replies.

I've turned in a couple of assignments already that I did with OOo and I got A's on em, so I figure I'll get about that with this assignment as well.

If worst comes to worst and I can't make OOo behave, then I'll get most of it done, boot up XP, and do the finishing bit on MS O.
 
Old 02-24-2010, 04:44 PM   #8
Dogs
Member
 
Registered: Aug 2009
Location: Houston
Distribution: Slackware 13.37 x64
Posts: 105

Original Poster
Rep: Reputation: 25
I haven't been able to find anything that would allow OOo to save in .xlsx, but that sure would be handy. If anyone knows of a way to do that, I'd appreciate a link to relevant material.
 
Old 02-26-2010, 03:22 PM   #9
moxieman99
Member
 
Registered: Feb 2004
Distribution: Dabble, but latest used are Fedora 13 and Ubuntu 10.4.1
Posts: 425

Rep: Reputation: 147Reputation: 147
Quote:
Originally Posted by Dogs View Post
I haven't been able to find anything that would allow OOo to save in .xlsx, but that sure would be handy. If anyone knows of a way to do that, I'd appreciate a link to relevant material.
Have you tried posting your request in www.openoffice.org and its relevant support forums?
 
Old 02-26-2010, 03:28 PM   #10
smeezekitty
Senior Member
 
Registered: Sep 2009
Location: Washington U.S.
Distribution: M$ Windows / Debian / Ubuntu / DSL / many others
Posts: 2,339

Rep: Reputation: 231Reputation: 231Reputation: 231
AFAIK you can save as xls and rename to xlsx because the internal format is backwards compatable.
 
Old 02-26-2010, 05:20 PM   #11
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 952

Rep: Reputation: 217Reputation: 217Reputation: 217
Rename as xlsx wont do since xlsx is Microsoft's OpenXML file format which is different. For this last lap, you must open in excel and save as .. Doesn't seem to be any other option.

End
 
Old 02-26-2010, 05:52 PM   #12
smeezekitty
Senior Member
 
Registered: Sep 2009
Location: Washington U.S.
Distribution: M$ Windows / Debian / Ubuntu / DSL / many others
Posts: 2,339

Rep: Reputation: 231Reputation: 231Reputation: 231
Or the best solution is to just convince to instructor to accept the format.
Especially since it is far better supported then xlsx.
 
Old 02-28-2010, 08:29 AM   #13
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 952

Rep: Reputation: 217Reputation: 217Reputation: 217
If the xls format is acceptable to your instructor - with the explanation that you used OO, then I expect the instructor will also be amenable to trying a comparison between windows and linux.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
OOo calc question salimshahzad Linux - Software 2 01-28-2010 11:54 PM
load exel spreadsheet into ooo calc? Matthew O'Brien Linux - Newbie 1 04-25-2008 04:21 PM
OOo Calc Toonses82 Linux - Desktop 1 10-14-2006 02:27 AM
OOO Calc Paste shifts cells LasseW Linux - Software 0 02-03-2005 11:25 AM
OO.org calc not multiplying my excel file np complete Linux - Software 0 10-15-2004 10:14 AM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 08:21 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration