Confluence
  1. Confluence
  2. CONF-20631

Viewfile throws ConversionException when field has currency format

    Details

    • Last commented by user?:
      true
    • Internal Complexity:
      4
    • Internal Value:
      4

      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)
      ...
      
      1. CA Project Control List_2012(Formatupdated)1.xlsx
        13 kB
        LEI MENG SAN
      2. currency.xlsx
        8 kB
        Azwandi Mohd Aris [Atlassian]
      3. empty.xlsx
        8 kB
        Simon Keary

        Issue Links

          Activity

          Azwandi Mohd Aris [Atlassian] created issue -
          Hide
          Azwandi Mohd Aris [Atlassian] added a comment -

          Attached currency.xlsx is a sample file. A workaround is to remove the currency formatting or use standard $ currency, at least.

          Show
          Azwandi Mohd Aris [Atlassian] added a comment - Attached currency.xlsx is a sample file. A workaround is to remove the currency formatting or use standard $ currency, at least.
          Azwandi Mohd Aris [Atlassian] made changes -
          Field Original Value New Value
          Attachment currency.xlsx [ 40357 ]
          Joseph Clark [Atlassian] made changes -
          Labels bf_triage
          Internal Complexity 4
          Internal Value 4
          Hide
          Ian Lovegrove added a comment -

          Searching for issues before I submit a JIRA...

          We see the same error on Confluence 3.3.1 when xls file is password protected.

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

          Same page/content works fine on Confluence 2.10.3 system. (No errors; password protected excel file contents not rendered, but edit button opens file as expected.)

          Show
          Ian Lovegrove added a comment - Searching for issues before I submit a JIRA... We see the same error on Confluence 3.3.1 when xls file is password protected. viewfile: com.benryan.conversion.ConvertsionException: error converting spreadsheet Same page/content works fine on Confluence 2.10.3 system. (No errors; password protected excel file contents not rendered, but edit button opens file as expected.)
          Hide
          Christian Areas added a comment -

          We work with customers who use other currencies, and feel like this is a major limitation. Please address this promptly. Thank you.

          Show
          Christian Areas added a comment - We work with customers who use other currencies, and feel like this is a major limitation. Please address this promptly. Thank you.
          Roy Krishna [Atlassian] made changes -
          Workflow Quality Review Flow [ 216550 ] Conf Bug Quality Review WorkFlow [ 247434 ]
          Hide
          Ingo Hardieck added a comment -

          3 days ago we upgraded to Confluence 3.4.1 (from 2.10.2) and since then our users are experiencing the same error with their spreadsheets that display pricing in EUR (€) currency.

          Please fix ASAP so that we can continue to use the Office Integration without changing all the affected spreadsheets.

          Thank you!

          Show
          Ingo Hardieck added a comment - 3 days ago we upgraded to Confluence 3.4.1 (from 2.10.2) and since then our users are experiencing the same error with their spreadsheets that display pricing in EUR (€) currency. Please fix ASAP so that we can continue to use the Office Integration without changing all the affected spreadsheets. Thank you!
          Partha Kamal [Atlassian] made changes -
          Labels bf_triage bf_triage bugfix_support_backlog
          Hide
          Olivier Dupuy added a comment -

          Same in 3.4.1 with a file with nothing special inside.
          Using Office 2003/11.
          No special setting in my file or in Excel.
          My regional XP SP3 settings are English Canada.
          Except the exceptions in the log, I can view properly my file.

          Show
          Olivier Dupuy added a comment - Same in 3.4.1 with a file with nothing special inside. Using Office 2003/11. No special setting in my file or in Excel. My regional XP SP3 settings are English Canada. Except the exceptions in the log, I can view properly my file.
          Hide
          Simon Keary added a comment -

          Empty spreadsheet that causes the exception described.

          Show
          Simon Keary added a comment - Empty spreadsheet that causes the exception described.
          Simon Keary made changes -
          Attachment empty.xlsx [ 42369 ]
          Simon Keary made changes -
          Attachment empty.xlsx [ 42370 ]
          Simon Keary made changes -
          Attachment empty.xlsx [ 42369 ]
          Hide
          Simon Keary added a comment -

          Like Olivier I've also see the error reported for Excel files without anything special inside in Confluence 3.4.2 which I'm currently testing out. In fact, I've found that if you create just a blank Excel file, attach it to a page and then try to use the viewfile macro to display it you get the error:

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

          The same log as mentioned above also gets reported in the console but a slightly different exception trace gets reported in atlassian-confluence.log (com.jxcell.CellException: Invalid cell reference).

          In most other cases the spreadsheets do render with the macro but the console consistently reports the "no ComponentUI class" error for all spreadsheets so it's looks like there are a number of issues with the jxcell library going on.

          It would be really great to get the viewxls macro working robustly as it's quite important to us and I'm sure others. Due to CONF-18892 we've had to completely disable it in 3.2.1 and I was hoping that the major issues would now be resolved in 3.4. It's a bit frustrating that to find really obvious issues such as failing to render even empty spreadsheets as you have to wonder about the QA that is being applied to the jxcell library...

          Show
          Simon Keary added a comment - Like Olivier I've also see the error reported for Excel files without anything special inside in Confluence 3.4.2 which I'm currently testing out. In fact, I've found that if you create just a blank Excel file, attach it to a page and then try to use the viewfile macro to display it you get the error: viewxls: com.benryan.conversion.ConvertsionException: error converting spreadsheet The same log as mentioned above also gets reported in the console but a slightly different exception trace gets reported in atlassian-confluence.log (com.jxcell.CellException: Invalid cell reference). In most other cases the spreadsheets do render with the macro but the console consistently reports the "no ComponentUI class" error for all spreadsheets so it's looks like there are a number of issues with the jxcell library going on. It would be really great to get the viewxls macro working robustly as it's quite important to us and I'm sure others. Due to CONF-18892 we've had to completely disable it in 3.2.1 and I was hoping that the major issues would now be resolved in 3.4. It's a bit frustrating that to find really obvious issues such as failing to render even empty spreadsheets as you have to wonder about the QA that is being applied to the jxcell library...
          Hide
          Arnaud Heritier added a comment -

          Same thing for us

          Show
          Arnaud Heritier added a comment - Same thing for us
          Matthew Erickson [Atlassian] made changes -
          Assignee Matthew Erickson [Atlassian] [ merickson ]
          Vincent Choy [Atlassian] made changes -
          Link This issue duplicates CONF-21750 [ CONF-21750 ]
          Hide
          Michael Seager [Atlassian] added a comment -

          Recent tests on Conf 3.4.8/Office Connector 1.15 are failing with any currency formatting. Updated bug report accordingly.

          Show
          Michael Seager [Atlassian] added a comment - Recent tests on Conf 3.4.8/Office Connector 1.15 are failing with any currency formatting. Updated bug report accordingly.
          Michael Seager [Atlassian] made changes -
          Summary Viewfile throws ConvertsionException when field has foreign currency format Viewfile throws ConvertsionException when field has currency format
          Description If Excel file has a field with foreign currency format, the conversion fails with:

          {noformat}
          viewxls: com.benryan.conversion.ConvertsionException: error converting spreadsheet
          {noformat}

          Console throws:

          {noformat}
          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)
          ...
          {noformat}

          atlassian-confluence.log throws:

          {noformat}
          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)
          ...
          {noformat}
          If Excel file has a field with currency format, the conversion fails with:

          {noformat}
          viewxls: com.benryan.conversion.ConvertsionException: error converting spreadsheet
          {noformat}

          Console throws:

          {noformat}
          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)
          ...
          {noformat}

          atlassian-confluence.log throws:

          {noformat}
          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)
          ...
          {noformat}
          Affects Version/s 3.4.8 [ 15880 ]
          Hide
          Clay Monkus added a comment -

          We are experiencing the same problem once we upgraded from 3.2 to 3.4.7. on any spreadsheets with any currency formatting.

          Show
          Clay Monkus added a comment - We are experiencing the same problem once we upgraded from 3.2 to 3.4.7. on any spreadsheets with any currency formatting.
          Matthew Erickson [Atlassian] made changes -
          Assignee Matthew Erickson [Atlassian] [ merickson ]
          Hide
          Timo Burgert added a comment -

          we are experiencing the same using Version 3.3
          When do you think that we can get a fix for this issue?

          Show
          Timo Burgert added a comment - we are experiencing the same using Version 3.3 When do you think that we can get a fix for this issue?
          Hide
          Nic Brough added a comment -

          Same here, Confluence 3.4.9

          Show
          Nic Brough added a comment - Same here, Confluence 3.4.9
          Hide
          Michele Scillone added a comment -

          Same problem here with Confluence 3.4.5, but with NO EVIDENCE in the atlassian-confluence.log.
          Then, we cannot identify the "wrong" file.

          Some prospect to solve the issue?

          Show
          Michele Scillone added a comment - Same problem here with Confluence 3.4.5, but with NO EVIDENCE in the atlassian-confluence.log. Then, we cannot identify the "wrong" file. Some prospect to solve the issue?
          Hide
          Benjamin Peter added a comment -

          Experiencing the same over here. Would be so happy if it'd be fixed.

          Show
          Benjamin Peter added a comment - Experiencing the same over here. Would be so happy if it'd be fixed.
          Hide
          Martin Seibert (//SEIBERT/MEDIA, Germany) added a comment -

          You might want to erase the obsolete 't' in the issue description.

          Show
          Martin Seibert (//SEIBERT/MEDIA, Germany) added a comment - You might want to erase the obsolete 't' in the issue description.
          Hide
          Klaus Feldmann added a comment -

          I just run into same issue and after I did import it to Mac program Numbers and exported it again to xls it did work. strange thing...

          Show
          Klaus Feldmann added a comment - I just run into same issue and after I did import it to Mac program Numbers and exported it again to xls it did work. strange thing...
          Hide
          Cody Watkins added a comment -

          This is happening to us as well with Excel files on Confluence 3.5.2

          Show
          Cody Watkins added a comment - This is happening to us as well with Excel files on Confluence 3.5.2
          Michael Seager [Atlassian] made changes -
          Summary Viewfile throws ConvertsionException when field has currency format Viewfile throws ConversionException when field has currency format
          Hide
          Maxfield Burdge added a comment -

          Same issue here Confluence 3.4.9

          Show
          Maxfield Burdge added a comment - Same issue here Confluence 3.4.9
          Matt Ryall [Atlassian] made changes -
          Link This issue is duplicated by CONF-22720 [ CONF-22720 ]
          Hide
          Stephen Spencer added a comment -

          Same issue with 3.5.3

          Show
          Stephen Spencer added a comment - Same issue with 3.5.3
          Matt Ryall [Atlassian] made changes -
          Workflow Conf Bug Quality Review WorkFlow [ 247434 ] Confluence Bug Workflow [ 337218 ]
          Hide
          Ellen Feaheny [AppFusions] added a comment -

          If you are really wanting to power-use Excel with Confluence - you need a better solution than loose Excel files... period. Excel is, well, just excel.

          Get your business intelligence in order with a shareable/distributable model.

          Contact AppFusions about Extentech web-based java spreadsheets in Confluence.

          (Basically, the idea behind Google Spreadsheets, but a) works b) you control the host/backend/power of logic and BI)

          SOOO logical! Sooo helpful.
          Sooo much time saved with better, more visible, and shared spreadsheeting.

          Show
          Ellen Feaheny [AppFusions] added a comment - If you are really wanting to power-use Excel with Confluence - you need a better solution than loose Excel files... period. Excel is, well, just excel. Get your business intelligence in order with a shareable/distributable model. Contact AppFusions about Extentech web-based java spreadsheets in Confluence. (Basically, the idea behind Google Spreadsheets, but a) works b) you control the host/backend/power of logic and BI) SOOO logical! Sooo helpful. Sooo much time saved with better, more visible, and shared spreadsheeting.
          Hide
          Stephen Spencer added a comment - - edited

          LOL! I would like using an Atlassian provided plugin to correctly handle the files its supposed to handle without crashing--I don't have ED!

          Show
          Stephen Spencer added a comment - - edited LOL! I would like using an Atlassian provided plugin to correctly handle the files its supposed to handle without crashing--I don't have ED!
          Ryan Ackley [Atlassian] made changes -
          Link This issue is duplicated by CONF-20392 [ CONF-20392 ]
          Hide
          Dana Scoggins added a comment -

          Also seeing this on 3.5.6

          Show
          Dana Scoggins added a comment - Also seeing this on 3.5.6
          Hide
          Michael O'Neill added a comment - - edited

          Also seeing this in 3.5.9, but I don't believe it has anything to do with currency format (for me...since I'm not using it)

          Edit
          After playing around, I can get it to work if I don't specify a worksheet. Of course, that's not a fix, as not being able to specify a worksheet means I can't use the macro for what I need to use it for.

          Works: {viewxls:name=Portal Page Field Index.xls}
          Does Not Work: {viewxls:name=Portal Page Field Index.xls|sheet=Profile Page}

          Show
          Michael O'Neill added a comment - - edited Also seeing this in 3.5.9, but I don't believe it has anything to do with currency format (for me...since I'm not using it) Edit After playing around, I can get it to work if I don't specify a worksheet. Of course, that's not a fix, as not being able to specify a worksheet means I can't use the macro for what I need to use it for. Works: { viewxls:name=Portal Page Field Index.xls } Does Not Work: { viewxls:name=Portal Page Field Index.xls|sheet=Profile Page }
          Hide
          Hans-Peter Geier added a comment - - edited

          Also seeing this in 3.5.9
          The workaround to use $ instead of other currencies (as suggested in the first comment) is not feasible

          Additional observation: while the error message (UIDefaults.getUI() failed: no ComponentUI class for: com.jxcell.HB etc etc) is exactly the same as reported in this Jira ticket, I do not see any traces to a Currency Conversion exception as mentioned above, in none of the log files.

          One more observation: It appears to me that the occurance of this error causes an abort or hangup of the Tomcat server. All user sessions hang until some timeout occurs (in the browser); THEN (but not earlier) the page can be refreshed and the page content is OK.

          And: at the bottom of the java error stack, there is this line being written out:
          continue record data!!!

          Can you (Atlassian) confirm that this is all the same root cause, or are we talking about different errors?
          Do other people also see the observations mentioned above? (no conversion exception, but hang up and this "continue record data!!!" line?

          What is the plan to fix this issue?

          Show
          Hans-Peter Geier added a comment - - edited Also seeing this in 3.5.9 The workaround to use $ instead of other currencies (as suggested in the first comment) is not feasible Additional observation: while the error message (UIDefaults.getUI() failed: no ComponentUI class for: com.jxcell.HB etc etc) is exactly the same as reported in this Jira ticket, I do not see any traces to a Currency Conversion exception as mentioned above, in none of the log files. One more observation: It appears to me that the occurance of this error causes an abort or hangup of the Tomcat server. All user sessions hang until some timeout occurs (in the browser); THEN (but not earlier) the page can be refreshed and the page content is OK. And: at the bottom of the java error stack, there is this line being written out: continue record data!!! Can you (Atlassian) confirm that this is all the same root cause, or are we talking about different errors? Do other people also see the observations mentioned above? (no conversion exception, but hang up and this "continue record data!!!" line? What is the plan to fix this issue?
          Hide
          Michael Jositz added a comment -

          We have same issue in Confluence 3.4.5. Any idea when this will be solved?

          Show
          Michael Jositz added a comment - We have same issue in Confluence 3.4.5. Any idea when this will be solved?
          Hide
          Bill Coate added a comment -

          Any updates on this bug? Bugs that require every single user to the system to be informed and act accordingly for the workarounds to work frequently don't do so well for the workarounds (new user doesn't realize issue, old user didn't pay attention at the time because they didn't do anything similar, someone forgets months after hearing once, etc).

          Show
          Bill Coate added a comment - Any updates on this bug? Bugs that require every single user to the system to be informed and act accordingly for the workarounds to work frequently don't do so well for the workarounds (new user doesn't realize issue, old user didn't pay attention at the time because they didn't do anything similar, someone forgets months after hearing once, etc).
          Hide
          Shahriar Shafiullah added a comment -

          Issue exists on confluence-3.5.9 as well:

          UIDefaults.getUI() failed: no ComponentUI class for: com.jxcell.HB[,0,0,0x0,invalid,alignmentX=0.0,alignmentY=0.0,border=,flags=4194304,maximumSize=,minimumSize=,prefer
          redSize=,blockIncrement=10,orientation=VERTICAL,unitIncrement=1]
          java.lang.Error

          Show
          Shahriar Shafiullah added a comment - Issue exists on confluence-3.5.9 as well: UIDefaults.getUI() failed: no ComponentUI class for: com.jxcell.HB[,0,0,0x0,invalid,alignmentX=0.0,alignmentY=0.0,border=,flags=4194304,maximumSize=,minimumSize=,prefer redSize=,blockIncrement=10,orientation=VERTICAL,unitIncrement=1] java.lang.Error
          Hide
          Akira Higuchi added a comment -

          Azwandi.

          I got same error on Confluence 3.5.9, and 4.0. Could you add these informations?

          Thank you.

          Show
          Akira Higuchi added a comment - Azwandi. I got same error on Confluence 3.5.9, and 4.0. Could you add these informations? Thank you.
          Michael Seager [Atlassian] made changes -
          Rank Ranked higher
          Alexandru Lazar [Atlassian] made changes -
          Remote Link This issue links to "Wiki Page (Extranet)" [ 10859 ]
          Hide
          Husein Alatas [Atlassian] added a comment -

          The following can be suppressed from Tomcat logs/console:

          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
          

          By enabling swallowOutput in Confluence's Tomcat (eg. server.xml) - http://tomcat.apache.org/tomcat-6.0-doc/config/context.html. For example:

          server.xml
                          <Context path="" docBase="../confluence" debug="0" reloadable="false" useHttpOnly="true" swallowOutput="true">
                              <!-- Logger is deprecated in Tomcat 5.5. Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties -->
                              <Manager pathname="" />
                          </Context>
          

          reference: Found this suggestion in CSP-66867 (not publicly accessible).

          Show
          Husein Alatas [Atlassian] added a comment - The following can be suppressed from Tomcat logs/console: 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 By enabling swallowOutput in Confluence's Tomcat (eg. server.xml) - http://tomcat.apache.org/tomcat-6.0-doc/config/context.html . For example: server.xml <Context path= "" docBase=" ../confluence " debug=" 0 " reloadable=" false " useHttpOnly=" true " swallowOutput=" true "> <!-- Logger is deprecated in Tomcat 5.5. Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties --> <Manager pathname="" /> </Context> reference: Found this suggestion in CSP-66867 (not publicly accessible).
          Ryan Ackley [Atlassian] made changes -
          Link This issue is incorporated by CONF-24692 [ CONF-24692 ]
          Michael Seager [Atlassian] made changes -
          Labels bf_triage bugfix_support_backlog bf_triage
          Michael Seager [Atlassian] made changes -
          Labels bf_triage bf_triage conf_support_backlog_kl
          Ryan Ackley [Atlassian] made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Ryan Ackley [ rackley ]
          Fix Version/s 4.2 [ 22895 ]
          Resolution Fixed [ 1 ]
          Ryan Ackley [Atlassian] made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Open [ 1 ]
          Ryan Ackley [Atlassian] made changes -
          Status Open [ 1 ] Technical Review [ 10028 ]
          Ryan Ackley [Atlassian] made changes -
          Status Technical Review [ 10028 ] Quality Review [ 10029 ]
          Hide
          LEI MENG SAN added a comment - - edited

          Hi Support,

          Currently I have encountered a similar problem. However, in my case, although I have clear all the Currency format(I think I have). The following error still exist:

          Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: error converting spreadsheet

          Please try the attached document "CA Project Control List_2012(Formatupdated)1.xlsx".

          Thanks!!

          Show
          LEI MENG SAN added a comment - - edited Hi Support, Currently I have encountered a similar problem. However, in my case, although I have clear all the Currency format(I think I have). The following error still exist: Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: error converting spreadsheet Please try the attached document "CA Project Control List_2012(Formatupdated)1.xlsx". Thanks!!
          LEI MENG SAN made changes -
          Michael Seager [Atlassian] made changes -
          Labels bf_triage conf_support_backlog_kl bf_triage bugfix_support_backlog conf_support_backlog_kl
          Hide
          Joey Corea [Atlassian] added a comment -

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

          Show
          Joey Corea [Atlassian] added a comment - tried the problem files plus a few others. Logs are clean
          Joey Corea [Atlassian] made changes -
          Status Quality Review [ 10029 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          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?

          Show
          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?
          Hide
          Christopher Mercer added a comment -

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

          Show
          Christopher Mercer added a comment - Is there a hot fix for this to get fill in the gap between now and an upgrade?
          Hide
          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)

          Show
          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)
          Hide
          Anna Afanasieva 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

          Show
          Anna Afanasieva 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
          Hide
          Madhusudhan 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

          Show
          Madhusudhan 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
          Hide
          Ryan Ackley [Atlassian] 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.

          Show
          Ryan Ackley [Atlassian] 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.
          Ryan Ackley [Atlassian] made changes -
          Fix Version/s 3.5.16 [ 26239 ]
          Hide
          Anna Afanasieva 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.

          Show
          Anna Afanasieva 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.
          Hide
          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?

          Show
          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?
          Anatoli Kazatchkov [Administrative Account] made changes -
          Workflow Confluence Bug Workflow [ 337218 ] New Confluence Default Workflow [ 467337 ]
          Steve Haffenden [Atlassian Bugmaster] made changes -
          Link This issue is related to CONF-32069 [ CONF-32069 ]
          Hide
          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.

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