/**
*
* org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRPrElt to
* org.openxmlformats.schemas.drawingml.x2006.main.CTFont adapter
*/
private static void ApplyAttributes(CT_RPrElt pr, CT_TextCharacterProperties rPr)
{
if (pr.sizeOfBArray() > 0)
{
rPr.b = (pr.GetBArray(0).val);
}
if (pr.sizeOfUArray() > 0)
{
ST_UnderlineValues u1 = pr.GetUArray(0).val;
if (u1 == ST_UnderlineValues.single)
{
rPr.u = (ST_TextUnderlineType.sng);
}
else if (u1 == ST_UnderlineValues.@double)
{
rPr.u = (ST_TextUnderlineType.dbl);
}
else if (u1 == ST_UnderlineValues.none)
{
rPr.u = (ST_TextUnderlineType.none);
}
}
if (pr.sizeOfIArray() > 0)
{
rPr.i = (pr.GetIArray(0).val);
}
if (pr.sizeOfFamilyArray() > 0)
{
CT_TextFont rFont = rPr.AddNewLatin();
rFont.typeface = (pr.GetRFontArray(0).val);
}
if (pr.sizeOfSzArray() > 0)
{
int sz = (int)(pr.GetSzArray(0).val * 100);
rPr.sz = (sz);
}
if (pr.sizeOfColorArray() > 0)
{
CT_SolidColorFillProperties fill = rPr.IsSetSolidFill() ? rPr.solidFill : rPr.AddNewSolidFill();
NPOI.OpenXmlFormats.Spreadsheet.CT_Color xlsColor = pr.GetColorArray(0);
if (xlsColor.IsSetRgb())
{
CT_SRgbColor clr = fill.IsSetSrgbClr() ? fill.srgbClr : fill.AddNewSrgbClr();
clr.val = (xlsColor.rgb);
}
else if (xlsColor.IsSetIndexed())
{
HSSFColor indexed = HSSFColor.GetIndexHash()[(int)xlsColor.indexed] as HSSFColor;
if (indexed != null)
{
byte[] rgb = indexed.RGB;
CT_SRgbColor clr = fill.IsSetSrgbClr() ? fill.srgbClr : fill.AddNewSrgbClr();
clr.val = (rgb);
}
}
}
}
public void SetFontColor(Color color)
{
CT_TextCharacterProperties rPr = GetRPr();
CT_SolidColorFillProperties fill = rPr.IsSetSolidFill() ? rPr.solidFill : rPr.AddNewSolidFill();
CT_SRgbColor clr = fill.IsSetSrgbClr() ? fill.srgbClr : fill.AddNewSrgbClr();
clr.val = (new byte[] { color.R, color.G, color.B });
if (fill.IsSetHslClr())
{
fill.UnsetHslClr();
}
if (fill.IsSetPrstClr())
{
fill.UnsetPrstClr();
}
if (fill.IsSetSchemeClr())
{
fill.UnsetSchemeClr();
}
if (fill.IsSetScrgbClr())
{
fill.UnsetScrgbClr();
}
if (fill.IsSetSysClr())
{
fill.UnsetSysClr();
}
}
public Color GetFontColor()
{
CT_TextCharacterProperties rPr = GetRPr();
if (rPr.IsSetSolidFill())
{
CT_SolidColorFillProperties fill = rPr.solidFill;
if (fill.IsSetSrgbClr())
{
CT_SRgbColor clr = fill.srgbClr;
byte[] rgb = clr.val;
return(Color.FromArgb(0xFF & rgb[0], 0xFF & rgb[1], 0xFF & rgb[2]));
}
}
return(Color.FromArgb(0, 0, 0));
}
/**
* org.Openxmlformats.schemas.spreadsheetml.x2006.main.CTRPrElt to
* org.Openxmlformats.schemas.Drawingml.x2006.main.CTFont adapter
*/
private static void ApplyAttributes(CT_RPrElt pr, CT_TextCharacterProperties rPr)
{
if (pr.SizeOfBArray() > 0)
{
rPr.b = (/*setter*/ pr.GetBArray(0).val);
}
if (pr.SizeOfUArray() > 0)
{
ST_UnderlineValues u1 = pr.GetUArray(0).val;
if (u1 == ST_UnderlineValues.single)
{
rPr.u = (/*setter*/ ST_TextUnderlineType.sng);
}
else if (u1 == ST_UnderlineValues.@double)
{
rPr.u = (/*setter*/ ST_TextUnderlineType.dbl);
}
else if (u1 == ST_UnderlineValues.none)
{
rPr.u = (/*setter*/ ST_TextUnderlineType.none);
}
}
if (pr.SizeOfIArray() > 0)
{
rPr.i = (/*setter*/ pr.GetIArray(0).val);
}
if (pr.SizeOfRFontArray() > 0)
{
CT_TextFont rFont = rPr.IsSetLatin() ? rPr.latin : rPr.AddNewLatin();
rFont.typeface = (/*setter*/ pr.GetRFontArray(0).val);
}
if (pr.SizeOfSzArray() > 0)
{
int sz = (int)(pr.GetSzArray(0).val * 100);
rPr.sz = (/*setter*/ sz);
}
if (pr.SizeOfColorArray() > 0)
{
CT_SolidColorFillProperties fill = rPr.IsSetSolidFill() ? rPr.solidFill : rPr.AddNewSolidFill();
NPOI.OpenXmlFormats.Spreadsheet.CT_Color xlsColor = pr.GetColorArray(0);
if (xlsColor.IsSetRgb())
{
CT_SRgbColor clr = fill.IsSetSrgbClr() ? fill.srgbClr : fill.AddNewSrgbClr();
clr.val = (/*setter*/ xlsColor.rgb);
}
else if (xlsColor.IsSetIndexed())
{
HSSFColor indexed = (HSSFColor)HSSFColor.GetIndexHash()[((int)xlsColor.indexed)];
if (indexed != null)
{
byte[] rgb = new byte[3];
rgb[0] = (byte)indexed.GetTriplet()[0];
rgb[1] = (byte)indexed.GetTriplet()[1];
rgb[2] = (byte)indexed.GetTriplet()[2];
CT_SRgbColor clr = fill.IsSetSrgbClr() ? fill.srgbClr : fill.AddNewSrgbClr();
clr.val = (/*setter*/ rgb);
}
}
}
}
private static void ApplyAttributes(CT_RPrElt pr, CT_TextCharacterProperties rPr)
{
if (pr.sizeOfBArray() > 0)
{
rPr.b = pr.GetBArray(0).val;
}
if (pr.sizeOfUArray() > 0)
{
switch (pr.GetUArray(0).val)
{
case ST_UnderlineValues.none:
rPr.u = ST_TextUnderlineType.none;
break;
case ST_UnderlineValues.single:
rPr.u = ST_TextUnderlineType.sng;
break;
case ST_UnderlineValues.@double:
rPr.u = ST_TextUnderlineType.dbl;
break;
}
}
if (pr.sizeOfIArray() > 0)
{
rPr.i = pr.GetIArray(0).val;
}
if (pr.sizeOfFamilyArray() > 0)
{
rPr.AddNewLatin().typeface = pr.GetRFontArray(0).val;
}
if (pr.sizeOfSzArray() > 0)
{
int num = (int)(pr.GetSzArray(0).val * 100.0);
rPr.sz = num;
}
if (pr.sizeOfColorArray() <= 0)
{
return;
}
CT_SolidColorFillProperties colorFillProperties = rPr.IsSetSolidFill() ? rPr.solidFill : rPr.AddNewSolidFill();
NPOI.OpenXmlFormats.Spreadsheet.CT_Color colorArray = pr.GetColorArray(0);
if (colorArray.IsSetRgb())
{
(colorFillProperties.IsSetSrgbClr() ? colorFillProperties.srgbClr : colorFillProperties.AddNewSrgbClr()).val = colorArray.rgb;
}
else
{
if (!colorArray.IsSetIndexed())
{
return;
}
HSSFColor hssfColor = HSSFColor.GetIndexHash()[(object)(int)colorArray.indexed] as HSSFColor;
if (hssfColor == null)
{
return;
}
byte[] numArray = new byte[3] {
(byte)hssfColor.GetTriplet()[0], (byte)hssfColor.GetTriplet()[1], (byte)hssfColor.GetTriplet()[2]
};
(colorFillProperties.IsSetSrgbClr() ? colorFillProperties.srgbClr : colorFillProperties.AddNewSrgbClr()).val = numArray;
}
}