Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-23140

Invalid formula syntax while loading a spreadsheet with viewfile macro

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • High
    • Resolution: Duplicate
    • 3.3.3
    • 4.1
    • None
    • operating.system: Linux
      os.architecture: 32/64bits
      application.server: Apache Tomcat/6.0.26
      java.version: 1.6.0_26

    Description

      Problem

      When loading a spreadsheet with viewfile macro that refers to external files, a number of this message is shown in the catalina.out file:

      Cell:row:2 col:3 Formula:[/Documents%20and%20Settings/user/My%20Documents/file.xlsx]Sheet1!$B$10
      com.jxcell.CellException: Invalid formula syntax.
      	at I.V.getSheetNumber(EYFN)
      	at I.V.getCol1(EYFN)
      	at I.V.I(EYFN)
      	at I.C.I(EYFN)
      	at com.jxcell.TD.eWarning(EYFN)
      	at com.jxcell.TD.eTime(EYFN)
      	at com.jxcell.TD.eDecimal(EYFN)
      	at com.jxcell.TD.eDate(EYFN)
      	at com.jxcell.TD.I(EYFN)
      	at com.jxcell.View.readXLSX(EYFN)
      

      It might cause instance crash depending on the load accessing this page.

      Example of reference into the spreadsheet file:

      ='file:///Documents and Settings/user/My Documents/file.xlsxD8x'#$Sheet1.$B$10
      

      Fix

      There is none yet.

      Workaround

      There is none yet.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tcomasseto Tiago Comasseto
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: