public void TestCharSet()
{
CT_Font ctFont = new CT_Font();
CT_IntProperty prop = ctFont.AddNewCharset();
prop.val = (FontCharset.ANSI.Value);
ctFont.SetCharsetArray(0, prop);
XSSFFont xssfFont = new XSSFFont(ctFont);
Assert.AreEqual(FontCharset.ANSI.Value, xssfFont.Charset);
xssfFont.SetCharSet(FontCharset.DEFAULT);
Assert.AreEqual(FontCharset.DEFAULT.Value, ctFont.GetCharsetArray(0).val);
// Try with a few less usual ones:
// Set with the Charset itself
xssfFont.SetCharSet(FontCharset.RUSSIAN);
Assert.AreEqual(FontCharset.RUSSIAN.Value, xssfFont.Charset);
// And Set with the Charset index
xssfFont.SetCharSet(FontCharset.ARABIC.Value);
Assert.AreEqual(FontCharset.ARABIC.Value, xssfFont.Charset);
xssfFont.SetCharSet((byte)(FontCharset.ARABIC.Value));
Assert.AreEqual(FontCharset.ARABIC.Value, xssfFont.Charset);
// This one isn't allowed
Assert.AreEqual(null, FontCharset.ValueOf(9999));
try
{
xssfFont.SetCharSet(9999);
Assert.Fail("Shouldn't be able to Set an invalid charset");
}
catch (POIXMLException) { }
// Now try with a few sample files
// Normal charset
XSSFWorkbook workbook = XSSFTestDataSamples.OpenSampleWorkbook("Formatting.xlsx");
Assert.AreEqual(0,
((XSSFCellStyle)workbook.GetSheetAt(0).GetRow(0).GetCell(0).CellStyle).GetFont().Charset
);
// GB2312 charact Set
workbook = XSSFTestDataSamples.OpenSampleWorkbook("49273.xlsx");
Assert.AreEqual(134,
((XSSFCellStyle)workbook.GetSheetAt(0).GetRow(0).GetCell(0).CellStyle).GetFont().Charset
);
}
/**
* set character-set to use.
*
* @param charSet
*/
public void SetCharSet(FontCharset charset)
{
CT_IntProperty charSetProperty;
if (_ctFont.sizeOfCharsetArray() == 0)
{
charSetProperty = _ctFont.AddNewCharset();
}
else
{
charSetProperty = _ctFont.GetCharsetArray(0);
}
// We know that FontCharset only has valid entries in it,
// so we can just set the int value from it
charSetProperty.val = charset.Value;
}
/**
*
* CTRPrElt --> CTFont adapter
*/
protected static CT_Font ToCTFont(CT_RPrElt pr)
{
CT_Font ctFont = new CT_Font();
if (pr.SizeOfBArray() > 0)
{
ctFont.AddNewB().val = (pr.GetBArray(0).val);
}
if (pr.SizeOfUArray() > 0)
{
ctFont.AddNewU().val = (pr.GetUArray(0).val);
}
if (pr.SizeOfIArray() > 0)
{
ctFont.AddNewI().val = (pr.GetIArray(0).val);
}
if (pr.SizeOfColorArray() > 0)
{
CT_Color c1 = pr.GetColorArray(0);
CT_Color c2 = ctFont.AddNewColor();
if (c1.IsSetAuto())
{
c2.auto = (c1.auto);
c2.autoSpecified = true;
}
if (c1.IsSetIndexed())
{
c2.indexed = (c1.indexed);
c2.indexedSpecified = true;
}
if (c1.IsSetRgb())
{
c2.SetRgb(c1.GetRgb());
c2.rgbSpecified = true;
}
if (c1.IsSetTheme())
{
c2.theme = (c1.theme);
c2.themeSpecified = true;
}
if (c1.IsSetTint())
{
c2.tint = (c1.tint);
c2.tintSpecified = true;
}
}
if (pr.SizeOfSzArray() > 0)
{
ctFont.AddNewSz().val = (pr.GetSzArray(0).val);
}
if (pr.SizeOfRFontArray() > 0)
{
ctFont.AddNewName().val = (pr.GetRFontArray(0).val);
}
if (pr.SizeOfFamilyArray() > 0)
{
ctFont.AddNewFamily().val = (pr.GetFamilyArray(0).val);
}
if (pr.sizeOfSchemeArray() > 0)
{
ctFont.AddNewScheme().val = (pr.GetSchemeArray(0).val);
}
if (pr.sizeOfCharsetArray() > 0)
{
ctFont.AddNewCharset().val = (pr.GetCharsetArray(0).val);
}
if (pr.sizeOfCondenseArray() > 0)
{
ctFont.AddNewCondense().val = (pr.GetCondenseArray(0).val);
}
if (pr.sizeOfExtendArray() > 0)
{
ctFont.AddNewExtend().val = (pr.GetExtendArray(0).val);
}
if (pr.sizeOfVertAlignArray() > 0)
{
ctFont.AddNewVertAlign().val = (pr.GetVertAlignArray(0).val);
}
if (pr.sizeOfOutlineArray() > 0)
{
ctFont.AddNewOutline().val = (pr.GetOutlineArray(0).val);
}
if (pr.sizeOfShadowArray() > 0)
{
ctFont.AddNewShadow().val = (pr.GetShadowArray(0).val);
}
if (pr.sizeOfStrikeArray() > 0)
{
ctFont.AddNewStrike().val = (pr.GetStrikeArray(0).val);
}
return(ctFont);
}