Dawn, Thats right. You don't see the pennies, you have to reformat the cells to see the pennies. But I have users who I don't want to get a call from that they can't see the pennies. The XLSW option is what will work for them. Bill
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Hast Sent: Tuesday, December 02, 2008 2:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: XLS Specification File *.RGW Bill, Just a quick clarification on this. When exporting using the XLS option, the pennies are there, they're just not showing. The display format for the cells using that export is 0 decimal places. So they're not getting stripped, they just don't show until you change the display format for that column. The XLSW option includes the formatting (or rather tells Excel how to format it I think).... Dawn -------------- Original message from "Bill Eyring" <[EMAIL PROTECTED]>: -------------- > John, > > I found the answer to the pennies problem. It seems if you do Gateway export > XLSW the pennies show correctly. If you do gateway Export XLS the pennies do > Not show. Go Figure. > > Thanks for your help. > > Bill Eyring > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Eyring > Sent: Tuesday, December 02, 2008 9:15 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: XLS Specification File *.RGW > > John, > > Thanks for your advice. I was able to export the data that I needed into an > XLS spredsheet. > However, the currency columns do not export with 2 decimal places. Any ideas > as to how I can fix this ? > > Bill Eyring > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John > Docherty > Sent: Monday, December 01, 2008 8:17 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: XLS Specification File *.RGW > > Bill, > > You have to use the Wizard to create the RGW file and after that you can > include the file name in a command file as the SPECIFICATION_FILE NAME. > > This is not something I have used before, but Razzak did cover this at the > SAT after the Conference so I can pass on my limited knowledge, and my > attempts today, to suggest the following as a starting point:- > > To use the Wizard select Use Export Wizard as the response to the Select > Format option. Then click on Specifications after you have selected the > Excel WORKBOOK option, click on SAVE and enter a file name for the RGW file > and then proceed to set up the options for each column then export the data. > (If you want to reuse the rgw file via Gateway you have to Load the file, > and then make sure you are still using a Workbook for the output format as > far as I can see.) > > I note that Excel 2007 gives me a warning about the file format when opening > the file, but it certainly appears to be OK > > I am sure that someone else will give you some better, more accurate > information, but this may at least get you started. > > Regards, > > John Docherty > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Eyring > Sent: Tuesday, 2 December 2008 1:36 p.m. > To: RBASE-L Mailing List > Subject: [RBASE-L] - XLS Specification File *.RGW > > Can anyone help me understand/direct how to create an XLS specification file > when using Gateway Export ? > > I have been playing around with this, but I guess I'm having a brain cramp > since I can get a working specification file going. > > Many thanks, > > Bill Eyring > > >
