Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-20631

Viewfile throws ConversionException when field has currency format

      If Excel file has a field with currency format, the conversion fails with:

      viewxls: com.benryan.conversion.ConvertsionException: error converting spreadsheet
      

      Console throws:

      UIDefaults.getUI() failed: no ComponentUI class for: com.jxcell.HB[,0,0,0x0,invalid,alignmentX=0.0,alignmentY=0.0,border=,flags=4194304,maximumSize=,minimumSiz
      =,preferredSize=,blockIncrement=10,orientation=HORIZONTAL,unitIncrement=1]
      java.lang.Error
              at javax.swing.UIDefaults.getUIError(UIDefaults.java:711)
              at javax.swing.MultiUIDefaults.getUIError(MultiUIDefaults.java:133)
              at javax.swing.UIDefaults.getUI(UIDefaults.java:741)
              at javax.swing.UIManager.getUI(UIManager.java:1017)
              at javax.swing.JScrollBar.updateUI(JScrollBar.java:210)
              at javax.swing.JScrollBar.<init>(JScrollBar.java:144)
              at javax.swing.JScrollBar.<init>(JScrollBar.java:159)
              at com.jxcell.HB.<init>(EYFN)
              at com.jxcell.Adapter_2_0.createScrollbar(EYFN)
              at com.jxcell.mvc.Viewview.<init>(EYFN)
              at com.jxcell.ssView.<init>(EYFN)
              at com.jxcell.View.append(EYFN)
              at com.jxcell.View.<init>(EYFN)
              at com.jxcell.View.<init>(EYFN)
              at com.benryan.conversion.SpreadsheetConverter.convert(SpreadsheetConverter.java:336)
              at com.benryan.conversion.XlsConverter$1.doConversion(XlsConverter.java:42)
              at com.benryan.conversion.DocConverter.execute(DocConverter.java:59)
              at com.benryan.conversion.macro.ConverterMacro.execute(ConverterMacro.java:276)
      ...
      

      atlassian-confluence.log throws:

      2010-08-19 21:51:34,776 ERROR [http-8331-3] [com.benryan.conversion.SpreadsheetConverter] convert error converting spreadsheet
       -- url: /display/TEST/Home | page: 262146 | userName: admin | referer: http://localhost:8331/pages/editpage.action?pageId=262146 | action: viewpage
      java.lang.ArrayIndexOutOfBoundsException: 8364
      	at com.jxcell.util.KC.format(EYFN)
      	at com.jxcell.util.ValueFormat.format(EYFN)
      	at com.jxcell.util.WC.I(EYFN)
      	at com.jxcell.Sheet.getValue(EYFN)
      	at com.jxcell.Sheet.getFormattedText(EYFN)
      	at com.jxcell.View.charWidthToTwips(EYFN)
      	at com.jxcell.View.getFormattedText(EYFN)
      	at com.benryan.conversion.SpreadsheetConverter.writeHeaderStyles(SpreadsheetConverter.java:249)
      	at com.benryan.conversion.SpreadsheetConverter.write(SpreadsheetConverter.java:65)
      	at com.benryan.conversion.SpreadsheetConverter.convert(SpreadsheetConverter.java:395)
      	at com.benryan.conversion.XlsConverter$1.doConversion(XlsConverter.java:42)
      	at com.benryan.conversion.DocConverter.execute(DocConverter.java:59)
      	at com.benryan.conversion.macro.ConverterMacro.execute(ConverterMacro.java:276)
      ...
      

        1. currency.xlsx
          8 kB
        2. empty.xlsx
          8 kB
        3. CA Project Control List_2012(Formatupdated)1.xlsx
          13 kB

            [CONFSERVER-20631] Viewfile throws ConversionException when field has currency format

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2900423 ] New: CONFSERVER Bug Workflow v4 [ 3006128 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2795601 ] New: JAC Bug Workflow v3 [ 2900423 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2734650 ] New: JAC Bug Workflow v2 [ 2795601 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400062 ] New: JAC Bug Workflow [ 2734650 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2299260 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400062 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233797 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2299260 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195450 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233797 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1919310 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195450 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1729238 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1919310 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1686861 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1729238 ]

              rackley RyanA
              amohdaris Azwandi Mohd Aris (Inactive)
              Affected customers:
              69 This affects my team
              Watchers:
              57 Start watching this issue

                Created:
                Updated:
                Resolved: