20 |
import org.apache.poi.hssf.usermodel.HSSFSheet; |
import org.apache.poi.hssf.usermodel.HSSFSheet; |
21 |
import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
22 |
import org.apache.poi.hssf.util.CellReference; |
import org.apache.poi.hssf.util.CellReference; |
23 |
|
import org.junit.Ignore; |
24 |
import org.junit.Test; |
import org.junit.Test; |
25 |
|
|
26 |
import schmitzm.junit.TestingClass; |
import schmitzm.junit.TestingClass; |
29 |
public class JxlKloseTest extends TestingClass { |
public class JxlKloseTest extends TestingClass { |
30 |
|
|
31 |
@Test |
@Test |
32 |
|
@Ignore |
33 |
public void testJxl() throws IOException, WriteException, BiffException, |
public void testJxl() throws IOException, WriteException, BiffException, |
34 |
FormulaException { |
FormulaException { |
35 |
InputStream xlsUrl = JxlKloseTest.class |
InputStream xlsUrl = JxlKloseTest.class |
152 |
HSSFCell cellB7 = sheet.getRow(b7cellRef.getRow()).getCell( |
HSSFCell cellB7 = sheet.getRow(b7cellRef.getRow()).getCell( |
153 |
b7cellRef.getCol()); |
b7cellRef.getCol()); |
154 |
assertNotNull(cellB7); |
assertNotNull(cellB7); |
155 |
log.info("orig value B7 = " + cellB7.getNumericCellValue()); |
log.info("new value B7 = " + cellB7.getNumericCellValue()); |
156 |
assertEquals("B8+((-$D$3/100)*B8)", cellB7.getCellFormula()); |
assertEquals("B8+((-$D$3/100)*B8)", cellB7.getCellFormula()); |
157 |
assertEquals(9038.2964, cellB7.getNumericCellValue(), 0.0001); |
assertEquals(9038.2964, cellB7.getNumericCellValue(), 0.0001); |
158 |
|
|