I need to detect whether a cell has diagonal borders. In the Excel document
I receive, the customer indicates that a cell should be skipped by applying
both forward and backward diagonal border so that an "X" is drawn.
I've seen that the BorderFormatting class seems to support diag
of the diagonal options unless you are confident in your user
body.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Diagonal-border-tp5720338p5720341.html
Sent from the POI - User mailing list archive at Nabble.com
Hi,
There was a discussion about how to set diagonal border styling a few
weeks ago, see
http://mail-archives.apache.org/mod_mbox/poi-user/201508.mbox/browser,
it describes how to set a diagonal border, maybe you can use some of
this for reading the information in your case.
Dominik.
On Fri
Thank you Mark and Dominik. I will try to get this information from the
cell style.
/Bengt
2015-09-25 18:22 GMT+02:00 Dominik Stadler :
> Hi,
>
> There was a discussion about how to set diagonal border styling a few
> weeks ago, see
> http://mail-archives.apache.org/mod_mbox/
; cell style.
>
> /Bengt
>
> 2015-09-25 18:22 GMT+02:00 Dominik Stadler :
>
>> Hi,
>>
>> There was a discussion about how to set diagonal border styling a few
>> weeks ago, see
>> http://mail-archives.apache.org/mod_mbox/poi-user/201508.mbox/browser,
&g
gt;> Thank you Mark and Dominik. I will try to get this information from the
>> cell style.
>>
>> /Bengt
>>
>> 2015-09-25 18:22 GMT+02:00 Dominik Stadler :
>>
>>> Hi,
>>>
>>> There was a discussion about how to set diagonal border s
Hi list,
I know how to get the bottom, top, left and right:
CellStyle style = cell.getCellStyle();
CellReference cellRef = new CellReference(row.getRowNum(),
cell.getColumnIndex());
System.out.println(cellRef + " Bottom: " + style.getBorderBottom());
System.out.pri
Hi,
It seems the POI interface does not provide this currently, can you
create two very simple files that are very similar, only one without
this and one with this formatting and then compare the XML-files
inside the .XLSX? .xlsx-files are just ZIPs, so you can unpack them
and compare the files in
such a lower level API call look like to get those attributes? Thanks a lot
already for your help.
Regards
Gesendet: Montag, 27. Juli 2015 um 18:41 Uhr
Von: "Dominik Stadler"
An: "POI Users List"
Betreff: Re: How can I GET the diagonal border for a Cell?
Hi,
It seems the PO
r level API call look like to get those attributes? Thanks a
> lot already for your help.
>
> Regards
>
> Gesendet: Montag, 27. Juli 2015 um 18:41 Uhr
> Von: "Dominik Stadler"
> An: "POI Users List"
> Betreff: Re: How can I GET the diagonal border for a
10 matches
Mail list logo