Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: domain of thyde@centraldesktop.com
 designates 66.226.4.143 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=centraldesktop.com; h=
	content-type:mime-version:subject:from:in-reply-to:date
	:content-transfer-encoding:message-id:references:to; q=dns; s=
	selector1; b=AcO+YPLlfSqW6nM4nTHa/DNvpVln/awb/XzN2w37gEENl7AVv+L
	bhwE3SfMIYdfF6CC1izTz+oralESJVSjaApWTwFe/b2dz9PjOjd4wGIswh0RzeBJ
	1/D25v5fwsWHgJUi9NUy58IhNUuN33ZAcNxLJR2RYwkMleqONihSbP/0=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1081)
Subject: Re: Issues losing a drawing part when saving an ooxml filesystem
From: Trey Hyde <thyde@centraldesktop.com>
In-Reply-To: <alpine.DEB.1.10.1010131036240.20227@urchin.earth.li>
Date: Wed, 13 Oct 2010 10:40:32 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <9CAA6E96-E2F6-4319-9635-C459BC81B0A5@centraldesktop.com>
References: <1F2FF01C-F6F9-41BD-ACD3-DF9902FB18B0@centraldesktop.com>
 <alpine.DEB.1.10.1010131036240.20227@urchin.earth.li>
To: "POI Users List" <user@poi.apache.org>


On Oct 13, 2010, at 2:37 AM, Nick Burch wrote:

> On Tue, 12 Oct 2010, Trey Hyde wrote:
>> I've been injecting custom document properties with POI in both OOXML =
and OLE files for about 4 months now covering a very large number of =
documents.  I do have one customer complaining when they open my =
meta-data injected version of their file that Excel complains about a =
missing drawing part.
>=20
> Do all files with drawings get affected, or only some? For a file that =
will display the problem, if you open and save (without making any =
changes) do you see the problem? Or is it only after you make other =
changes that the drawing gets lost?


The drawings all seem intact but only tangible difference I see is the =
missing hyperlink rel in drawing1.    I  just modified the code to not =
actually make any changes and I see the same thing.   See the code =
below.   The commented region is what the core of my utility does ...   =
Open the pakage, open the props, add / modify custom properties, commit =
the properties, save a copy of the package.    Just doing that (even =
when not executing the property part) is dropping that rId1 hyperlink =
relation which is causing Excel 2007 to freak out.   Mac Office doesn't =
complain.   I'm not even sure what the image it is complaining about is =
or how it was added.

    public boolean save(Map<String, String> props) {
        try {

            OPCPackage docPackage =3D OPCPackage.openOrCreate(input);
            //, PackageAccess.READ_WRITE
           =20
            POIXMLProperties xmlprops =3D new =
POIXMLProperties(docPackage);

//            CustomProperties custom =3D =
xmlprops.getCustomProperties();
//            CTProperties ct =3D custom.getUnderlyingProperties();
//            CTProperty[] ctp =3D ct.getPropertyArray();
//
//            for (String key : props.keySet()) {
//                if (custom.contains(key)) {
//                    for (CTProperty prop : ctp) {
//                        //System.out.println(prop.getName() + " " + =
prop.getLpwstr());
//                        if (prop.getName().equals(key)) {
//                            prop.setLpwstr(props.get(key));
//                        }
//                    }
//                } else {
//                    custom.addProperty(key, props.get(key));
//                }
//
//            }

            xmlprops.commit();
            File output =3D File.createTempFile("office-ooxml-",null);
            System.out.println(output.getCanonicalPath());
            docPackage.save(output);
            //docPackage.flush();

            return true;
        } catch (Exception ex) {
            =
Logger.getLogger(OpenXMLMDWriter.class.getName()).log(Level.SEVERE, =
null, ex);
            return false;
        }
    }=

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org