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

Viewfile throws ConversionException when field has currency format

    XMLWordPrintable

Details

    Description

      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)
      ...
      

      Attachments

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

        Issue Links

          Activity

            People

              rackley RyanA
              amohdaris Azwandi Mohd Aris (Inactive)
              Votes:
              69 Vote for this issue
              Watchers:
              57 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: