OESF | ELSI | pdaXrom | OpenZaurus | Zaurus Themes | Community Links | Ibiblio

IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Gnumeric Font/ Toolbar Hiding Problem, row and column header font size too big
danboid
post Dec 1 2006, 01:15 PM
Post #1





Group: Members
Posts: 682
Joined: 26-December 05
From: Rochdale, Lancashire
Member No.: 8,789



I've got loads of excel files that aren't playing very nice with gnumeric because the row and column header font sizes are too big and so I can only fit a few cells on my screen at a time. These are mongrel xls files as most started off life on the Psion 5 then got converted to xls and then many have also been opened and saved with Hancom sheet since so I'm not entirely sure what part of that chain has caused the problem but most likely its psiwins fault.

Can this be fixed, even if it means using the real Excel to do it? I can't see any option to change said font sizes under gnumeric. I can provide a sample if anybody wants to give it a go.

Thanks!
Go to the top of the page
 
+Quote Post
Jon_J
post Dec 1 2006, 02:21 PM
Post #2





Group: Members
Posts: 1,843
Joined: 31-December 05
From: Illinois USA
Member No.: 8,821



I have Excel 2000
I only use it for one purpose, and that is pasting *.CSV data into it.
I use it for my karaoke database.
I can try and see if I can change the header font for you.
I don't use the header function in my karaoke database, so I may not know exactly the correct way to change the header font.
Below is a screenshot of my karaoke database. You can see that I only have the headers in the default template. (A B C, and so on)

EDIT: I've been experimenting with a small snippet of my database and I found if I select all, then reduce the font, the row header fonts get smaller (the numbered headers), but the column fonts don't.

This post has been edited by Jon_J: Dec 1 2006, 02:31 PM
Attached File(s)
Attached File  k_dbase.jpg ( 177.63K ) Number of downloads: 26
 
Go to the top of the page
 
+Quote Post
Drake01
post Dec 1 2006, 03:06 PM
Post #3





Group: Members
Posts: 226
Joined: 29-March 06
Member No.: 9,483



QUOTE(danboid @ Dec 1 2006, 04:15 PM)
I've got loads of excel files that aren't playing very nice with gnumeric because the row and column header font sizes are too big and so I can only fit a few cells on my screen at a time. These are mongrel xls files as most started off life on the Psion 5 then got converted to xls and then many have also been opened and saved with Hancom sheet since so I'm not entirely sure what part of that chain has caused the problem but most likely its psiwins fault.

Can this be fixed, even if it means using the real Excel to do it? I can't see any option to change said font sizes under gnumeric. I can provide a sample if anybody wants to give it a go.

Thanks!
*

Speaking of gnumeric and limited viewable cells... Does anyone know if there is a command-line option to start gnumeric with the toolbars not visible? Everytime I start it, the first thing I do is select to not view the toolbars. I couldn't find a command line switch or an option in the app to start it this way.

I have a feeling I'm out of luck, but thought I'd ask, anyway.
Go to the top of the page
 
+Quote Post
scheck.r
post Dec 1 2006, 06:08 PM
Post #4





Group: Members
Posts: 320
Joined: 5-December 04
From: Paris, France
Member No.: 5,776



QUOTE(Drake01 @ Dec 2 2006, 01:06 AM)
QUOTE(danboid @ Dec 1 2006, 04:15 PM)
I've got loads of excel files that aren't playing very nice with gnumeric because the row and column header font sizes are too big and so I can only fit a few cells on my screen at a time. These are mongrel xls files as most started off life on the Psion 5 then got converted to xls and then many have also been opened and saved with Hancom sheet since so I'm not entirely sure what part of that chain has caused the problem but most likely its psiwins fault.

Can this be fixed, even if it means using the real Excel to do it? I can't see any option to change said font sizes under gnumeric. I can provide a sample if anybody wants to give it a go.

Thanks!
*

Speaking of gnumeric and limited viewable cells... Does anyone know if there is a command-line option to start gnumeric with the toolbars not visible? Everytime I start it, the first thing I do is select to not view the toolbars. I couldn't find a command line switch or an option in the app to start it this way.

I have a feeling I'm out of luck, but thought I'd ask, anyway.
*



On my PC I have a .gnumericrc in my home directory that is used to remember the gnumeric settings I used the last time but not on the Z and if I copy it to the Z it doesn't have any effect. Furthermore when I go to the preference dialog in gnumeric to change the font it doesn't have any effect...So I have no solution
Go to the top of the page
 
+Quote Post
danboid
post Dec 2 2006, 01:15 AM
Post #5





Group: Members
Posts: 682
Joined: 26-December 05
From: Rochdale, Lancashire
Member No.: 8,789



Jon_J:

Thanks for helping me out with this! OESF doesn't let you upload raw .xls files for some reason so I've had to gzip an example. If you try opening it under gnumeric on your Z you will notice that the column and row header fonts consume most of the sheet display area. Not good!

Drake01:

That is the other problem I have with gnumeric that I want to solve- hiding most of the toolbars by default. As has already been said, pdaxrom gnumeric doesn't come with a ~/.gnumericrc file and nor does it come with ssconvert, the gnumeric spreadsheet conversion tool.

scheck.r:

Is the .gnumericrc file you copied over from your PC from the same version of gnumeric? They may have changed its layout between the two versions, if they're different.

I know a lot of programs look for a file in a certain place and if its present it will load that file and inherit its settings so I tried this with gnumeric- opened a new sheet, hid the toolbars, saved a .gnumeric sheet, closed gnumeric then re-launched gnumeric opening that file but unfortunately the toolbars returned with it.

I can't see why sashz or anyone should disable support for the .gnumericrc, sounds like that would be much more trouble than its worth. If that is the case though I guess I'll just have to compile a new gnumeric as those toolbars are too much for the Z display.
Attached File(s)
Attached File  fatfonts.xls.gz ( 1.29K ) Number of downloads: 21
 
Go to the top of the page
 
+Quote Post
Jon_J
post Dec 2 2006, 07:14 AM
Post #6





Group: Members
Posts: 1,843
Joined: 31-December 05
From: Illinois USA
Member No.: 8,821



I don't have gnumeric on my Z, since it's an 'X' application or for pdaXrom
I opened your sheet in Excel in Win XP
The column and row headers are very large and reducing the font of the cells has no effect on the column/row header font size.
There may be a setting in Windows registry for this.
I'll search a Microsoft site about Excel and see if there is a solution, and report back.
I cannot find a setting within Excel to change this.
Attached File(s)
Attached File  fatfonts.jpg ( 49.34K ) Number of downloads: 19
 
Go to the top of the page
 
+Quote Post
danboid
post Dec 2 2006, 07:17 AM
Post #7





Group: Members
Posts: 682
Joined: 26-December 05
From: Rochdale, Lancashire
Member No.: 8,789



Don't bother looking into windows registry fixes as that will not fix my excel files but if you find a way to alter those fonts under excel then let me know.

Thanks!
Go to the top of the page
 
+Quote Post
Jon_J
post Dec 2 2006, 08:29 AM
Post #8





Group: Members
Posts: 1,843
Joined: 31-December 05
From: Illinois USA
Member No.: 8,821



I went to microsoft knowledge base and the newsgroup "microsoft.public.excel" and several excel forums.
There are a lot of forums relating to excel out there.
The knowledge base has some refrence to visual basic and changing excel's interface, but I don't know much about VB, and I don't think this changes anything except the interface in Windows.
I haven't found anything yet to change those fonts.

By the way, the word that microsoft uses for these are:
"column heading"
"row heading"
Not "header" (since "header" is used in conjunction with "footer")
This makes a search work better in the various forums and newsgroup and online help.
Go to the top of the page
 
+Quote Post
Drake01
post Dec 2 2006, 08:42 AM
Post #9





Group: Members
Posts: 226
Joined: 29-March 06
Member No.: 9,483



QUOTE(danboid @ Dec 2 2006, 10:17 AM)
Don't bother looking into windows registry fixes as that will not fix my excel files but if you find a way to alter those fonts under excel then let me know.

Thanks!
*

I just took a look at the font / header issue... View->Zoom... and change the zoom level to something less than 200%. wink.gif

Otherwise, I was going to suggest exporting to a .csv in order to lose all the formatting. This is an easier fix, though.
Go to the top of the page
 
+Quote Post
Jon_J
post Dec 2 2006, 09:05 AM
Post #10





Group: Members
Posts: 1,843
Joined: 31-December 05
From: Illinois USA
Member No.: 8,821



I just opened your example in Picsel Browser on my Zaurus, and it looks like it's in Landscape.
Maybe try opening it in gnumeric and switching it to portrait.
EDIT:
Drake01 is right, the example you posted is zoomed to 200%

This post has been edited by Jon_J: Dec 2 2006, 09:13 AM
Attached File(s)
Attached File  scrn001.jpg ( 27.83K ) Number of downloads: 19
 
Go to the top of the page
 
+Quote Post
danboid
post Dec 3 2006, 11:04 AM
Post #11





Group: Members
Posts: 682
Joined: 26-December 05
From: Rochdale, Lancashire
Member No.: 8,789



laugh.gif

Is that all it was? Shows you how much I know about spreadsheets! Thanks for diagnosing my problem Drake01 + Jon_J!

I have fixed the toolbar problem under gnumeric by upgrading the current pdaXii13 gnumeric to v1.6.3 from the beta3 feed- I had to upgrade a few other libraries after updating gnumeric but I can't remember their names- the console will tell you that biggrin.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 19th December 2014 - 07:09 AM