Mid characterrun characterrun.

2010-09-28 Thread Zachary Mitchell
Is it possible to create a new CharacterRun mid-character run (from a HWPFDocument), from a DocumentPosition, by using: /* Range.replaceText(oldText,"previous writing" + "\u0001" + "latter writing"); Range.replaceText(oldText,"previous writing" + "\r" + "latter writing"); */ Do either of these ca

Question about reflection.

2010-09-28 Thread Zachary Mitchell
The remaining problem I have with POI usage is using reflection to invoke an import method, with is protected, and part of a class hierachy which has a final class at its base. Can I use this message list for such a reflections question? I can't successfully run the following: //Java Version 1.6

Re: POI 3.7 beta 2 "new XSSFWorkbook" very slow

2010-09-28 Thread Ryan Skow
Unfortunately the 3.7b3 is no faster. I can make a Bugzilla entry, but can't attach the spreadsheet in question since it is confidential. I've been trying to make test spreadsheets to try to narrow down what exactly it is having trouble with, but have so far been unsuccessful. It may have so

Re: Can POI(Excel) change cell font color partially

2010-09-28 Thread floydF floydL
thank you so much - that's what i want O(∩_∩)O And also i found the ss api contains the corresponding interface, too. i have missed it... 2010/9/28 > Did you try using a "RichTextString" ? I have never used it, but from the > help file it looks like it might do what you need. > -Lou > > > > fl

Re: problem with macro in xls file

2010-09-28 Thread David Fisher
We have no problems preserving a Macro contained within an XLS. We have no problems with signed macros. Please post some code so that we can have an idea what you are doing. For example, you need to modify your macro containing file and not copy it within POI. Regards, Dave On Sep 28, 2010, a

Re: Can POI(Excel) change cell font color partially

2010-09-28 Thread Louis . Masters
Did you try using a "RichTextString" ? I have never used it, but from the help file it looks like it might do what you need. -Lou floydF floydL wrote on 09/28/2010 09:45:00 AM: > A cell whose text is 'hello world' in black color can be modified to > 'hello'-red & 'world'-blue ? A cell with t

how to put password to a xlsx/xlsm file with poi?

2010-09-28 Thread Pablo Johnson
Hello everyone i want to put a password to a xlsx or xlsm file.. is there any property?? thanks - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org

Re: problem with macro in xls file

2010-09-28 Thread Pablo Johnson
hi which extension is your output? you have to save it as "***.xlsm" in order to save the macros At 07:09 28/09/2010, you wrote: Hi, I have an excel file as a template with Macro inside it. when I want to edit my file with POI (for example add new rows), the macro has been removed in output fi

Can POI(Excel) change cell font color partially

2010-09-28 Thread floydF floydL
A cell whose text is 'hello world' in black color can be modified to 'hello'-red & 'world'-blue ? A cell with two colors... -- the office excel can easily do this(event the excel2002) i check the POI example,found the following code 'f.setColor( IndexedColors.RED.getIndex() ); ' which cannot fill

problem with macro in xls file

2010-09-28 Thread Shayesteh Alavi
Hi, I have an excel file as a template with Macro inside it. when I want to edit my file with POI (for example add new rows), the macro has been removed in output file. Can anybody knows how to fix this problem? Thank you in advance

Using reflection to invoke a protected method in the Range class.

2010-09-28 Thread Zachary Mitchell
/* Can anyone tell me why the following won't invoke, given that all the correct packages have been imported? */ //Java Version 1.6.0_20-b02 Class [] types = {ParagraphProperties.class,Integer.class,String.class}; Method insertAfter = overall.getClass().getDeclaredMethod(new String("insertAfte