addpic or changepic workaround on xlsx

Hi,

It was noted that changepic will not work on xlsx. But is there a way to add pic (if not change) on a spreadsheet?

Thanks!

Hi Jovani,

"changepic" does not work with Ms Excel yet. This is because pictures are not saved in the sheet when using Ms ExceL
But it will be possible with OpenTBS 1.8.0 which is currently in beta version.


If you're interested, I can send the beta version to you.

Hi Skrol29,

Yes, kindly send me the beta version. Thanks so much!

Actually, what i have done so far as a workaround was to modify the archive. Initially i place images on the sheet as placeholders and also place some ope=addpic. I modified drawing1.xml.rels replacing the image filenames with those generated for the ope=addpic. It works but got a limitation of not being able to adjust the image dimension on the fly. :)

Thanks!

Jovani

btw, my email is vojalf [at] gmail [dot] com . thanks! :)

Hi Jovani,

The beta is available here :
  http://www.tinybutstrong.com/dl.php?f=tbs_plugin_opentbs_beta.zip&s=2

You can use parameter "changepic" with the new "search=forward" (detailed in the manual). This enables you to put the TBS tag inside the picture properties, such as Title or Description.
This is nice, but you still have to open the "xl/drawings/drawing1.xml" in order to have the [onshow] or [onload] TBS tag merged.
(in Ms Excel files, picture are not saved in the sheet but in a sub files such as "xl/drawings/drawing1.xml")

Thanks so much!

Will try this out.

Hi Skrol29,

I was not able to make it work with "ope=changepic" on xlsx. I got that error "...  has failed to found the picture".

"This is nice, but you still have to open the "xl/drawings/drawing1.xml" in order to have the [onshow] or [onload] TBS tag merged." --> do you mean to open manually that file in editor? no idea really. :)

Thanks!

Jovani

Hi,

No, I mean to load it with $TBS->LoadTemplate('#xl/drawings/drawing1.xml');

I you can wait 1 or 2 days, I'm adding a new OpenTBS command to scann and merges all "drawing1.xml" files.

Sure. That would be great. Thanks! :)

Hi Jovani,

The is a new beta version available for download.
Thinks are much more easy for changing picture in an MS Excel workbook.
There is an example in the 2th sheet of the XLSX template provided with the beta version.

You need two new features for merging images in Ms Excel:
- new parameter "tagpos=inside"
- new command OPENTBS_MERGE_SPECIAL_ITEMS

Download the beta version:
http://www.tinybutstrong.com/dl.php?f=tbs_plugin_opentbs_beta.zip&s=2

Thanks Skrol29! It is working now. :)

BTW, i do notice height (preserving aspect ratio of new pic) is not adjusted even if i used adjust=samewidth.

Hi Skrol29,

Will you include the pic adjustment (for xlsx) in your next release? Badly needed that feature. :)

Thanks!

Hi Jovani,

I'm working on it.
For now it seems doable, but there is still problems.

The size of the picture is defined totally differently in Ms Excel file and in Word or PowerPoint.
OpenXML is a nightmare compared to ODF.

Nevertheless I think it will be possible to make parameter "adjust" working in Excel. Soon.

Great! Thanks! :)

Hi Skrol29,

I just noticed while debugging within TbsPicAdjust function, the tbs field of the first picture (i got 5 in a sheet) is not yet merged. The second time it goes in to the function for the second picture, the tbs field of the first picture only got merged while the current (2nd pic) was not. I think this cause it to merge the dimensions from previous pic into the current pic.

Thanks!

Ok, I'll check that. I didn't tried with several pictures yet.
Is this with the beta version ?

Yes, with the beta version (1.8.0-beta-2012-07-15). Thanks!

Hi Jovani,

There is a new beta version available.
It should fix the problem of image resizing in XLSX.
You're welcome to send feedback.

Hi Skrol29,

Had just tested it and verified working great! Awesome!

Thanks!