Apache OpenOffice (AOO) Bugzilla – Issue 64516
Provide import of document variables in Excel documents
Last modified: 2013-08-07 15:13:21 UTC
OOo2.0.2 is able to import document variables from Word documents. We need the same functionality for Excel documents. Perhaps we can move the code for the Word import to SFX and use it for both apps.
started
Implemented import/export of custom properties from/to MS file formats for all applications (Writer/Calc/Impress). Still missing: Predefined built-in properties "Category", "Company", "Manager", and "LinkBase".
Oliver, please just for completeness also test some "normal" xls document that contain some metadata (documentinfo) and check wether the data is imported correctly re-open issue and reassign to oc@openoffice.org
reassign to oc@openoffice.org
reset resolution to FIXED
verified in internal build cws_mbapp3
.
closed because fix available in OpenOffice.org Developer Snapshot Build src680_m169
This issue has Resolution FIXED and Status CLOSED but I think it is not. Please check my simple test: Steps: 1. import Word document with Custom Fields to Writer 2. in Writer save document as Microsoft Word 97/2000/XP (.doc) Results: . After step 1: the Custom Fields are successfully imported to Writer as Variables and are dynamic in text in page. . After step 2: the Variables are successfully exported to Word as Custom Fields BUT ARE NOT dynamic in text, i.e., the variable text is all static in the page! My point is that issue 5091 is not completely resolved. It does not import/export custom properties from/to MS file formats in Writer.
This issue is about *Excel* documents. Excel and Word have different ways to treat document variables. OOo currently does not support the *export* of document variables to Word files, only the import is implemented, but this was another issue already worked on some time ago. At that point in time we only needed the import and so we implemented it. This issue wanted to have the import also for Excel documents. It seemed that export was a low hanging fruit so we added it also, but for Word it's more complicated.
I have continued reporting about Writer2Word exports in other issues. I wrote my comment in this issue to report that the statement «Implemented import/export of custom properties from/to MS file formats for all applications (Writer/Calc/Impress).» is not completly true. This closed issue is referenced in the Release Notes of v2.0.3 «Custom document variables are now imported from and exported to Microsoft file formats (Word, Excel, PowerPoint).» This message in Release Notes is a bit misleading.
Well, Daniel was talking about the custom properties. They are just some header/value pairs in document summary information streams. And it can be proven very easily that we write the same information to the file as we have imported. I'm not sure wether we are talking about the same things. I think the "custom fields" you are talking about are more related to text fields referencing custom properties or document variables (something that Word has in addition to Excel). To my knowledge we never have implemented a support for this. We now can import the properties but we still are not able to correctly import and export the text fields using them. But this is issue 5091 I assume. So consequently issue 5091 is still open, but from my POV it's not the same as this one (otherwise it would have been set to "duplicate" I assume).