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

Viewfile throws ConversionException when field has currency format

XMLWordPrintable

      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. CA Project Control List_2012(Formatupdated)1.xlsx
          13 kB
        2. currency.xlsx
          8 kB
        3. empty.xlsx
          8 kB

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

            Ken Jessen added a comment -

            I am using Confluence 5.3, Office connector 3.1.2 and am getting the same error:
            "Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: java.lang.Exception: You are calling wrong method!"

            My sheet has a chart in it.

            Ken Jessen added a comment - I am using Confluence 5.3, Office connector 3.1.2 and am getting the same error: "Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: java.lang.Exception: You are calling wrong method!" My sheet has a chart in it.

            Edwin Stol added a comment -

            Ryan added a comment - 23/Mar/12 12:07 PM
            I have a spreadsheet I'm trying to use, as of today, that I really need this fix for. Is there anyway I can upgrade just the Office Connector without having to upgrade Confluence?

            Same goes for me as well; can't we install the new version of the Office Connector manually?

            Edwin Stol added a comment - Ryan added a comment - 23/Mar/12 12:07 PM I have a spreadsheet I'm trying to use, as of today, that I really need this fix for. Is there anyway I can upgrade just the Office Connector without having to upgrade Confluence? Same goes for me as well; can't we install the new version of the Office Connector manually?

            Anna Gunich added a comment -

            Hi Ryan,

            We have re-installed Office Connector plugin 1.18 and the problem is indeed solved now for Confluence 3.5.16.

            Thanks,
            Anna.

            Anna Gunich added a comment - Hi Ryan, We have re-installed Office Connector plugin 1.18 and the problem is indeed solved now for Confluence 3.5.16. Thanks, Anna.

            RyanA added a comment -

            Hi everyone, this issue has been fixed since 3.5.15. If you are running 3.5.x, you can upgrade to the latest 3.5.x release to fix this. For 4.0 and later, you should upgrade to 4.2.

            If you are seeing this on 3.5.16 you may have manually installed a non-bundled version of the OfficeConnector, Please contact support.

            Please note that this issue is not known to crash Confluence, it just pollutes the log files with a ton of these messages. If you're experiencing crashes, contact support.

            RyanA added a comment - Hi everyone, this issue has been fixed since 3.5.15. If you are running 3.5.x, you can upgrade to the latest 3.5.x release to fix this. For 4.0 and later, you should upgrade to 4.2. If you are seeing this on 3.5.16 you may have manually installed a non-bundled version of the OfficeConnector, Please contact support. Please note that this issue is not known to crash Confluence, it just pollutes the log files with a ton of these messages. If you're experiencing crashes, contact support.

            Madhusudhan Matrubai added a comment -

            Hi Joey,

            We are running a similar issue and is further aggravating with frequent crash of Confluence on 3.5.13. Can we get an Urgent fix for the same.

            regards,
            Madhusudhan

            Madhusudhan Matrubai added a comment - Hi Joey, We are running a similar issue and is further aggravating with frequent crash of Confluence on 3.5.13. Can we get an Urgent fix for the same. regards, Madhusudhan

            Anna Gunich added a comment -

            Hi Joey,

            Is an upgrade to 4.2 is the only solution to fix this issue? We are using Confluence 3.5.16.
            Patch would be highly appreciated.

            Thanks,
            Anna Afanasueva,
            eVelopers Corp

            Anna Gunich added a comment - Hi Joey, Is an upgrade to 4.2 is the only solution to fix this issue? We are using Confluence 3.5.16. Patch would be highly appreciated. Thanks, Anna Afanasueva, eVelopers Corp

            Ole Kristensen added a comment -

            We experience our confluence instance to crash wih the above errors in log file, so I will repeat @Christpher Mercers question: Is there a hot fix for this to get fill in the gap between now and an upgrade? (We're running Confluence 3.4.8)

            Ole Kristensen added a comment - We experience our confluence instance to crash wih the above errors in log file, so I will repeat @Christpher Mercers question: Is there a hot fix for this to get fill in the gap between now and an upgrade? (We're running Confluence 3.4.8)

            Christopher Mercer added a comment -

            Is there a hot fix for this to get fill in the gap between now and an upgrade?

            Christopher Mercer added a comment - Is there a hot fix for this to get fill in the gap between now and an upgrade?

            Ryan added a comment -

            I have a spreadsheet I'm trying to use, as of today, that I really need this fix for. Is there anyway I can upgrade just the Office Connector without having to upgrade Confluence?

            Ryan added a comment - I have a spreadsheet I'm trying to use, as of today, that I really need this fix for. Is there anyway I can upgrade just the Office Connector without having to upgrade Confluence?

            JoeyA added a comment -

            tried the problem files plus a few others. Logs are clean

            JoeyA added a comment - tried the problem files plus a few others. Logs are clean

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

                Created:
                Updated:
                Resolved: