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

Details

    • Bug
    • Resolution: Duplicate
    • 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

    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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-20672 Using viewfile macro with large Excel spreadsheet causes OutOfMemoryError

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-39085 Confluence OOMs when an invalid formula is entered into the spreadsheet macro

          • Low - Low priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-23005 Office Connector umbrella issues that affect stability

          • High - High priority issues
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: