pemurray
asked on
SaveAs Columns Formatted As Text
Greetings all,
I have a perplexing problem. I am not sure if it is related to Excel or PowerBuilder. I have a datawindow with a bunch of columns (some computed fields) that I have to saveas 'HTML' with an extension of '.xls' in order to correctly save the computed fields (if you just save as Excel the computed fields are not saved).
We submit these documents to trading partners and they (multiple partners) keep coming back to us complaining that certain fields are not formatted as TEXT. I have been formatting the fields as 'custom' with leading zeros per their specs. Sadly, when I add the leading zeros to the datawindow, they do not show up in the 'SaveAs' HTML file.
Can someone please help me?
Thanks!!
PEM
I have a perplexing problem. I am not sure if it is related to Excel or PowerBuilder. I have a datawindow with a bunch of columns (some computed fields) that I have to saveas 'HTML' with an extension of '.xls' in order to correctly save the computed fields (if you just save as Excel the computed fields are not saved).
We submit these documents to trading partners and they (multiple partners) keep coming back to us complaining that certain fields are not formatted as TEXT. I have been formatting the fields as 'custom' with leading zeros per their specs. Sadly, when I add the leading zeros to the datawindow, they do not show up in the 'SaveAs' HTML file.
Can someone please help me?
Thanks!!
PEM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried it. I bought it. Works GREAT!!
Thank you!!
Paul