Issue 79106 - text file reference
Summary: text file reference
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-07-02 18:22 UTC by jayheiman
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

text files referenced and ods. (68.15 KB, application/x-compressed)
2007-07-02 18:25 UTC, jayheiman
no flags Details
.ods (21.79 KB, application/vnd.sun.xml.calc)
2007-07-02 19:33 UTC, jayheiman
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 

I see no way to attach the files to demonstrate the issue here.
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]
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

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

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

as discussed one for you.

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

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.

Comment 11 Marcus 2017-05-20 11:11:38 UTC
Reset assigne to the default "".