Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting LeftHeader / CenterHeader
Hi,
as part of an ASP.NET-application, I am currently developing a script which is supposed to build a spreadsheet in Excel 2003 (under W2k or XP), fill it with data, format it and print it. Everything has already worked nicely, until a user started working with multiple filters in weh application. These filter-settings are supposed to be printed as part of the title, LeftHeader, to be precise. Now when the script runs, it comes up with an error saying something like "Cannot set the ..LeftHeader-Property of the PageSetup-Object". Somehow I then tried to swap the assignments of LeftHeader and CenterHeader, then it would set LeftHeader and crash with a similar error on CenterHeader. So somehow, it seems, these two are connected? I also tried to set LeftHeader in several steps and have now come to a state where it would set LeftHeader 3 times (until it has approx. 180 chars) and it would crash when trying to append 60 additional characters. Makes me wonder if there is something like a maximum size for these props? (Couldn't find any mention of that in the MSDN-Doc). Or why else would it fail here? (The LeftHeader has a leading CR, so it doesn't overlap with CenterHeader, it would go below the CenterHeader). Thanks Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting LeftHeader / CenterHeader
I believe the limit is 255.
-- Regards, Tom Ogilvy "MBaas" wrote: Hi, as part of an ASP.NET-application, I am currently developing a script which is supposed to build a spreadsheet in Excel 2003 (under W2k or XP), fill it with data, format it and print it. Everything has already worked nicely, until a user started working with multiple filters in weh application. These filter-settings are supposed to be printed as part of the title, LeftHeader, to be precise. Now when the script runs, it comes up with an error saying something like "Cannot set the ..LeftHeader-Property of the PageSetup-Object". Somehow I then tried to swap the assignments of LeftHeader and CenterHeader, then it would set LeftHeader and crash with a similar error on CenterHeader. So somehow, it seems, these two are connected? I also tried to set LeftHeader in several steps and have now come to a state where it would set LeftHeader 3 times (until it has approx. 180 chars) and it would crash when trying to append 60 additional characters. Makes me wonder if there is something like a maximum size for these props? (Couldn't find any mention of that in the MSDN-Doc). Or why else would it fail here? (The LeftHeader has a leading CR, so it doesn't overlap with CenterHeader, it would go below the CenterHeader). Thanks Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting LeftHeader / CenterHeader
Tom Ogilvy schrieb:
I believe the limit is 255. Thanks Tom, I've done some more experiments with my code: if I rearrange it, so that LeftHeader is set first and then CenterHeader, I can put the full text to LeftHeader (209 chars) and get the error-msg when trying to put 79 chars to CenterHeader. And then I've put 252 chars into .LeftHeader - and got the error when I tried to assign .CenterHeader="x". So it seems there is a limit 'around' 255 for the cumulated length of LeftHeader + CenterHeader? I don't think this is documented anywhere (in easily accessible 'official' doco, that is) and of course such a restriction seems to be rather poor for a version 2003 :(( Any ideas how I might get around? Thanks Michael |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting LeftHeader / CenterHeader
OK, case closed.
I discovered that when you this over Excels UI, you are not allowed to enter more than 255 chars in total for Left/Center/Right and you also get a message saying so. Pity, pity :( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter Multiple lines using .leftheader | Excel Discussion (Misc queries) | |||
Pagesetup. Is there no way to control the LeftMargin of the LeftHeader ? | Excel Programming | |||
Language portability problems when setting LeftHeader text from external app (=non-VBA) | Excel Programming | |||
VBA Code to Print a Variable as part of CenterHeader Problem | Excel Programming | |||
Excel generation and PageSetup.CenterHeader | Excel Programming |