XLSReadWriteII (.NET) Issues

[symmetric]

We recently purchased XLSReadWriteII.NET (2.00.32a). We're seeing the following issues:

1. Setting the DataLabel property while generating a pie chart causes an Access Violation

2. When creating a workbook with multiple worksheets, we see that the default (first) worksheet isn't selected. Setting SelectedTab doesn't seem to make any difference.

The second issue isn't a huge deal (the user can click a few times to select a tab), but the first issue is big -- we can't create a pie chart with any captions.

[larsa]

Hello

I will take a look at this, but I'm on vacation until January 16, so I wil do it when I'm back.


Lars Arvidsson

[symmetric]

I asked a developer to provide some sample code of what works and what doesn't work.


The following generates a NullReferenceException

Code: Select all

            TDataPoint p = s.DataPoints.Add();
            p.PointIndex = i;
            p.DataLabel = TChartDataLabels.cdlCategory |  TChartDataLabels.cdlValue;
            p.AreaFormat.ForegroundColor = GetNextChartColor();

As a workaround, the developer is creating labels manually:

Code: Select all

     TChartLabel dataLabel = chart.Labels.Add(TChartLabelType.cltDataPoint);
     dataLabel.DataPointIndex = i;
     DataRow dr = dt.Rows[i];
     dataLabel.Text = String.Format("{0}, {1}", dr[0], fields[1].GetFormattedValue(dr));

[j124650]

2. When creating a workbook with multiple worksheets, we see that the default (first) worksheet isn't selected. Setting SelectedTab doesn't seem to make any difference.

We have the same problem but with WordArt object embedded into excel document with a single sheet. After writing proc sheet is not selected. Printing is also unavailable.

[symmetric]

I will take a look at this, but I'm on vacation until January 16, so I wil do it when I'm back.

Have you had a chance to look into the SelectedTab issue? When we create a workbook with a single worksheet, the sheet isn't really selected. As a result, when users try to print, they get an error ("Microsoft Office Excel did not find anything to print").

In order to get the worksheet to print, one must manually click on the tab a few times to force Excel to select it. (This workaround is not something that will work for our user base....they expect a polished app that just works).

[TieWU]

I am having the same problems as symmetric.

One additional problem I have is that after clicking the tab a few times to select it so that I can print it, my borders and cell colors do not show up in the printout.

Are there any solutions to this?