Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Borders in Spearsheet 10

3 posts in Objects Last posting was on 2004-07-12 06:55:41.0Z
200m Posted on 2004-06-03 12:18:29.0Z
Reply-To: "200m" <abucher@atus.ch>
From: "200m" <abucher@atus.ch>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Borders in Spearsheet 10
Lines: 11
Organization: Atus AG
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 80-218-81-203.dclient.hispeed.ch
Message-ID: <40bf1758$1@forums-2-dub>
X-Original-Trace: 3 Jun 2004 05:19:36 -0700, 80-218-81-203.dclient.hispeed.ch
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Jun 2004 05:16:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Jun 2004 05:18:29 -0700
X-Trace: forums-1-dub 1086265109 10.22.108.75 (3 Jun 2004 05:18:29 -0700)
X-Original-Trace: 3 Jun 2004 05:18:29 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7917
Article PK: 735187

Hello, i want to make some Borders in a Spearsheet 10 (MS Excel XP) object

i know how to set small singel border but no someone the syntax to remove
them,
or sett double borders?

the syntax i use for singelborders:

gole_object.Range( '3 :3' ).Borders(9).LineStyle = 1


201m Posted on 2004-07-09 18:58:56.0Z
Sender: 4b2b.40eedfde.1804289383@sybase.com
From: 201m
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Borders in Spearsheet 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40eeeaf0.4c02.1681692777@sybase.com>
References: <40bf1758$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jul 2004 11:58:56 -0700
X-Trace: forums-1-dub 1089399536 10.22.241.41 (9 Jul 2004 11:58:56 -0700)
X-Original-Trace: 9 Jul 2004 11:58:56 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7963
Article PK: 735236

Use Excel's macro recording to see how Excel does it. That
should give you a good idea of how to do it in PB via OLE.

> Hello, i want to make some Borders in a Spearsheet 10 (MS
> Excel XP) object
>
> i know how to set small singel border but no someone the
> syntax to remove them,
> or sett double borders?
>
> the syntax i use for singelborders:
>
> gole_object.Range( '3 :3' ).Borders(9).LineStyle = 1
>
>


200m Posted on 2004-07-12 06:55:41.0Z
Reply-To: "200m" <abucher@atus.ch>
From: "200m" <abucher@atus.ch>
Newsgroups: sybase.public.powerbuilder.objects
References: <40bf1758$1@forums-2-dub> <40eeeaf0.4c02.1681692777@sybase.com>
Subject: Re: Borders in Spearsheet 10
Lines: 26
Organization: Atus AG
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 80-218-81-117.dclient.hispeed.ch
Message-ID: <40f236bc$1@forums-2-dub>
X-Original-Trace: 11 Jul 2004 23:59:08 -0700, 80-218-81-117.dclient.hispeed.ch
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Jul 2004 23:49:56 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Jul 2004 23:55:41 -0700
X-Trace: forums-1-dub 1089615341 10.22.108.75 (11 Jul 2004 23:55:41 -0700)
X-Original-Trace: 11 Jul 2004 23:55:41 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7964
Article PK: 735234

right, but i did that, but i've still some unknown borders.

i can't underline a text, and with double border are still problem.

there the macro-code is diffrent, so i've no idear how to do...



<201m> schrieb im Newsbeitrag news:40eeeaf0.4c02.1681692777@sybase.com...

> Use Excel's macro recording to see how Excel does it. That
> should give you a good idea of how to do it in PB via OLE.
>
> > Hello, i want to make some Borders in a Spearsheet 10 (MS
> > Excel XP) object
> >
> > i know how to set small singel border but no someone the
> > syntax to remove them,
> > or sett double borders?
> >
> > the syntax i use for singelborders:
> >
> > gole_object.Range( '3 :3' ).Borders(9).LineStyle = 1
> >
> >