Re: 返: The CellType of a cell which is set to String

2016-08-19 Thread Young
If I use the default format of the cell(Standard) and type 'FALSE' in this cell, then I get the value 'false' in the cell by using formatCellValue method. Actually, I hope that I can get the value 'FALSE', not lowercase 'false'. Could I achieve this by using DataFormatter? On 2016-08-19 10:48 (+

RE: How to add diagonal up border to a tablecell in word document using XWPF

2016-08-19 Thread Krishna Vyas Majji
Mark, I think my attachment is not visible. I added "diagonal up border" in "Row One, Column One" Cell. Now I want to display first string in the top and second string in the bottom of the "diagonal up border". Can you please help me on that. Thanks and Regards, Krishna -Original Message-

RE: How to add diagonal up border to a tablecell in word document using XWPF

2016-08-19 Thread Murphy, Mark
Excel doesn't do that. You can put a string in there, but it does not wrap around the border. You can simulate it by aligning the text to the top and left, then adding a couple newlines, and spacing the second text string out to the right edge of the cell. Try it in Excel first to see just what

RE: How to add diagonal up border to a tablecell in word document using XWPF

2016-08-19 Thread Murphy, Mark
Ok, you were talking about Word. Word doesn't behave the way you want either, but I can have some text left aligned, and other text right aligned to simulate the effect you are looking for. I just have to manually ensure the text doesn't overlap the diagonal line. -Original Message- Fro

RE: How to add diagonal up border to a tablecell in word document using XWPF

2016-08-19 Thread Krishna Vyas Majji
Ok, Thanks mark. I will try to achieve that functionality manually. Thanks and Regards, Krishna -Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Friday, August 19, 2016 4:53 PM To: 'POI Users List' Subject: Bulk Mail : RE: How to add diagonal up border to a t

Re: 返: The CellType of a cell which is set to String

2016-08-19 Thread Javen O'Neal
https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DataFormatter.java?revision=1753122&view=markup#l897 Looks like it isn't being uppercased. String.valueOf(false) -> "false" Do you want to open a bug at https://bz.apache.org/bugzilla and submit a patch with a unit test?

Re: 返: The CellType of a cell which is set to String

2016-08-19 Thread Javen O'Neal
I had some time and wrote the unit test and patch. https://bz.apache.org/bugzilla/show_bug.cgi?id=60025 On Fri, Aug 19, 2016 at 8:31 AM, Javen O'Neal wrote: > https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DataFormatter.java?revision=1753122&view=markup#l897 > > Look