| View previous topic :: View next topic |
| Author |
Message |
DavidDugas Newbie

Joined: 20 Jul 2007 Posts: 2 Location: Daejeon, South Korea
|
Posted: Fri Jul 20, 2007 8:58 pm Post subject: Background color options for spreadsheet |
|
|
I am an enthusiastic supporter of Open Office and I believe I can make a useful recommendation for improvement. I have prepared many reports including printed spreadsheets and find the Open Office color options both aesthetically 'challenged' and impractical. In a couple of hours I prepared an alternative set of color options using
Corel QuattroPro which occupies the same 100 square matrix now used in the Open Office drop down. Though I converted the new color matrix to a pdf file, I see no way to attach it to this mail. I will be happy to send a copy to any who are interested.
dwd
PS I am not a pdf virus. _________________ US Expat
Daejeon, South Korea |
|
| Back to top |
|
 |
David Super User


Joined: 24 Oct 2003 Posts: 5668 Location: Canada
|
Posted: Sat Jul 21, 2007 4:12 am Post subject: Re: Background color options for spreadsheet |
|
|
Better, perhaps, to send it to a file hosting service so that people can download from there if they wish. [I'm stuck on what it is you are doing, to be truthful, and how a colour scheme from QP can be transferred to Calc, and similarities and differences, but will wait and see.] Sorry, I'm a bit reluctant to send email addresses, that usually being reserved for people I know, and am even quite cautious about downloading files except from people I've seen around here for some time. It's the age we live in.
David. |
|
| Back to top |
|
 |
jrkrideau Super User

Joined: 08 Aug 2005 Posts: 6733 Location: Kingston ON Canada
|
Posted: Sat Jul 21, 2007 7:17 am Post subject: Re: Background color options for spreadsheet |
|
|
| DavidDugas wrote: | I am an enthusiastic supporter of Open Office and I believe I can make a useful recommendation for improvement. I have prepared many reports including printed spreadsheets and find the Open Office color options both aesthetically 'challenged' and impractical. In a couple of hours I prepared an alternative set of color options using
Corel QuattroPro which occupies the same 100 square matrix now used in the Open Office drop down. Though I converted the new color matrix to a pdf file, I see no way to attach it to this mail. I will be happy to send a copy to any who are interested.
dwd
PS I am not a pdf virus. |
The forum does not accept attachments. The best idea is probably to post to something likemytempdir.com
http://www.mytempdir.com
or
mediafire.co,
http://www.mediafire.com/.
Another alternative is got get yourself a free webpage ( Yahoo is one source ) and post it there for a more permanent solution. _________________ jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
 |
acknak Moderator


Joined: 13 Aug 2004 Posts: 4295 Location: ~ 40°N,75°W
|
Posted: Sat Jul 21, 2007 8:26 am Post subject: |
|
|
Good idea, but a Quattro Pro document will not be directly useful since it's not in a format that OOo can use. OOo comes with about a half-dozen different color palettes; many more have been developed and are scattered around the web.
The palette files are simple text/xml files (the names end with ".soc"); you can take one of the existing ones and modify it in a text editor, or use the OOo color editor and then export the palette to a .soc file.
Here's a sample from the standard.soc file:
| Quote: | ...
<draw:color draw:name="Black" draw:color="#000000"/>
<draw:color draw:name="Blue" draw:color="#000080"/>
<draw:color draw:name="Green" draw:color="#008000"/>
<draw:color draw:name="Turquoise" draw:color="#008080"/>
<draw:color draw:name="Red" draw:color="#800000"/>
...
|
|
|
| Back to top |
|
 |
DavidDugas Newbie

Joined: 20 Jul 2007 Posts: 2 Location: Daejeon, South Korea
|
Posted: Sat Jul 21, 2007 7:24 pm Post subject: Background color options |
|
|
Thanks for the quick response. The use of QuattroPro was simply to produce an array of color choices to demonstrate what I feel is a much better approach. I converted it to pdf just so that it could be posted for general viewing. I'll see about setting up a simple webpage so that such sharing will be possible. Thanks for the ideas. I'm not a programmer, but I may be able to create a text list of the specific color definitions, which someone else might integrate into the existing subroutine for background color selection. I'll use the format provided in the second response. I'll need a little time. More later.
Dugas _________________ US Expat
Daejeon, South Korea |
|
| Back to top |
|
 |
acknak Moderator


Joined: 13 Aug 2004 Posts: 4295 Location: ~ 40°N,75°W
|
Posted: Sat Jul 21, 2007 8:16 pm Post subject: |
|
|
| Quote: | | ... which someone else might integrate into the existing subroutine for background color selection. |
Just to avoid any misunderstanding, no subroutine or programming is required: you can change OOo's color palette at any time simply by loading a different palette file. That's why it's so helpful to share the files in the correct format; then anyone can use them directly.
Unfortunately, access to the alternative palettes is a little weird, especially in Writer: First, enable the drawing toolbar (View > Toolbars). Then, create a rectangle and open the Area properties dialog (Right-click > Area). Select the Colors tab; click the "Open" button and choose one of the *.soc files.
You can now delete the rectangle; it's purpose is just to get to that area dialog. |
|
| Back to top |
|
 |
|