Search found 5 matches

by BobM
Thu May 03, 2012 2:04 pm
Forum: XLSReadWriteII 3/4/5
Topic: Print Options not working in xv2007 format
Replies: 5
Views: 11772

Re: Print Options not working in xv2007 format

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...
by BobM
Wed May 02, 2012 6:40 pm
Forum: XLSReadWriteII 3/4/5
Topic: Print Options not working in xv2007 format
Replies: 5
Views: 11772

Print Options not working in xv2007 format

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.Optio...
by BobM
Fri Nov 21, 2008 9:12 pm
Forum: XLSReadWriteII 3/4/5
Topic: Corrupt spreadsheet after deleting sheets?
Replies: 1
Views: 1617

Corrupt spreadsheet after deleting sheets?

I have a large Excel 2000 workbook (20 sheets, 130MB). Using XLSReadWriteII v3, I can open the workbook and delete all but the two sheets that I need, resulting in a 20MB file. However, upon opening in Excel 2007, I receive an error message that data is lost, and that the file cannot be repaired. If...
by BobM
Mon Jul 02, 2007 8:16 pm
Forum: XLSReadWriteII 3/4/5
Topic: Setting Chart MarkerStyle and file error
Replies: 0
Views: 1862

Setting Chart MarkerStyle and file error

I'm trying to set the marker style of a series like so: vSeries := Series[0]; with vSeries do begin HasDefDataPoint := TRUE; DefDataPoint.MarkerFormat.Automatic := FALSE; DefDataPoint.MarkerFormat.Size := 20; DefDataPoint.AreaFormat.ForegroundColor := xcYellow; end; If I do this, save the workbook, ...
by BobM
Sat Jun 30, 2007 2:33 am
Forum: XLSReadWriteII 3/4/5
Topic: How to change Chart Area frame?
Replies: 0
Views: 1858

How to change Chart Area frame?

I can change the frame of the plot area to clsNone by using

Chart.PlotArea.Frame.LineFormat.LineStyle := clsNone;


How can I set the frame of the entire chart to clsNone as well? This is the frame that encompasses the plot area, legends, etc.


thanks,

Bob M..