Java test case

bug60197.java (text/x-java), 1.75 KB, created by Javen O'Neal on 2016-10-08 23:56:28 UTC

(hide)

Description: Java test case

Filename:

MIME Type:

Creator: Javen O'Neal

Created: 2016-10-08 23:56:28 UTC

Size: 1.75 KB

patch

obsolete

>import java.io.ByteArrayOutputStream; >import java.io.File; >import java.io.FileOutputStream; >import java.io.IOException; >import java.util.logging.Logger; > >import org.apache.poi.EncryptedDocumentException; >import org.apache.poi.openxml4j.exceptions.InvalidFormatException; >import org.apache.poi.ss.usermodel.Name; >import org.apache.poi.ss.usermodel.Sheet; >import org.apache.poi.ss.usermodel.Workbook; >import org.apache.poi.ss.util.CellRangeAddress; >import org.apache.poi.xssf.usermodel.XSSFWorkbook; > >/** > * > */ > >/** > * @author 20005688 > * > */ >public class Main { > > private static File f = new File("D:\\testPOI.xlsx"); > > public static void main(String[] args) throws EncryptedDocumentException, InvalidFormatException, IOException { > try (FileOutputStream fout = new FileOutputStream(f); > ByteArrayOutputStream outputStream = new ByteArrayOutputStream(); > Workbook wb = new XSSFWorkbook()) { > > // Build the Excel File > wb.createSheet("Sheet1"); > wb.createSheet("Sheet2"); > Sheet sheet = wb.createSheet("Sheet3"); > > //create a dumb named range > Name namedCel = sheet.getWorkbook().createName(); > namedCel.setSheetIndex(sheet.getWorkbook().getSheetIndex(sheet)); > namedCel.setNameName("sheet3_1"); > namedCel.setRefersToFormula(new CellRangeAddress(0, 5, 0, 5).formatAsString(sheet.getSheetName(), true)); > sheet.getDataValidationHelper().createFormulaListConstraint(namedCel.getNameName()); > > > System.out.println("Name scope is : " + namedCel.getSheetName()); > > //move the sheet to provoke the anomaly > wb.setSheetOrder("Sheet3", 1); > > System.out.println("Name scope is : " + namedCel.getSheetName()); > > // closing stuff > wb.write(outputStream); > outputStream.writeTo(fout); > } > } >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]