Re: How to read the value of bookmarks? (docx)

2012-12-13 Thread sreejithcools
Thanks for the reply , Actually i am working on Libreoffice till now for creating bookmark . It does'nt allow you to add bookmark to a Selected text , it can add bookmark only to a position some where in docx file . Yesterday i tried in MS Word , giving bookmark , and then it worked smoothly . S

Re: BUG!? in Area3DPtg Class??

2012-12-13 Thread pedromartins4
Hi again. This worked neatly. Thanks :) But now I have the same problem with XSSFCell, since: Field f = XSSFCell.class.getDeclaredField("_record"); does not work. Any help? Thanks in advance, Pedro On Dec 2, 2012, at 1:33 PM, Yegor Kozlov wrote: > Firstly, formulas in the bina

Question about extending XSSFSheetXMLHandler

2012-12-13 Thread Chris Bamford
Hi POI people I am using poi-3.8-beta5 as bundled with Aperture 1.6.0. I would like to extend XSSFSheetXMLHandler so that in the case of formatted numbers in cells I can also optionally output the raw value instead. Although the method in question (endElement()) is public and therefore extendabl

Re: RichTextString isn't working for SXSSFWorkbook

2012-12-13 Thread Yegor Kozlov
Rich text is not supported in SXSSF by design. Excel and XSSF store strings in a so called Shared Strings Table (SST) which is basically a cache of strings. When you write a rich text value in a cell then it is written in the SST and the cell references it by Id. When you read rich text from a cell

Re: RichTextString isn't working for SXSSFWorkbook

2012-12-13 Thread Marat
Mark Beardsley tiscali.co.uk> writes: > > What happens if you make a simple change to the sequence of your method > class, a little like this; > > public Workbook createRichTextWorkbook() { > Workbook wb = new SXSSFWorkbook(); > > Sheet copySheet = wb.createSheet("TestRT"); >