Hi
I seem to be encountering some missing functionality in the XSSFTextBox, and
also a bug.
Functionality wise it is missing the following, that are implemented in both
HSSFTextBox, and XSLFTextShape:
Horizontal Alignment
Vertical Alignment
Margin {Top|Right|Bottom|Left}
Bug wise I am using the SXSSFWorkbook interface, create a sheet, then add a
textbox to it. I then set some text which has a font of size 18pt, color red
and font family Arial. However in the resulting file the size and color have
gone through, but not the font family - in Excel the style shows as Body (which
is the default Calibri font). Looking at the zip from an earlier test where the
text is #000000 I see that where I should see something like this (created in
Excel):
<a:rPr kumimoji="0" lang="en-GB" sz="1800" b="0" i="0" u="none"
strike="noStrike" kern="0" cap="none" spc="0" normalizeH="0" baseline="0"
noProof="0">
<a:ln>
<a:noFill/>
</a:ln>
<a:solidFill>
<a:sysClr val="windowText" lastClr="000000"/>
</a:solidFill>
<a:effectLst/>
<a:uLnTx/>
<a:uFillTx/>
<a:latin typeface="Arial" pitchFamily="34" charset="0"/>
<a:ea typeface="+mn-ea"/>
<a:cs typeface="Arial" pitchFamily="34" charset="0"/>
</a:rPr>
what I actually get is:
<a:rPr lang="en-US" u="none" sz="1800">
<a:solidFill>
<a:srgbClr val="000000"/>
</a:solidFill>
</a:rPr>
so it's completely missing the properties for the font.
Any thoughts on whats going wrong here?
Regards
Darren
