Apache OpenOffice (AOO) Bugzilla – Issue 104858
embedded ole object in autotext not updated correctly
Last modified: 2017-05-20 11:25:44 UTC
In #99786 i mentioned that its not only in imported autottexts. to reproduce: open new writer sheet, insert an calc sheet (Insert -> Object -> OLE -> OpenOffice Calc 3.x), enter an "1" into the sheet, create an autotext. update the calc sheet (enter "2") and update the autotext. If you insert your autotext again, the current trunk will show the "2" (because of the patched preview of ole objects), in older versions it will show the old "1". But in both versions, if you try to enter the sheet, it will switch to the old content ( "1" ) you can test it with more complex tables too, so you see it always uses the old table, if you use the old shortcut and only update the autotext. if you create a new autotext (with a new shortcut), delete the old, and rename the new one back to the old shortcut, it suddenly uses the old ole object again. npower said its not possible to put ole objects in autottexts with ooo, but that works, but soon as you have to update the autotext (for example, new version of a customer bill, changes in taxes or something like that, error in format, ...) you should be able to update it. The preview's updated (in current trunk because of patch in #99786), but not the content of the embedded calc sheet. I think that issue was never hit in your tests ;)
>npower said its not possible to put ole objects in autottexts with ooo well, I only said that I was not able to get it to work, I am no expert on autotext, I just fixed a bug that I found in the import :-/
okay i tried it on a ooo 2.4.0 (which I've found on one of my older pcs ;) ) and theres the same as in the other versions.
OS: happened also in OOo 2.4 - new Writer doc - insert an spreadsheet as OLE object - type "1" in one cell - select the paragraph containing the OLE object - Edit - AutoText - Create an AutoText from the selection - In the document insert the Autotext -> OLE showing "1" correctly inserted - replace "1" with "2" in the OLE - Select the paragraph containing the OLE object - Edit - AutoText - Button [AutoText] - Replace - In the document insert the Autotext -> The OLE still shows "1" instead of "2" Note: Editing this AutoText in the dialog ([AutoText] - Edit) doesn't help either.
Reset assigne to the default "issues@openoffice.apache.org".