Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hello WF family, does anybody has any documentation for Exce...


Jan Vostr

Recommended Posts

Hello WF family,

does anybody has any documentation for Excel Templates I was trying to Google but I wasnt very lucky. Long time ago when I was playing with that and now I am stuck because nor xltx, xltm, xlsx works for me. It just creates xlsx without stuff which is in the template.

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT XLSX TEMPLATE template.xltx SHEETNUMBER 1

ON TABLE SET XLSXPAGESETS ON

ON TABLE SET HTMLCSS ON

 

Thanks a lot for any feedback

Jan

Link to comment
Share on other sites

We have several hundred, but all of ours have macros so we use .xltm. The actual output is a .xlsm. The macros do things like freeze panes, turn on filters, filtered sub-totals, set borders, etc. Also, you dont need all the other ON TABLE SET commands (we have ASNAMES set in the edasprof). The one we use most with Excel is ON TABLE SET BYDISPLAY ON
Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...