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

Invalid formula syntax while loading a spreadsheet with viewfile macro

XMLWordPrintable

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

      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.

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

                Created:
                Updated:
                Resolved: