I'm finally able to extract the normal text and the superscript content
separately. This is what I did :
If you have a content such as 'ABC2 Some text2', where both the 2s are
superscript, then numFormattingRuns() in XSSF is returning value 4 (i.e)
ABC, 2, some text and 2. However, HSSF is returni
Hi,
Please describe the jars and structure of your app's WEB-INF/lib
I know Tomcat. If 5.5.X then what is in tomcat/common/lib and if Tomcat 6.0.X
what is in tomcat/lib?
When the ooxml-libs are used whether or not you have the correct XML parser or
not becomes important.
We've run POI in a we
Hi, if one has cell with some multicolored text (each word different color) -
it is possible to obtain all of these colors using hssf?
It seems to me that only one color can be obtained per font, one font per style
and one style per cell.
Is there any other way to do this?
--
I have this small problem. I'm running my app within the JBoss app server.
All works fine for the older excel file format, the .xls. For the new, that
requires more libraries, especially those inside of the ooxml-lib folder,
nothing works. The code compiles but when running I'm getting the
class-no
Just to be clear on what you are asking for, there is no existing way to just
get the superscripted text alone. You will have to get the contents of the
cell and sift out the superscripted text sadly.
It should be possible to create such a sieve but I think - with regard to
HSSF - it means getting
Ths showInPane() method does not do what I expect you think it does. It
actually determines which of the sheets rows will appear in the freeze pane,
it does not scroll the display up so that you can see, for example, row 40
displayed on the worksheet when the user opens it using Excel.
Instead, tr
What I mean is, I think getFontOfFormattingRun(0) returns the Font properties
of the superscript alone.
Thanks
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Reading-superscript-from-data-cell-tp3414964p3424811.html
Sent from the POI - User mailing list archive at Nabbl
I need to process xls files ( HSSF ) only.
I don't know how, but I think only the superscript is coming inside
FormattedRun condition because when I tried the following code :
HSSFCellStyle style = cell.getCellStyle();
HSSFFont cellFont = workbook.getFontAt(style.getFontIndex());
HSSFFont myfon
Hello again...
As clarification, I would like to mention that after doing some tests on a
real excel file, for the correct operation of shiftRows() method, if we
delete merged rows, we must first eliminate the merged region including
the rows for delete to function properly.
In case of keepin
Thanks for letting me know that. 'Type' specificity was one of the factors I
was intending to test next.
Will you be able to work with just the XSSF stream or do you need to process
xls files as well?
Yours
Mark B
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Reading
10 matches
Mail list logo
