Scribe Losing Excel Formatting

[Steve Jensen]

I am using Scribe to write data to an Excel template that I've loaded into a container field. Unfortunately, while the first write works fine, subsequent writes seem to be overwriting the cell formatting, putting it back into the Verdana font and elimination word wrap, centering, cell colors, etc. Has anyone else seen this issue?

[Steve Jensen]

Some additional notes:

I'm on a Mac using OS X 10.6.8, Scribe version 1.25, and Filemaker 11 advanced. Very strange, and very frustrating.

[Steve Jensen]

Did some more investigations... numbers seem to translate with the formatting intact, but text does not. I can email anyone a demo file if they are interested... it won't let me update it to the forum.

[imoree]

zip it.. then it will be uploaded..

[Steve Jensen]

Attached is a link to the file

Excel Test.zip

[epeeler]

Thanks for that. It appears like it's a bug with Scribe. I will make a bug report with your sample file and hopefully we can get it sorted out.

[Steve Jensen]

Curious as to whether any progress has been made on this...

[wbasham]

Not as of yet. We have recently been able to reproduce the problem and are working on a resolution.

[Steve Jensen]

Just downloaded Version 1.26... works great! Thanks, guys. Problem solved.

Version 1.26 (12/8/2011)

* Fixed loss of formatting with .xlsx files with ScribeDocWriteValue

* Fixed loss of formatting with .docs files with ScribeDocSubstitute

* Fixed loss of formatting with .docx files with Content Control Fields and ScribeDocWriteValue

* Fixed "flatten" flag to work on ScribeDocSaveContainer

* Added ability to retrieve PDF metadata: author, creation date, mod date, creator, producer, subject. Functionality is available in ScribeDocReadValue function.

[wbasham]

I apologize for not posting this here for everyone. We got this fixed and deployed in the latest version. Should work fine now.