PDA

View Full Version : Pocket excel zoom fix

meschle
20-03-2006, 12:01 AM
Someone was asking for a tweak for excel a while back - not sure if here or another forum.

Like me most of you have probably increased the default screen font size for better readability. When you use excel after the boxes and fonts are too big and you have to always zoom down to 75%. Could not find a fix to set default zoom to 75% so made a new template - normal.xlt.
Put it in the my documents/templates/ folder and change default template in excel options to this on and voila all is good when you start a new document. If you want to sort old documents out just change cell size when all selected.
Hope this helps ;)
meschle
20-03-2006, 01:30 AM
Just read that in WM2003 this was not a problem - the file saved at the zoom setting you set it, and apparently WM5 has a bug so does not do this - anyone with a later ROM can they report if this is fixed. ta
meschle
20-03-2006, 04:59 AM
Updated template - cell size is same as the default one - but if you use opens up as if 75% zoom.
MNeo
18-08-2006, 10:41 AM
...it doesn't work on my XDA Neo :(
meschle
18-08-2006, 03:57 PM
...it doesn't work on my XDA Neo :(

Can you describe what you did and I will see if I can help. Also useful to know if you have any xlt files in your my documents\templates folder.
MNeo
18-08-2006, 04:02 PM
There where no .xlt files in templates (my Documents\vorlagen) i tried to copy the files by pc and to unpack them on ppc; I also tried saving my own .xlt after resizing it to 75% zoom...
meschle
18-08-2006, 04:14 PM
There where no .xlt files in templates (my Documents\vorlagen) i tried to copy the files by pc and to unpack them on ppc; I also tried saving my own .xlt after resizing it to 75% zoom...

Did you change template in excel\options\template for new workbook?
MNeo
18-08-2006, 04:19 PM
Yes I did!
The Standard is 'leere Arbeitsmappe' I changed it to normal.xlt

By unpacking the .xlt one gets overwritten by the other, so I zipped the file >0 byte
meschle
18-08-2006, 04:35 PM
What happens if you change template to vehicle mileage log - prob auto.... for yourself. That template has zoom fix already.
MNeo
18-08-2006, 04:43 PM
...there's no difference at all!
meschle
18-08-2006, 04:52 PM
Have you tried both the templates posted - 1st one is with a different cell size and second saving with 75% zoom. When you are using these templates the cell size will shrink on the screen and when you check under view\zoom it will say 100% even when it is less.

If the zoom change does not work then possible cell size change will.
MNeo
18-08-2006, 05:28 PM
it doesn't work too :(
maybe I have to live with that
It's not a bug, it's a feature :wink:
gwassef
20-08-2006, 01:14 PM
i have a 2 questions
1. how to change the template settings in the excel
2. is these templates for the new files only or will apply to the old files.
meschle
20-08-2006, 03:07 PM
1. Open excel, goto menu\options and change template to normal

2. No does not change old files But if you set zoom to 75% and save file it will be the same
gwassef
20-08-2006, 03:20 PM
it works for new files only, but does not save the zoom for old files... thanks anyway
Robert Walls
09-02-2008, 12:16 PM
Updated template - cell size is same as the default one - but if you use opens up as if 75% zoom.

I tried to open the attached zip file, it seems to be corrupt. I'm getting the WinZip message: "Can't open file: it does not appear to be a valid archive."

Can anyone please check and repost the attachment? or is there something I'm doing wrong?