Is there any way to control the Excel justification of cells in an exported building schedule? In the properties of a DataGroup Explorer schedule, there is a "Justification" option within Properties > Edit Schedule Options > Formatting tab. However, it only seems to control how the cells are justified in the DataGroup Explorer window. All cells export to be left justified even if I have justification set to center in the excel template. This can be reproduced in an out of the box installation/dataset.
AECOsim BD SS5 08.11.09.747
I´ll go further. Is there any Excel template being used by Qantify tool?
Pedro Martín García - BIM WIP
http://www.bimwip.com/ --- pmartgar@bimwip.com --- http://www.linkedin.com/in/pedromartingarcia/en
bump
Mark Mates - BIM Manager - Mason & Hanger
You can find the Excel schedule template as shown in the attached.
Answer Verified By: mmates
And the template for Quantify tool?
I haven't used the Quantify tool much in quite some time, but as best I can tell its template is pointed to by the config variable TFDIR_XLS - "Location of Microsoft Excel seed file, used when Quantify report is in Excel format"
That´s perfect! I try to avoid Quantify too, but sometimes they have asked me for it. Thanks.
You're welcome!
Thanks Steve. I knew where the Excel template was and the template itself was my problem. I'm not sure if it was because it wasn't from AECOsim BD or if it was an XLS (Not XLSX), but when I updated a new template from ABD, the formatting was honored in the resulting spreadsheet. Thanks again.