UpdateDocMode::NO_UPDATE not working for microsoft office extension files??

asked 2018-12-10 15:53:49 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

when microsoft office extension file is loaded with UpdateDocMode::NO_UPDATE descriptor it updates data when new link is referenced while for ods files data does not get updated, a zero is placed in place of link if new data is referenced for ods files.

edit retag flag offensive close merge delete

Comments

@rv: This looks very much relevant to this comment by @Garima. Unfortunately, both that comment, and your question, lack steps to reproduce (specific macro code? specific mouse clicks?)

Do you expect others to try to invent themselves what you already have at hand, just to help you, with the risk of doing something differently (and not see what you see), and with the risk of seeing the same results but considering them OK and not realizing that you expect something else, and overall with risk of just wasting time? please try to be helpful to those who you are asking for help.

Also this question is relevant (some housekeeping to keep duplicates together).

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-11 07:54:07 +0100 )edit

here is the code snippet: Sequence<propertyvalue> LoadArgs(1); LoadArgs[0].Name = OUString("UpdateDocMode"); LoadArgs[0].Value = (Any)(short)UpdateDocMode::NO_UPDATE;

Reference<xcomponentloader> lComponentLoader(mxDesktop,UNO_QUERY);

Reference<xcomponent> lComponent = lComponentLoader->loadComponentFromURL(pURL, pURL, FrameSearchFlag::CHILDREN, LoadArgs);

rv gravatar imagerv ( 2018-12-11 10:29:26 +0100 )edit

Sigh...

I even reimplemented this as a StarBasic macro (so that others could check it), because - well, your "snippet" is basically useless.

Sub LoadAFile(oURL As String)
    Dim oArgs(0) As New com.sun.star.beans.PropertyValue 
    Dim oDoc
        oArgs(0).Name="UpdateDocMode"
        oArgs(0).Value= com.sun.star.document.UpdateDocMode.NO_UPDATE
        oDoc = StarDesktop.LoadComponentFromUrl(oURL, oURL, com.sun.star.frame.FrameSearchFlag.CHILDREN, oArgs())
End Sub

So what now? Can you please try to think what others will do with your data? what specifically do I need to check? if the link should be a OLE link? a cell reference? a DDE? to another document of same type? of another type? whatever?

Don't you think that it would be nice to prepare a test set zip with all the required files, and with the macro, and with descriptions like "using LO version XXX on OS YYY, I see this ...(more)

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-11 10:46:30 +0100 )edit