1 Reply Latest reply: Feb 16, 2012 5:38 AM by Paul Nockolds RSS

    Export Listbox to Excel - Expression column missing?

    Paul Nockolds

      Hi All

       

      QV10 SR3

      IE plugin

       

      We have a Listbox with an expresion that gives counts.  When we try to export to Excel (either with the XL button or right-clicking > Export...) the expression column does not export?

       

      The expresion is...

      =$(vUserCount)

       

      vUserCount is...

      NUM(SUM({<[HBM Brand]= {$(=$(vActiveBrand))}>}  Counter_User),'#,##0')

       

      vActiveBrand is...

      SubField(GetActiveSheetId(),'_',2)

       

      Does anyone have an idea why the expression column does not export?

       

      Any ideas welcome