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.

dw.SaveAs(,excel!,) creates spreadsheet with hidden data

2 posts in DataWindow Last posting was on 2008-11-28 17:54:57.0Z
Sven Franklin Posted on 2008-10-07 23:33:46.0Z
From: "Sven Franklin" <sven.franklin@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Organization: 85.119.130.132
X-Newsreader: AspNNTP 1.50 (JodoHost)
Subject: dw.SaveAs(,excel!,) creates spreadsheet with hidden data
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ebf1da$1@forums-1-dub>
Date: 7 Oct 2008 16:33:46 -0700
X-Trace: forums-1-dub 1223422426 10.22.241.152 (7 Oct 2008 16:33:46 -0700)
X-Original-Trace: 7 Oct 2008 16:33:46 -0700, vip152.sybase.com
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87945
Article PK: 417201

Using PB11.0 on PC with XP.
I use dw.SaveAs(ls_file, Excel! , false)
The spreadsheet is created and the data is there but in hidden columns.
I can manually use Format/Column/unhide to reveal the data but I can't find a
way to set properties together with dw.SavAs().

Is there a solution for this?

My application is resently migrated from PB8.5 to PB11.0 and it work fine
before.

Any ideas?

/ Sven
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


jorgeney.silva Posted on 2008-11-28 17:54:57.0Z
From: jorgeney.silva@gmail.com
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: dw.SaveAs(,excel!,) creates spreadsheet with hidden data
Date: Fri, 28 Nov 2008 09:54:57 -0800 (PST)
Organization: http://groups.google.com
Lines: 26
Message-ID: <894819e6-145e-47e0-ae08-132985129d4f@k41g2000yqn.googlegroups.com>
References: <48ebf1da$1@forums-1-dub>
NNTP-Posting-Host: 201.17.225.206
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1227894898 19186 127.0.0.1 (28 Nov 2008 17:54:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 28 Nov 2008 17:54:58 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k41g2000yqn.googlegroups.com; posting-host=201.17.225.206; posting-account=HZjSjQoAAABN34Ibf-Of8173NfIfcYpX
User-Agent: G2/1.0
X-HTTP-Via: 1.1 ATTBHZS039
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!transit4.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!k41g2000yqn.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88256
Article PK: 417509


On 7 out, 21:33, "Sven Franklin" <sven.frank...@gmail.com> wrote:
> Using PB11.0 on PC with XP.
> I use dw.SaveAs(ls_file, Excel! , false)
> The spreadsheet is created and the data is there but in hidden columns.
> I can manually use Format/Column/unhide to reveal the data but I can't find a
> way to set properties together with dw.SavAs().
>
> Is there a solution for this?
>
> My application is resently migrated from PB8.5 to PB11.0 and it work fine
> before.
>
> Any ideas?
>
> / Sven
> ---== Posted via the PFCGuide Web Newsreader ==---http://www.pfcguide.com/_newsgroups/group_list.asp

I had the same problem in my application. To solve this problem try
the following:

You are using the function 'dw.SaveAs' using this syntax: dw.SaveAs
(ls_file, Excel! , false).

Change your command to: dw.SaveAs(ls_file, Excel8! , false).

The format Excel8! will fix the problem.