Print Options not working in xv2007 format

[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]

Hello

We are working on a new version that will address issues with the Excel 2007 file format.

[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]

Hello

The next version is probably a couple of months away.

[maseline_98]

Has this been resolved? I can't seem to get this to work in v4.00.67.

[larsa]

Hello

Yes this is fixed in version 5. Please consider an upgrade.