You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Omar <o....@bluage.com> on 2011/10/04 12:32:51 UTC
XSSF : can not displaying image when opening Excel2007
i have upload images in excel workbook(my pictures are actually well
uploaded).
but when openning the file (Excel 2007) i'm getting this error and i can't
see these pictures.
"Partie supprimée: /xl/drawings/drawing1.xml partie. (Forme de dessin)".
thanks in advance.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSF-can-not-displaying-image-when-opening-Excel2007-tp4868056p4868056.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: XSSF : can not displaying image when opening Excel2007
Posted by Omar <o....@bluage.com>.
http://apache-poi.1045710.n5.nabble.com/file/n4868166/drawing1.xml
drawing1.xml
Plese can you tell me what part of the XML file atached is refering to bits
causing this issue?
Thanks.
OKA
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSF-can-not-displaying-image-when-opening-Excel2007-tp4868056p4868166.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: XSSF : can not display image when opening Excel2007
Posted by Omar <o....@bluage.com>.
Hi Nick,
i find the source of problem: in my case i download my excel(2007) from a
template.
in my template there is an drawing1.xml in my first sheet ( LOGO picture).
when i want to add another pictures in my sheet , i'm getting the error.
to solve the problem, i delete my picture , and i add it with the others
pictures.
sorry for my bad english .
Thanks,
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSF-can-not-displaying-image-when-opening-Excel2007-tp4868056p4876057.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: XSSF : can not display image when opening Excel2007
Posted by Nick Burch <ni...@alfresco.com>.
On Wed, 5 Oct 2011, Omar wrote:
> After making the changes below in my drawing1.xml , i can see my pictures
> when opening my XSSF workbook(2007) :
>
> 1- delete this tags: <xml-fragment .....> </xml-fragment>
> 2- put this tag at the end of file : </xdr:wsDr>
> 3- add this header
> :xmlns:spr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
> xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"
> xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
> into the tag <xdr:wsDr....>
Any chance you could create a new bug in bugzilla for this? If you could,
include the code you use to generate the problem file, so we've got
something to work with for a unit test. Include the xml tweaks needed too,
then we can look at getting those put in automatically
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: XSSF : can not display image when opening Excel2007
Posted by Omar <o....@bluage.com>.
Hi Nick,
After making the changes below in my drawing1.xml , i can see my pictures
when opening my XSSF workbook(2007) :
1- delete this tags: <xml-fragment .....> </xml-fragment>
2- put this tag at the end of file : </xdr:wsDr>
3- add this header
:xmlns:spr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
into the tag <xdr:wsDr....>
-->how can i assume those changes dinamically (not handlly) without loosing
drawing form ?
Thanks in advance.
OKA.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSF-can-not-displaying-image-when-opening-Excel2007-tp4868056p4872412.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: XSSF : can not displaying image when opening Excel2007
Posted by Nick Burch <ni...@alfresco.com>.
On Tue, 4 Oct 2011, Omar wrote:
> i have upload images in excel workbook(my pictures are actually well
> uploaded).
Have you tried yet with 3.8 beta 4?
> but when openning the file (Excel 2007) i'm getting this error and i can't
> see these pictures.
>
> "Partie supprimée: /xl/drawings/drawing1.xml partie. (Forme de dessin)".
Are you able to persuade excel to tell you what bits of the xml part it
doesn't like?
Nick