Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Word: Formulas in tables not properly imported|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||issues, kami911, walther|
|Version:||OOo 1.1||Keywords:||ms_interoperability, oooqa|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description dawerbuch 2004-02-18 02:36:11 UTC
I have an Office 2K Word Doc that contains a table with formulas. I open this .doc file using OOo WordProcesser. I hover the cursor over a calculated value, but there is no help balloon displayed that should display the formula. F2 in the cell opens the formula editor with an empty formula.
Comment 1 mci 2004-02-18 08:27:27 UTC
reassigned to mru
Comment 2 michael.ruess 2004-02-18 12:06:17 UTC
MRU->BH: Word has formula fields (e.g. "=a+b") where it uses reference fields as operands (because Word does not have Variables). Writer's formula fields must be extended to calculate with reference fields if the import should do something meaningful.
Comment 3 dawerbuch 2004-02-20 15:14:54 UTC
There are a number of issues involving importing a Word document with a table. 1. The imported table displays with lite-grey lines and borders, not the same black lines used in a newly created table. 2. The formulas in the table that reference cells within the table are lost, and only the textual data is retained. I do not know about formulas that reference variables, as I do not use them.
Comment 4 lohmaier 2004-03-22 20:59:37 UTC
please do not change the fields of an issue once set by a developer. Otherwise handling of the issue just will take more time than necessary. The other items have to be ignored one problem -> one issue but regarding 1) The light grey lines are only "helper lines", not actual borders (right click on a table and uncheck "table limits" -> you won't see the lines any more), like the ones that show you the page-area and the footer/header. regarding 2) OOo uses variables, Word doesn't - this is about the internal handling of the formulas. OOo has to learn to "understand" Word's way of handling formulas. For this OOo has to be enhanced -> set type back to enhancement.
Comment 5 michael.ruess 2005-09-28 13:18:19 UTC
*** Issue 54509 has been marked as a duplicate of this issue. ***
Comment 6 michael.ruess 2005-12-13 10:13:05 UTC
*** Issue 58597 has been marked as a duplicate of this issue. ***
Comment 7 chigye 2005-12-16 19:21:45 UTC
The issue with tables in Word documents has been outstanding since day one and if a commonly used part of Word. Marking this an enhancement not a bug doesn't do it justice as this just doesn't work period! Also the fact that the original bug request is so old and there has been no target milestone set disturbs me greatly that this is being swept under the carpet when this is BASE fucntionality of Word and should be a top priority. James
Comment 8 lars 2006-01-29 12:30:34 UTC
*** Issue 61259 has been marked as a duplicate of this issue. ***
Comment 9 michael.ruess 2007-01-07 14:49:24 UTC
*** Issue 73185 has been marked as a duplicate of this issue. ***
Comment 10 tjfs 2007-01-07 16:44:05 UTC
This bug has been outstanding nearly 3 years, any chance it could be fixed please?
Comment 11 kami911 2007-06-20 17:57:12 UTC
I do not know, but I can confirm it :o)
Comment 12 bettina.haberer 2010-05-21 14:43:41 UTC
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
Comment 13 walther 2011-06-22 09:05:26 UTC
I would very much appreciate having this issue solved. We use still sometimes Word2000 in paralllel to OO 3.2 writer to read .doc files - and then all table formulas are lost. Walther