Apache OpenOffice (AOO) Bugzilla – Issue 5919
Formulas entered as textfield in MS-Word are not imported
Last modified: 2013-02-07 22:39:26 UTC
When importing MS-Word documents, formulas entered as textfield (not formulaobject) are not imported. After saving the document as MS-Word, the formulas are lost completely.
Created attachment 2002 [details] example
Rassigned to MRU.
Unfortunately there does not exist a corresponding feature for formula fields in openOffice. Thus these fields are completely lost on import. MRU->FT: does there exist a plan/proposal for such fields from Word?
Hi Andreas, I don't think we will implement such field in 1.1 but we might map it to something sensible (or at least preserve the data as long sa the document is not saved in OO format)
ÃMA->CMC: If you have a simple hack like import as plain text or so, please do so. On the other hand we want to extend our field formats for the OOo 2.0. We should set the target to OOo 2.0 when you've done what could be done without to much effort for the OOo 1.1.
No we can't do plain text for this, other fields contain the postrendered result of the fields, EQ's don't. We need to either import them as equation field -> starmath, or a seperate field for it. Can't do anything for 1.1 :-(
reopen to reassign
cmc->ama: This can only be imported/exported without loss if we have an equation field like word's one. There is no previously generated text result in a word formula field so we cannot even display that instead. And converting it to a starmath formula would mean it wouldn't be exported as a formula field anymore. So I think back to you to decide if we want a comparable feature in writer.
Ok, we've to estimate the effort for such new field and see what we can do.
What do you think about this field type?
Adding fields seems to be Hennings job now. We had such a field in the past. The effort to create a new one is not the problem but the evaluation of the formula is.
.
An alternative solution is to let the \EQ fields visible as simple text (may be rounded with special characters like {{{EQ\f(1,2)}}}?) when importing .doc files. They are completely lost in the current version. Then a basic macro could be made, to translate this 'code' in a OOFormula... A possible evolution? <rem> please accept my low english langage level ;-) </rem> Regards
Because of a shortage of resources we have to retarget this issue to OOo later.
In OpenOffice Writer 1.1.2 formula (=sum) in table is lost (but original value of sum is displayed), when I save my document in Word 97/2000/XP format and reopen this document from .doc file. Is this the same bug or I should report another ? I've tried to open same document with MS Word 97 and there formula is disapeared too :( It seems problem is not only with importing, but also with exporting to MS Word 97/2000/XP format. I can attach sample document if you want.
mantas: > In OpenOffice Writer 1.1.2 formula (=sum) in table is lost (but original value of sum is displayed), when I save my document in Word 97/2000/XP format and reopen this document from .doc file. Is this the same bug or I should report another ? This is not the same problem, so you should file a new issue. You can cc me to the new issue or send me a mail with the ID, so I'll go and verify it.
*** Issue 50723 has been marked as a duplicate of this issue. ***
changed component to reflect that this should be solved within Math. Changed to Feature, as this is really a new feature
reassign to requirements
+ OOo pretends to be compatible with MS Word, so this serious defect should be classified P2. + I don't know if the "version" has to be the version the bug was originally found in, or the last version concerned by the bug, and cloph doesn't want update version reports. I'm very afraid this issue will be forgotten again for years, as being an old one. (This is why I had opened a different one for OOo 2.) + Subcomponent should probably not be "ui". + Still no target milestone ? (Maybe could be set to OOo 9 ?)
umr5174: please get familiar with issue-handling guidelines. Defect or Enhancement is not decided upon the subjective "feeling". It is irrelevant whether the user sees this as a bug. If programmers need to write new code, then it is a "Feature" in IssueZilla.<period> regarding prio: OOo does not crash, it doesn't freeze, no functional area is lost. -> It doesn't classify as P2 at all. version-field: should stay at the version the issue was discovered/reported. and yes: I don't want comments like "still occurs in version <foo>" - since the issue-state shows the same information. Feel free to check issues and write something like "doesn't occur anymore in version <foo>" - but esp. for feature-requests or enhancements the "still occurs" message doesn't help at all. Handling RFEs take more time since * ressources are very limited * there are real defects that have to be fixed * issue-planning for new features is not a contineous effort but done in phases. * there are other fetures with a bigger impact "ui" subcomponent is better than code. (or do you have some code?) Stop whining about OOo-developers not implementing your oh-so-important feature. The issues in your scope are only a very small part of the total number of issues. One cannot implement anything. What about investing the money you save with licensing costs to some programmer(s) to implement the feature and then contribute the code?
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
You've just written exactly the opposite of what "cloph" replied just above... Since nobody has produced anything since 2002 for this feature, this incompatibility with MS Word is still here in my version 2.2.1.. And this is why I've not been wasting my time describing OOo bugs any more since july 2005. Regards.