Issue 25631 - Word: Formulas in tables not properly imported
Summary: Word: Formulas in tables not properly imported
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P4 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, oooqa
: 54509 58597 61259 73185 (view as issue list)
Depends on:
Reported: 2004-02-18 02:36 UTC by dawerbuch
Modified: 2013-08-07 14:41 UTC (History)
3 users (show)

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


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

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.