Print Options not working in xv2007 format

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
BobM
Posts: 5
Joined: Sat Jun 30, 2007 2:29 am

Print Options not working in xv2007 format

Post by BobM »

I'm using the latest XLSReadWriteII4 version just downloaded from the registered users site. I have found that there are a couple of issues when writing an Excel 2007 version file:

1. It is not possible to turn off grid lines. This works when saving in Excel 97 format:
vSheet.Options := vSheet.Options - [soGridLines];

2. It is not possible to set up print scaling. This works correctly when saving in Excel 97 format:
vSheet.WorkSpaceOptions := vSheet.WorkSpaceOptions + [woFitToPage];
vSheet.PrintSettings.FitHeight := 100;
vSheet.PrintSettings.FitWidth := 1;
vSheet.PrintSettings.ScalingFactor := 400;
The output file shows "No scaling"

3. It is not possible to adjust the margins. This works correctly when saving in Excel 97 format:
vSheet.PrintSettings.MarginTop := 0.10;
vSheet.PrintSettings.MarginBottom := 0.50;
vSheet.PrintSettings.MarginLeft := 0.10;
vSheet.PrintSettings.MarginRight := 0.10;
The output file shows "Normal Margins" of T:0.75 B:0.75 L:0.7 and R:0.7.

Are there source code updates available that I could apply myself rather than waiting for the next version?

Thank you,

Bob M..
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Print Options not working in xv2007 format

Post by larsa »

Hello

We are working on a new version that will address issues with the Excel 2007 file format.
Lars Arvidsson, Axolot Data
BobM
Posts: 5
Joined: Sat Jun 30, 2007 2:29 am

Re: Print Options not working in xv2007 format

Post by BobM »

Lars,

Thank you for that information, however it is not enough. Will the new version be ready next week, next month, next year? I need to decide whether to stick with XLSReadWrite (which I would really like to do) or look for an alternative. Your estimated timing of the new version will be of utmost importance in that decision.

Thank you.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Print Options not working in xv2007 format

Post by larsa »

Hello

The next version is probably a couple of months away.
Lars Arvidsson, Axolot Data
maseline_98
Posts: 10
Joined: Fri Jan 20, 2012 11:49 pm

Re: Print Options not working in xv2007 format

Post by maseline_98 »

Has this been resolved? I can't seem to get this to work in v4.00.67.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Print Options not working in xv2007 format

Post by larsa »

Hello

Yes this is fixed in version 5. Please consider an upgrade.
Lars Arvidsson, Axolot Data
Post Reply