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
That's good to hear, Mark. There were changes from our older pre-ABD versions of these files, not that I recall the details, and though I wouldn't have guessed justification in particular would be an issue obviously there was a connection!
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.
Mark Mates - BIM Manager - Mason & Hanger
You're welcome!
That´s perfect! I try to avoid Quantify too, but sometimes they have asked me for it. Thanks.
Pedro Martín García - BIM WIP
http://www.bimwip.com/ --- pmartgar@bimwip.com --- http://www.linkedin.com/in/pedromartingarcia/en
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"