https://issues.apache.org/bugzilla/show_bug.cgi?id=45707
Summary: Error While opening Excel file written by POI
Product: POI
Version: 2.5
Platform: PC
OS/Version: Windows Server 2003
Status: NEW
Severity: critical
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Created an attachment (id=22496)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22496)
Main File Created By using POI
There are two files.
1) Test-Main.xls --> Created by POI HSSF(Attached).
2) Test-Child.xls --> File create from excel software installed with Office.
Steps to Reproduce
EXCEL file created by POI(Test-Main.xls) as Biff8.0 doesn't work after linking
CELLs to a master sheet created by excel opened using Microsoft
Office(Test-Child.xls).
Recreate steps:
Case -1
1. Open a brand new workbook, lets call it"Test-Child.xls", leave it empty and
save it.
2. Open File "Test-Main.xls" (find attached) created by using HSSF POI
3. Copy G3 cell value from "Test-Main.xls"
4. Do a Paste-Special-Link of those cells into "Test-Child.xls"
5. Save and close both workbooks
6. Open just "Test-Child.xls"
7. You will be prompted that this sheet has links, click Update.
8. It works fine.
Case -2
1. Open a brand new workbook, lets call it "Test-Child.xls", leave it empty and
save it.
2. Open File "Test-Main.xls" (find attached) created by using HSSF POI
3. Copy "F3" or "G5" cell value from "Test-Main.xls"
4. Do a Paste-Special-Link of those cells into "Test-Child.xls"
5. Save and close both workbooks
6. Open just "Test-Child.xls"
7. You will be prompted that this sheet has links, click Update.
8. You will then get an error that the link Cannot be updated
9. If you check the link staus you will see a note that the source sheet must
be open.
Case -3
1. Open a brand new workbook, lets call it "Test-Child.xls", leave it empty and
save it.
2. Open File "Test-Main.xls" (find attached) created by using HSSF POI
3. Copy "F3" or "G5" cell value from "Test-Main.xls"
4. Do a Paste-Special-Link of those cells into "Test-Child.xls"
5. Save and close both workbooks
6. Open just "Test-Child.xls"
7. You will be prompted that this sheet has links, click Update.
8. You will then get an error that the link Cannot be updated
9. If you check the link staus you will see a note that the source sheet must
be open.
10. Close the "Test-Child.xls" workbook.
11. Open workbook "Test-Main.xls"
12. Change the value of F3 or G5 cells and save t.
13. Close the "Test-Main.xls" workbook.
14. Open "Test-Child.xls" workbook. It opens without any error!!!
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
