Apache OpenOffice (AOO) Bugzilla – Issue 66393
Lotus .wk1 import filter can't handle formulas containing string concatenation
Last modified: 2023-07-07 18:14:16 UTC
When OpenOffice.org Calc imports a .wk1 file, it replaces any formula containing a string concatenation operator (&) with =#NAME!#UNKNOWN FUNC NAME#() . To reproduce the problem: 1. Run a spreadsheet program that can save .wk1 files. (Unfortunately, OOo Calc itself *can't* do this, so you'll have to use a different app.) 2. Enter a formula that uses string concatenation. For example, if you're using Lotus 123 or Quattro, you could enter this: +"foo"&"bar" or, if you're using Excel, you could enter this: ="foo"&"bar" 3. Save the file in .wk1 format. 4. Open the file in OpenOffice. (I'd be glad to provide an example .wk1 file showing the problem if someone would tell me how to upload attachments here. The "Submit an Issue" page explicitly indicates that attachments are supported, but I don't see any means of doing this.) In case it helps, I should mention that a bit of quick testing shows that this bug was not introduced by any recent changes, as both OpenOffice 1.1.5 and StarOffice 5.2 show the same behaviour.
Created attachment 37109 [details] Example .wk1 file showing the problem
Okay, apparently you can only upload an attachment *after* submitting the initial bug report. That's severely unintuitive. In any case, I've uploaded an example file now.
confirmed JA->ER: please have a look at this
.
Accepted.
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Any chance of anyone fixing this? The problem's still there in the 3.0 Beta, more than two years after I originally reported it.
The opcode for concatenation operator is 0x18. It's so trivial to fix.
Reset assigne to the default "issues@openoffice.apache.org".
(In reply to urmasd from comment #8) > The opcode for concatenation operator is 0x18. It's so trivial to fix. Then why haven't you fixed it? ;-)