Thread View: comp.windows.misc
3 messages
3 total messages
Started by Olivier PLAUT
Sat, 21 Nov 1992 11:47
*** Still need ** HELP ** with EXCEL3/4 and cell formatting !!! ***
Author: Olivier PLAUT
Date: Sat, 21 Nov 1992 11:47
Date: Sat, 21 Nov 1992 11:47
56 lines
2245 bytes
2245 bytes
Hello. I repost this message, since I received only two answers which didn't solve my problem. I need some help with EXCEL. I'm running EXCEL 3.0 and EXCEL 4.0 under WINDOWS 3.1. The problem is exactly the same with Excel 3 and 4. I have differences between what I see on the worksheet and what appears on the PrintPreview (the printed size corresponds to the preview). Let's say I write in a cell: | | | |This is a long text| | | | This text is 2 cells wide. It fills exactly 2 cells on the worksheet. What I have on the preview is: | | | |This is a long text | | | | The cells are actually wider. This is very uncomfortable when I use Format Border Outline around the two cells. I'm using True Type Fonts. The problem is the same with all sorts of fonts. Using another PC, I didn't had this problem. I copied the file to my PC and I have the problem again. I was using the same EXCEL version under WINODWS 3.0 with Adobe ATM 2.0 and I hadn't this problem. I have the same problem with 3 PC and 3 different printers. For each printer, I have the latest version of the printer driver. HAS SOMEONE AN IDEA WHICH COULD SAVE ME OUT OF THIS NIGHTDREAM ? Thanks. Olivier. -- ------------------------------------------------------------------- Olivier Plaut | Institute of Forensic Medicine | Phone: +41 (22) 702.56.12 Toxicology Unit | Fax: +41 (22) 789.24.17 University of Geneva | Av. de Champel 9 | E-mail: plaut@sc2a.unige.ch CH-1211 Geneve 4 | plaut@cgeuge52.bitnet Switzerland | -------------------------------------------------------------------
Re: *** Still need ** HELP ** with EXCEL3/4 and cell formatting !!! ***
Author: mcclain
Date: Sat, 21 Nov 1992 20:00
Date: Sat, 21 Nov 1992 20:00
20 lines
1345 bytes
1345 bytes
You are not getting many answers because you are posting to the wrong group. Comp.windows.misc is for discussion of topics relating to multiple windowing systems and/or window systems that do not have there own group(s) -- not ms windows. For MS Windows question you should check out the comp.os.ms-windows groups. I do not read ethere of these groups but judging from their names I would try: comp.os.ms-windows.apps comp.os.ms-windows.misc I suggest subscribing to these two groups, look over the last few 100 posts to get a fell of what these groups discus (and to see if you question has already been answered) and then if necessary post to the most appropriate group. John W.F. McClain The above opinions are not DEC's
Re: *** Still need ** HELP ** with EXCEL3/4 and cell formatting !!! ***
Author: richard.e.stealey
Date: Mon, 23 Nov 1992 21:02
Date: Mon, 23 Nov 1992 21:02
30 lines
1935 bytes
1935 bytes
I tried your situation here on my PC. I have had similar problems with
a printer that was supposed to be emulating a HP Laserjet II and I
was using a IIp driver. It was ok in Windows but I couldn't get Excel
4.0 to print the true type fonts in different point sizes. When I
selected Laserjet II it corrected it. But..... I know,you said it is
not the fault of the printer driver. Here's a few other ideas,
Use Courier New, any point size. It is not "proportional font", so all
text will line up where you expect them to. Other fonts space the text
differently (i.e. iii takes up less space than ZZZ).
Remember you can change the column width from within Print Preview. Hit
the margin button, and then drag the little black buttons at the top
of the preview screen. This is if you dont mind if the column widths
are changed.
If you want the col. widths to stay as they were, but you want the Format,
Border, Outline to block your single cell of text (that is overflowing
into the next column) do this:
Put the pointer into the cell (A1 for example)
move the pointer to the lower left of the cell where it changes
into a black cross
Click and drag over into the second cell (A2)
The text AND the border will move into cell A2
Now delete the text in A2 with a DELETE and a Carriage Return
Your text will now have the proper border around it.
Good luck
Rick
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads