Issue 33325 - Offsheet references corrupted converting to Pocket Excel
Summary: Offsheet references corrupted converting to Pocket Excel
Status: CONFIRMED
Alias: None
Product: xml
Classification: Code
Component: smalldevices (show other issues)
Version: OOo 2.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: AOO Later
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2004-08-23 20:38 UTC by cadman64
Modified: 2013-02-07 22:17 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description cadman64 2004-08-23 20:38:08 UTC 
Offsheet references in a OOo spreadsheet are corrupted when converting to 
Pocket Excel format.  The resulting formula is an onsheet reference.  E.g. A 
cell on Sheet1 is ='Sheet2'!B4.  After conversion to Pocket Excel, it is 
='Sheet1'!B4.
Comment 1 oc 2004-09-08 16:25:43 UTC 
Hi Martin, please have a look. I can't confirm this because of #i33702#
Comment 2 martin_maher 2005-04-13 17:06:01 UTC 
mmaher->flr: Yours I think
Comment 3 thackert 2005-06-26 17:43:42 UTC 
I have seen that this issue is OOo 1.1.2 (which is rather old) related and that the last entry was in 
April ... :(
Have you tried this with a newer version of OOo like 1.1.4 or some m10x builds? Does your 
problem occur there, too?
Comment 4 atdsm 2005-12-13 16:49:15 UTC 
Revisiting issue in order to clean up old unconfirmed issues...

Issue does occur w/ OOo 2.0 (Windows XP SP2). To reproduce:

1) Open Calc
2) In cell A1, enter "=Sheet2.A1"
3) File -> Save As Pocket Excel format (.pxl)
4) Close file
5) Open the .pxl file
6) Cell A1 will now display an error ("Err:522") and contain the formula
"=$Sheet1.A1"

*Confirming.
*Changing version to OOo 2.0
Comment 5 Mathias_Bauer 2007-08-30 10:35:08 UTC 
Svante, one for you