Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | If the document contains references to other document containing data array (for example function VLOOKUP) its volume is approximately equal to the size of the document with data array | ||
---|---|---|---|
Product: | Calc | Reporter: | skniazev <skniazev> |
Component: | save-export | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOO 2.0 Beta2 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- | ||
Attachments: |
Description
skniazev
2005-09-01 12:41:07 UTC
Created attachment 29277 [details]
Examples with references to data array and without them
Created attachment 29279 [details]
Examples with references to data array and without them
Created attachment 29280 [details]
Examples with references to data array and without them
Created attachment 29281 [details]
Examples with references to data array and without them
The problem exists also in build 1.9.128. I have some more simplified the example. You can find it in the today's attachment. You also will find in this attachment the file content.xml.png, being a snapshot of the file content.xml of file main_file.ods (you can receive it from the document using an arbitrary zip tool, for example, with a command 'unzip main_file.ods content.xml'). In red framework is that, in my humble opinion, in it superfluous. I'm sure now, that this is a bug. Created attachment 29554 [details]
The simplified example
Hi, this is not a bug. It's simply the way Excel and AFAIK all other Spreadsheet work. This is because you have to hold the content of the linked range in case you are not connected to the server the linked file is located. So this is an Invalid Issue and I close it as such. Frank closed invalid Hi Frank! I'd like return to theme of Issue 54096. You have written: ------- Additional comments from fst Mon Oct 24 00:46:52 -0800 2005 ------- > > Hi, > > this is not a bug. It's simply the way Excel and AFAIK all other Spreadsheet > work. This is because you have to hold the content of the linked range in case > you are not connected to the server the linked file is located. > > So this is an Invalid Issue and I close it as such. > > Frank But this is not right. As I wrote from the very beginning, to documents prepared in MS Excel this problem doesn't occur, the size of files doesn't depend on volume of data file. So looks cell in OASIS document format: <table:table-cell table:formula="oooc:=VLOOKUP([.A1];['file:///D:/home/root/My Documents/programs/OpenOffice20/Errors/BugID_54096/data_file.ods'#$Sheet1.A1:.B1];2)" office:value-type="float" office:value="1"> <text:p>1</text:p> </table:table-cell> If I have no access to the linked file, I must not update links. Spreadsheet has enough information to show the information without links to the original file. The cell has parameters office:value-type and office:value. In addition to these parameters there is tag <text:p>, which is defined how exactly this cell must look like. If I update links in spite of no access to the linked file, then I get an error "unresolved link". SO works Excel and OpenOffice.org MUST also. I would be thankful, if this issue will be REOPENED and the problem will be actually RESOLVED. Thank you in advance. Stas. Not a defect and not for the near future. This is how external links are maintained. Excel will act in the same way if you choose to have the linked table with the file. Frank Has probably time come to add a necessary option? It would allow to change by 90% of employees of our firm the Office package. Moreover at very big size of a database (our case) MS Excel strictly does not keep it in a file from which it's referenced. Do you understand, that there is no sense to keep with 10kb of data 30Mb of database? Absence of the option, which can change such behaviour, is the real obstacle in using of the given program in our firm. :-( |