Why Navigator shows the image that not exist in xlsx sheet?

tane · July 15, 2020, 9:40am

Navigator in Libre office shows that there is an image named Picture1 but it not exist (not shown) in sheet. Any help?

I have added Picture in xlsx programicaly (Golang programing language) and sent it as REST response, so I thing there is some issue in HTTP response.test.xlsx

anon73440385 · July 15, 2020, 10:04am

Please make a copy of your file, delete any content and upload the resulting (supposedly empty) .xlsx file showing the image in Navigator. Use clip symbol while **edit**ing your question to upload a file.

tane · July 15, 2020, 11:02am

I added xlsx in question, so you can check what I am talking about

erAck · July 15, 2020, 11:28am

For me for the attached file the image isn’t even listed in the Navigator, but it’s present in the file as xl/media/image1.png and drawing relations are stored with

<xdr:from>
  <xdr:col>8</xdr:col>
  <xdr:colOff>0</xdr:colOff>
  <xdr:row>0</xdr:row>
  <xdr:rowOff>161640</xdr:rowOff>
</xdr:from>
<xdr:to>
  <xdr:col>8</xdr:col>
  <xdr:colOff>-22046040</xdr:colOff>
  <xdr:row>0</xdr:row>
  <xdr:rowOff>-11796120</xdr:rowOff>
</xdr:to>

That doesn’t make sense as it leads to a negative width and height.