C
Corey Alix
Is there a forum for notifying Microsoft of OWC bugs? Perhaps it is this
newsgroup? I would like to inform them of a fairly serious bug that hasn't
been fixed by the latest OWC10 patch (I have not tried to reproduce in
OWC11):
1. Create a new spreadsheet instance.
2. Reference a cell on "Sheet2" from "Sheet1" (e.g. on Sheet1 cell A1, enter
=Sheet2!A1).
3. Insert a sheet between Sheet1 and Sheet2
4. Save the spreadsheet by writing XMLData to a file (or wherever).
5. Create a new spreadsheet.
6. Assign XMLData to the value written to the file (or wherever).
7. Notice that the formula now reads =Sheet4!A1.
The workaround for this is to give the sheet "Sheet2" a name (e.g. "Data").
newsgroup? I would like to inform them of a fairly serious bug that hasn't
been fixed by the latest OWC10 patch (I have not tried to reproduce in
OWC11):
1. Create a new spreadsheet instance.
2. Reference a cell on "Sheet2" from "Sheet1" (e.g. on Sheet1 cell A1, enter
=Sheet2!A1).
3. Insert a sheet between Sheet1 and Sheet2
4. Save the spreadsheet by writing XMLData to a file (or wherever).
5. Create a new spreadsheet.
6. Assign XMLData to the value written to the file (or wherever).
7. Notice that the formula now reads =Sheet4!A1.
The workaround for this is to give the sheet "Sheet2" a name (e.g. "Data").