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.

SaveAs to Excel

3 posts in Appeon (partner product) Last posting was on 2008-07-30 16:03:22.0Z
Ray Webb Posted on 2008-07-25 13:25:48.0Z
From: "Ray Webb" <hrwebb@spsinc.com>
Newsgroups: sybase.public.appeon
Subject: SaveAs to Excel
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4889d45c$1@forums-1-dub>
Date: 25 Jul 2008 06:25:48 -0700
X-Trace: forums-1-dub 1216992348 10.22.241.152 (25 Jul 2008 06:25:48 -0700)
X-Original-Trace: 25 Jul 2008 06:25:48 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2180
Article PK: 21559

I have a datawindow that contains a field based upon a 'long varchar'
datatype. When I perform a SaveAs using output type Excel5!, the Excel
spreadsheet cells that would have contained a data string >= 256 characters
(or around that length, I didn't determine the exact length. I know that
anything >= 262 has a problem) are blank and I get the message "File Error:
Data may have been lost" when I open the output file using Excel 2007.

If I using output type Excel! with the SaveAs the same cells contain data
and I don't get the "File Error" message, but the data is truncated.
Unfortunately, it's not truncated to a specific length, but the truncation
length appears to be random.

Is there a workaround for this or should this be submitted as a problem that
requires fixing?


Ray Webb Posted on 2008-07-25 16:51:55.0Z
From: "Ray Webb" <hrwebb@spsinc.com>
Newsgroups: sybase.public.appeon
References: <4889d45c$1@forums-1-dub>
Subject: Re: SaveAs to Excel
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <488a04ab$1@forums-1-dub>
Date: 25 Jul 2008 09:51:55 -0700
X-Trace: forums-1-dub 1217004715 10.22.241.152 (25 Jul 2008 09:51:55 -0700)
X-Original-Trace: 25 Jul 2008 09:51:55 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2181
Article PK: 21560


"Ray Webb" <hrwebb@spsinc.com> wrote in message
news:4889d45c$1@forums-1-dub...
>I have a datawindow that contains a field based upon a 'long varchar'
>datatype. When I perform a SaveAs using output type Excel5!, the Excel
>spreadsheet cells that would have contained a data string >= 256 characters
>(or around that length, I didn't determine the exact length. I know that
>anything >= 262 has a problem) are blank and I get the message "File Error:
>Data may have been lost" when I open the output file using Excel 2007.
>
> If I using output type Excel! with the SaveAs the same cells contain data
> and I don't get the "File Error" message, but the data is truncated.
> Unfortunately, it's not truncated to a specific length, but the truncation
> length appears to be random.
>
> Is there a workaround for this or should this be submitted as a problem
> that requires fixing?
>

To provide further information, I tried saving as tab delimited and as XML,
and the data saved with no problem. Strings longer than 256 characters were
properly saved.

For the Excel! output I learned the following. The number of characters in
the cell was the remainder of Length(data)/256. I tried making the string
different lengths and always the output contained the first number of
characters equal to this remainder.


Ray Webb Posted on 2008-07-30 16:03:22.0Z
From: "Ray Webb" <hrwebb@spsinc.com>
Newsgroups: sybase.public.appeon
References: <4889d45c$1@forums-1-dub> <488a04ab$1@forums-1-dub>
Subject: Re: SaveAs to Excel
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <489090ca$1@forums-1-dub>
Date: 30 Jul 2008 09:03:22 -0700
X-Trace: forums-1-dub 1217433802 10.22.241.152 (30 Jul 2008 09:03:22 -0700)
X-Original-Trace: 30 Jul 2008 09:03:22 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2183
Article PK: 13319

This Case has been submitted to Sybase and is currently under review by
Appeon.

"Ray Webb" <hrwebb@spsinc.com> wrote in message
news:488a04ab$1@forums-1-dub...
>
> "Ray Webb" <hrwebb@spsinc.com> wrote in message
> news:4889d45c$1@forums-1-dub...
>>I have a datawindow that contains a field based upon a 'long varchar'
>>datatype. When I perform a SaveAs using output type Excel5!, the Excel
>>spreadsheet cells that would have contained a data string >= 256
>>characters (or around that length, I didn't determine the exact length. I
>>know that anything >= 262 has a problem) are blank and I get the message
>>"File Error: Data may have been lost" when I open the output file using
>>Excel 2007.
>>
>> If I using output type Excel! with the SaveAs the same cells contain data
>> and I don't get the "File Error" message, but the data is truncated.
>> Unfortunately, it's not truncated to a specific length, but the
>> truncation length appears to be random.
>>
>> Is there a workaround for this or should this be submitted as a problem
>> that requires fixing?
>>
>
> To provide further information, I tried saving as tab delimited and as
> XML, and the data saved with no problem. Strings longer than 256
> characters were properly saved.
>
> For the Excel! output I learned the following. The number of characters in
> the cell was the remainder of Length(data)/256. I tried making the string
> different lengths and always the output contained the first number of
> characters equal to this remainder.
>