diff options
author | Nick Burch <nick@apache.org> | 2014-07-19 19:11:54 +0000 |
---|---|---|
committer | Nick Burch <nick@apache.org> | 2014-07-19 19:11:54 +0000 |
commit | 76c8077a40c74b78ee788b73b21b00736037df9f (patch) | |
tree | 65fa2291c0e10670341e920f96769b23da4e61c9 /src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java | |
parent | 0bfa4f675d87381bd5521c85a119769d9c8ed786 (diff) | |
download | poi-76c8077a40c74b78ee788b73b21b00736037df9f.tar.gz poi-76c8077a40c74b78ee788b73b21b00736037df9f.zip |
Fix inconsistent indents
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611947 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java')
-rw-r--r-- | src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java | 244 |
1 files changed, 122 insertions, 122 deletions
diff --git a/src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java b/src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java index e7869755a9..1b02cf2416 100644 --- a/src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java +++ b/src/testcases/org/apache/poi/hssf/eventusermodel/TestEventWorkbookBuilder.java @@ -39,130 +39,130 @@ import org.apache.poi.ss.formula.ptg.Ref3DPtg; * Tests for {@link EventWorkbookBuilder} */ public final class TestEventWorkbookBuilder extends TestCase { - private MockHSSFListener mockListen; - private SheetRecordCollectingListener listener; - - @Override - public void setUp() { - HSSFRequest req = new HSSFRequest(); - mockListen = new MockHSSFListener(); - listener = new SheetRecordCollectingListener(mockListen); - req.addListenerForAllRecords(listener); - - HSSFEventFactory factory = new HSSFEventFactory(); - try { - InputStream is = HSSFTestDataSamples.openSampleFileStream("3dFormulas.xls"); - POIFSFileSystem fs = new POIFSFileSystem(is); - factory.processWorkbookEvents(req, fs); - } catch (IOException e) { - throw new RuntimeException(e); - } - } - - public void testBasics() { - assertNotNull(listener.getSSTRecord()); - assertNotNull(listener.getBoundSheetRecords()); - assertNotNull(listener.getExternSheetRecords()); - } - - public void testGetStubWorkbooks() { - assertNotNull(listener.getStubWorkbook()); - assertNotNull(listener.getStubHSSFWorkbook()); - } - - public void testContents() { - assertEquals(2, listener.getSSTRecord().getNumStrings()); - assertEquals(3, listener.getBoundSheetRecords().length); - assertEquals(1, listener.getExternSheetRecords().length); - - assertEquals(3, listener.getStubWorkbook().getNumSheets()); - - InternalWorkbook ref = listener.getStubWorkbook(); - assertEquals("Sh3", ref.findSheetNameFromExternSheet(0)); - assertEquals("Sheet1", ref.findSheetNameFromExternSheet(1)); - assertEquals("S2", ref.findSheetNameFromExternSheet(2)); - } - - public void testFormulas() { - - FormulaRecord[] fRecs = mockListen.getFormulaRecords(); - - // Check our formula records - assertEquals(6, fRecs.length); - - InternalWorkbook stubWB = listener.getStubWorkbook(); - assertNotNull(stubWB); - HSSFWorkbook stubHSSF = listener.getStubHSSFWorkbook(); - assertNotNull(stubHSSF); - - // Check these stubs have the right stuff on them - assertEquals("Sheet1", stubWB.getSheetName(0)); + private MockHSSFListener mockListen; + private SheetRecordCollectingListener listener; + + @Override + public void setUp() { + HSSFRequest req = new HSSFRequest(); + mockListen = new MockHSSFListener(); + listener = new SheetRecordCollectingListener(mockListen); + req.addListenerForAllRecords(listener); + + HSSFEventFactory factory = new HSSFEventFactory(); + try { + InputStream is = HSSFTestDataSamples.openSampleFileStream("3dFormulas.xls"); + POIFSFileSystem fs = new POIFSFileSystem(is); + factory.processWorkbookEvents(req, fs); + } catch (IOException e) { + throw new RuntimeException(e); + } + } + + public void testBasics() { + assertNotNull(listener.getSSTRecord()); + assertNotNull(listener.getBoundSheetRecords()); + assertNotNull(listener.getExternSheetRecords()); + } + + public void testGetStubWorkbooks() { + assertNotNull(listener.getStubWorkbook()); + assertNotNull(listener.getStubHSSFWorkbook()); + } + + public void testContents() { + assertEquals(2, listener.getSSTRecord().getNumStrings()); + assertEquals(3, listener.getBoundSheetRecords().length); + assertEquals(1, listener.getExternSheetRecords().length); + + assertEquals(3, listener.getStubWorkbook().getNumSheets()); + + InternalWorkbook ref = listener.getStubWorkbook(); + assertEquals("Sh3", ref.findSheetNameFromExternSheet(0)); + assertEquals("Sheet1", ref.findSheetNameFromExternSheet(1)); + assertEquals("S2", ref.findSheetNameFromExternSheet(2)); + } + + public void testFormulas() { + + FormulaRecord[] fRecs = mockListen.getFormulaRecords(); + + // Check our formula records + assertEquals(6, fRecs.length); + + InternalWorkbook stubWB = listener.getStubWorkbook(); + assertNotNull(stubWB); + HSSFWorkbook stubHSSF = listener.getStubHSSFWorkbook(); + assertNotNull(stubHSSF); + + // Check these stubs have the right stuff on them + assertEquals("Sheet1", stubWB.getSheetName(0)); assertEquals("Sheet1", stubHSSF.getSheetName(0)); - assertEquals("S2", stubWB.getSheetName(1)); + assertEquals("S2", stubWB.getSheetName(1)); assertEquals("S2", stubHSSF.getSheetName(1)); - assertEquals("Sh3", stubWB.getSheetName(2)); + assertEquals("Sh3", stubWB.getSheetName(2)); assertEquals("Sh3", stubHSSF.getSheetName(2)); - // Check we can get the formula without breaking - for(int i=0; i<fRecs.length; i++) { - HSSFFormulaParser.toFormulaString(stubHSSF, fRecs[i].getParsedExpression()); - } - - // Peer into just one formula, and check that - // all the ptgs give back the right things - Ptg[] ptgs = fRecs[0].getParsedExpression(); - assertEquals(1, ptgs.length); - assertTrue(ptgs[0] instanceof Ref3DPtg); - - Ref3DPtg ptg = (Ref3DPtg)ptgs[0]; - HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(stubHSSF); - assertEquals("Sheet1!A1", ptg.toFormulaString(book)); - - - // Now check we get the right formula back for - // a few sample ones - FormulaRecord fr; - - // Sheet 1 A2 is on same sheet - fr = fRecs[0]; - assertEquals(1, fr.getRow()); - assertEquals(0, fr.getColumn()); - assertEquals("Sheet1!A1", HSSFFormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression())); - - // Sheet 1 A5 is to another sheet - fr = fRecs[3]; - assertEquals(4, fr.getRow()); - assertEquals(0, fr.getColumn()); - assertEquals("'S2'!A1", HSSFFormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression())); - - // Sheet 1 A7 is to another sheet, range - fr = fRecs[5]; - assertEquals(6, fr.getRow()); - assertEquals(0, fr.getColumn()); - assertEquals("SUM(Sh3!A1:A4)", HSSFFormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression())); - - - // Now, load via Usermodel and re-check - HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("3dFormulas.xls"); - assertEquals("Sheet1!A1", wb.getSheetAt(0).getRow(1).getCell(0).getCellFormula()); - assertEquals("SUM(Sh3!A1:A4)", wb.getSheetAt(0).getRow(6).getCell(0).getCellFormula()); - } - - private static final class MockHSSFListener implements HSSFListener { - public MockHSSFListener() {} - private final List<Record> _records = new ArrayList<Record>(); - private final List<Record> _frecs = new ArrayList<Record>(); - - public void processRecord(Record record) { - _records.add(record); - if(record instanceof FormulaRecord) { - _frecs.add(record); - } - } - public FormulaRecord[] getFormulaRecords() { - FormulaRecord[] result = new FormulaRecord[_frecs.size()]; - _frecs.toArray(result); - return result; - } - } + // Check we can get the formula without breaking + for(int i=0; i<fRecs.length; i++) { + HSSFFormulaParser.toFormulaString(stubHSSF, fRecs[i].getParsedExpression()); + } + + // Peer into just one formula, and check that + // all the ptgs give back the right things + Ptg[] ptgs = fRecs[0].getParsedExpression(); + assertEquals(1, ptgs.length); + assertTrue(ptgs[0] instanceof Ref3DPtg); + + Ref3DPtg ptg = (Ref3DPtg)ptgs[0]; + HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(stubHSSF); + assertEquals("Sheet1!A1", ptg.toFormulaString(book)); + + + // Now check we get the right formula back for + // a few sample ones + FormulaRecord fr; + + // Sheet 1 A2 is on same sheet + fr = fRecs[0]; + assertEquals(1, fr.getRow()); + assertEquals(0, fr.getColumn()); + assertEquals("Sheet1!A1", HSSFFormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression())); + + // Sheet 1 A5 is to another sheet + fr = fRecs[3]; + assertEquals(4, fr.getRow()); + assertEquals(0, fr.getColumn()); + assertEquals("'S2'!A1", HSSFFormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression())); + + // Sheet 1 A7 is to another sheet, range + fr = fRecs[5]; + assertEquals(6, fr.getRow()); + assertEquals(0, fr.getColumn()); + assertEquals("SUM(Sh3!A1:A4)", HSSFFormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression())); + + + // Now, load via Usermodel and re-check + HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("3dFormulas.xls"); + assertEquals("Sheet1!A1", wb.getSheetAt(0).getRow(1).getCell(0).getCellFormula()); + assertEquals("SUM(Sh3!A1:A4)", wb.getSheetAt(0).getRow(6).getCell(0).getCellFormula()); + } + + private static final class MockHSSFListener implements HSSFListener { + public MockHSSFListener() {} + private final List<Record> _records = new ArrayList<Record>(); + private final List<Record> _frecs = new ArrayList<Record>(); + + public void processRecord(Record record) { + _records.add(record); + if(record instanceof FormulaRecord) { + _frecs.add(record); + } + } + public FormulaRecord[] getFormulaRecords() { + FormulaRecord[] result = new FormulaRecord[_frecs.size()]; + _frecs.toArray(result); + return result; + } + } } |