Output Excel using template

Comments

3 comments

  • Avatar
    Adrian Williams

    The use of merged cells within the template.xlsm file appears to not be handled well when creating the output file. If the cells are de-merged and left-justified, the layout appears to be better but not the same as the template. When the output file is opened, the repair option is selected and the Enable Editing button clicked, the repair results indicate the error is with the first sheet:

    Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 0.

    The  data appears to be present in the file in the expected cells. 

    However, when the Enable Content button is clicked Excel generates a compile error in the VB code of a hidden module:

     

     

     

    Attached files

    Template_NoMerge.xlsm

     

    0
    Comment actions Permalink
  • Avatar
    Thomas Trulsson

    Thank you Adrian.

    However, the template is used across the company and will not be changed.
    So i guess i will have to continue using LAE until this issue is solved.

    It is a shame, because i have gotten everything else to work in the graph.

     

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    The issue has been forwarded to our engineering team for Analyze.

    Reference LAE-22125.

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk