Issue 79106

Summary: text file reference
Product: Calc Reporter: jayheiman <jayheiman>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.2.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
text files referenced and ods.
none
.ods none

Description jayheiman 2007-07-02 18:22:39 UTC 
Reference to text file produces error502 in selected cells. It works fine for 
all cells/files in first case(sheet) and works for most but not all in second. 
Verified file references to be OK by visual inspection of file listing and 
referencing in existing quatro pro spreadsheet where all works fine > files 
exist.

I see no way to attach the files to demonstrate the issue here.
Suggestions?
Comment 1 jayheiman 2007-07-02 18:25:35 UTC 
Created attachment 46446 [details]
text files referenced and ods.
Comment 2 jayheiman 2007-07-02 18:47:26 UTC 
Obviously I found the attachments section.
Comment 3 frank 2007-07-02 19:21:37 UTC 
Sorry, no ODS file please attach.
Comment 4 jayheiman 2007-07-02 19:33:05 UTC 
Created attachment 46448 [details]
.ods
Comment 5 jayheiman 2007-07-02 19:34:15 UTC 
My error. .ods file not included in zip. Added as separate attachment.
Comment 6 jayheiman 2007-07-23 16:05:54 UTC 
Is there any chance of this being at least looked at this month?
Comment 7 frank 2007-07-24 10:41:20 UTC 
Hi,

this is not a bug but an enhnacement request. Calc is limited to 256 Sheets. You
have 3 Sheets in the document leaving 253 for linked sheets. The amount of your
text files is 336 making a difference of 83 Sheets. Currently each external
reference needs a hidden sheet as cache, these sheets are taken from the 256
sheet limit. The enhancement would be to make these sheets independent from the
limit.

Frank
Comment 8 frank 2007-07-24 10:42:02 UTC 
Hi Eike,

as discussed one for you.

Frank
Comment 9 jayheiman 2007-07-24 15:32:12 UTC 
I suspected the problem might be something to that effect. However that doesn't 
explain why I still get the same problem with the second (3 foot results) sheet 
after I save the sheet into 2 seperate files with only one sheet used in each. 
The second sheet still exhibits the error and there are not so many links 
anymore. Is it still carring the old links and how would I get rid of them?
Comment 10 frank 2007-07-25 10:26:37 UTC 
Hi,

yes, it has all the cached files. You may try to select the relevant data in the
sheet and copy it to a new file or you go to Format-Sheet-Show, select all
sheets to unhide them, select all cache sheets and delete them. Now press
CTRL+SHIFT+F9 for a hard recalc.

The first option works, I've checked it.

Frank
Comment 11 Marcus 2017-05-20 11:11:38 UTC 
Reset assigne to the default "issues@openoffice.apache.org".