GeneralThis forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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?
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.
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).
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).
Distribution: Dabble, but latest used are Fedora 13 and Ubuntu 10.4.1
Posts: 425
Rep:
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.
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.
Distribution: Dabble, but latest used are Fedora 13 and Ubuntu 10.4.1
Posts: 425
Rep:
Quote:
Originally Posted by Dogs
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?
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.