Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110548
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: footer character limit issue in Excel |
| Date | 2018-04-03 14:39 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <pa0hot$dlo$1@dont-email.me> (permalink) |
| References | <83c6146b-086f-4a6b-b78f-56b192ab793d@googlegroups.com> <04cfb1f6-6c61-4d21-8b78-86d6726ea6c6@googlegroups.com> <p9vulq$8pb$1@dont-email.me> <8bbcd552-54d9-4702-ba8e-b74c7a25d5d2@googlegroups.com> |
> Claus,
>
> Changing font size has no effect - it still truncates the last 6 characters
> of the second string at font size 6, 7, 8, etc...
>
>
>
> On Tuesday, April 3, 2018 at 9:13:38 AM UTC-4, Claus Busch wrote:
>> Hi,
>>
>> Am Tue, 3 Apr 2018 05:46:17 -0700 (PDT) schrieb c1802362@gmail.com:
>>
>>> Tried your suggestion. The result is the last character of the Proprietary2
>>> string is truncated.
>>
>> reduce the font size to 7
>>
>>
>> Regards
>> Claus B.
>> --
>> Windows10
>> Office 2016
Just following Claus' suggestion about font size, I set up a sheet as follows:
LeftHeader: &[Date]
CenterHeader: "This string length is exactly 48 characters long" & vbLf
& "The second line string length is much longer at 70 text characters long"
The total length is 120 characters;
The default font Calibri Regular 8pt is used;
Screen res is 1920x1080 at 125% DPI;
Paper orientation is Landscape;
PrintPreview shows the entire footer content.
I suspect your header will print as expected, but your screen res won't show
that if the page is shrunk to fit your screen.
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
footer character limit issue in Excel c1802362@gmail.com - 2018-04-02 07:31 -0700
Re: footer character limit issue in Excel c1802362@gmail.com - 2018-04-02 07:33 -0700
Re: footer character limit issue in Excel GS <gs@v.invalid> - 2018-04-02 19:42 -0400
Re: footer character limit issue in Excel c1802362@gmail.com - 2018-04-03 05:46 -0700
Re: footer character limit issue in Excel Claus Busch <claus_busch@t-online.de> - 2018-04-03 15:13 +0200
Re: footer character limit issue in Excel c1802362@gmail.com - 2018-04-03 09:46 -0700
Re: footer character limit issue in Excel Claus Busch <claus_busch@t-online.de> - 2018-04-03 18:56 +0200
Re: footer character limit issue in Excel GS <gs@v.invalid> - 2018-04-03 14:39 -0400
Re: footer character limit issue in Excel GS <gs@v.invalid> - 2018-04-03 14:46 -0400
Re: footer character limit issue in Excel c1802362@gmail.com - 2018-04-04 07:59 -0700
Re: footer character limit issue in Excel GS <gs@v.invalid> - 2018-04-04 11:02 -0400
csiph-web