public void TestSpuriousSharedFormulaFlag()
{
long actualCRC = GetFileCRC(HSSFTestDataSamples.OpenSampleFileStream(ABNORMAL_SHARED_FORMULA_FLAG_TEST_FILE));
long expectedCRC = 2277445406L;
if (actualCRC != expectedCRC)
{
Console.Error.WriteLine("Expected crc " + expectedCRC + " but got " + actualCRC);
throw failUnexpectedTestFileChange();
}
HSSFWorkbook wb = HSSFTestDataSamples.OpenSampleWorkbook(ABNORMAL_SHARED_FORMULA_FLAG_TEST_FILE);
Npoi.Core.SS.UserModel.ISheet s = wb.GetSheetAt(0); // Sheet1
String cellFormula;
cellFormula = GetFormulaFromFirstCell(s, 0); // row "1"
// the problem is1 not observable in the first row of the shared formula
if (!cellFormula.Equals("\"first formula\""))
{
throw new Exception("Something else wrong with this Test case");
}
// but the problem is1 observable in rows 2,3,4
cellFormula = GetFormulaFromFirstCell(s, 1); // row "2"
if (cellFormula.Equals("\"second formula\""))
{
throw new AssertionException("found bug 44449 (Wrong SharedFormulaRecord was used).");
}
if (!cellFormula.Equals("\"first formula\""))
{
throw new Exception("Something else wrong with this Test case");
}
}
/**
* @param streamOffset start position for serialization. This affects values in some
* records such as INDEX, but most callers will be OK to pass zero.
* @return the {@link Record}s (in order) which will be output when the
* specified sheet is serialized
*/
public static Record[] GetRecords(Npoi.Core.SS.UserModel.ISheet hSheet, int streamOffset)
{
RecordCollector rc = new RecordCollector();
((HSSFSheet)hSheet).Sheet.VisitContainedRecords(rc, streamOffset);
return(rc.Records);
}
public void TestAnchorHeightInPoints()
{
HSSFWorkbook wb = new HSSFWorkbook();
Npoi.Core.SS.UserModel.ISheet sheet = wb.CreateSheet();
HSSFClientAnchor[] anchor =
{
new HSSFClientAnchor(0, 0, 0, 0, (short)0, 1, (short)1, 3),
new HSSFClientAnchor(0, 254, 0, 126, (short)0, 1, (short)1, 3),
new HSSFClientAnchor(0, 128, 0, 128, (short)0, 1, (short)1, 3),
new HSSFClientAnchor(0, 0, 0, 128, (short)0, 1, (short)1, 3),
};
float[] ref1 = { 25.5f, 19.125f, 25.5f, 31.875f };
for (int i = 0; i < anchor.Length; i++)
{
float height = anchor[i].GetAnchorHeightInPoints(sheet);
Assert.AreEqual(ref1[i], height, 0);
}
}
private static String GetFormulaFromFirstCell(Npoi.Core.SS.UserModel.ISheet s, int rowIx)
{
return(s.GetRow(rowIx).GetCell((short)0).CellFormula);
}
public void TestBackupRecord()
{
HSSFWorkbook wb = new HSSFWorkbook();
for (int i = 0; i < 10; i++)
{
HSSFSheet s = (HSSFSheet)wb.CreateSheet("Sheet " + i);
InternalSheet sheet = s.Sheet;
}
// Check the initial order
Assert.AreEqual(0, wb.GetSheetIndex("Sheet 0"));
Assert.AreEqual(1, wb.GetSheetIndex("Sheet 1"));
Assert.AreEqual(2, wb.GetSheetIndex("Sheet 2"));
Assert.AreEqual(3, wb.GetSheetIndex("Sheet 3"));
Assert.AreEqual(4, wb.GetSheetIndex("Sheet 4"));
Assert.AreEqual(5, wb.GetSheetIndex("Sheet 5"));
Assert.AreEqual(6, wb.GetSheetIndex("Sheet 6"));
Assert.AreEqual(7, wb.GetSheetIndex("Sheet 7"));
Assert.AreEqual(8, wb.GetSheetIndex("Sheet 8"));
Assert.AreEqual(9, wb.GetSheetIndex("Sheet 9"));
// Change
wb.Workbook.SetSheetOrder("Sheet 6", 0);
wb.Workbook.SetSheetOrder("Sheet 3", 7);
wb.Workbook.SetSheetOrder("Sheet 1", 9);
// Check they're currently right
Assert.AreEqual(0, wb.GetSheetIndex("Sheet 6"));
Assert.AreEqual(1, wb.GetSheetIndex("Sheet 0"));
Assert.AreEqual(2, wb.GetSheetIndex("Sheet 2"));
Assert.AreEqual(3, wb.GetSheetIndex("Sheet 4"));
Assert.AreEqual(4, wb.GetSheetIndex("Sheet 5"));
Assert.AreEqual(5, wb.GetSheetIndex("Sheet 7"));
Assert.AreEqual(6, wb.GetSheetIndex("Sheet 3"));
Assert.AreEqual(7, wb.GetSheetIndex("Sheet 8"));
Assert.AreEqual(8, wb.GetSheetIndex("Sheet 9"));
Assert.AreEqual(9, wb.GetSheetIndex("Sheet 1"));
// Read it in and see if it is correct.
MemoryStream baos = new MemoryStream();
wb.Write(baos);
MemoryStream bais = new MemoryStream(baos.ToArray());
HSSFWorkbook wbr = new HSSFWorkbook(bais);
Assert.AreEqual(0, wbr.GetSheetIndex("Sheet 6"));
Assert.AreEqual(1, wbr.GetSheetIndex("Sheet 0"));
Assert.AreEqual(2, wbr.GetSheetIndex("Sheet 2"));
Assert.AreEqual(3, wbr.GetSheetIndex("Sheet 4"));
Assert.AreEqual(4, wbr.GetSheetIndex("Sheet 5"));
Assert.AreEqual(5, wbr.GetSheetIndex("Sheet 7"));
Assert.AreEqual(6, wbr.GetSheetIndex("Sheet 3"));
Assert.AreEqual(7, wbr.GetSheetIndex("Sheet 8"));
Assert.AreEqual(8, wbr.GetSheetIndex("Sheet 9"));
Assert.AreEqual(9, wbr.GetSheetIndex("Sheet 1"));
// Now get the index by the sheet, not the name
for (int i = 0; i < 10; i++)
{
Npoi.Core.SS.UserModel.ISheet s = wbr.GetSheetAt(i);
Assert.AreEqual(i, wbr.GetSheetIndex(s));
}
}
