Hello Everybody,
Trying to use OpenDocument activities to work on the spreadsheet and everything works properly but one part - after saving edited file all columns formatting (data types - date, text or numeric) is gone and returned to General. Attaching code sample, could you please let me know where the problem lies?
Thank you very much,


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMODS SESSION="OPENDOCSession1" CONNECTBY="create_workbook" WORKBOOK="%sTemp%" OVERWRITE="YES" TEMPLATENAME="%rootFolder%\System\%APUploadTemplate%" /> .... <AMODS ACTIVITY="set_cell" SESSION="OPENDOCSession1" SETTERTYPE="dataset" DATASET="SQLresult" CELLREF="A2" /> <AMODS ACTIVITY="close_workbook" SESSION="OPENDOCSession1" />

Hello Vladimir,

What version of 11 are you running? 11.0.2? 11.0.5?

Would it be possible to provide a temp template so we may test it in house? If you do not feel comfortable posting it, please send an email to automate.support@helpsystems.com so we may open a support case and troubleshoot from there.

thank you.

-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

Hi Alex, sorry for the delay - quite busy times. Attached template, please let me know if you need any additional info. We're using Premium 11.0.2.22
Thank you very much,

Hi Vladimir,

I'm not able to reproduce this. The cells are retaining their initial format after writing the dataset. Could you provide a specific example including the values you are writing?

-------------------------

Devin Cannon | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665