Bug 55341

Summary:	[PATCH] constants for HAIR and DOTTED border styles are swapped
Product:	POI	Reporter:	vladk <vladk.dev>
Component:	POI Overall	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal	CC:	jim-apache
Priority:	P2
Version:	3.10-dev
Target Milestone:	---
Hardware:	PC
OS:	All
Attachments:	Patch and unit tests Excel file to be put into poi/test-data/spreadsheet

Description vladk 2013-08-01 21:52:11 UTC

Created attachment 30659 [details]
Patch and unit tests

Values of constants CellStyle.BORDER_HAIR and CellStyle.BORDER_DOTTED are swapped. Patch and units tests will be attached.

Comment 1 vladk 2013-08-01 21:53:37 UTC

Created attachment 30660 [details]
Excel file to be put into poi/test-data/spreadsheet

Comment 2 vladk 2013-08-09 18:47:41 UTC

Setting cell border style to CellStyle.BORDER_DOTTED produces Excel style "hairline".
Setting cell border style to CellStyle.BORDER_HAIR produces Excel style "dotted".
The problem is also present when reading Excel files. The problem affects both XLS and XLSX files.

Comment 3 Dominik Stadler 2013-09-29 20:16:09 UTC

*** Bug 54863 has been marked as a duplicate of this bug. ***

Comment 4 Dominik Stadler 2013-09-29 20:24:39 UTC

Thanks for catching this, this is now fixed in latest trunk to be included in version 3.10.

Comment 5 Javen O'Neal 2016-04-06 00:16:37 UTC

Vlad,

Could you verify that bug 59264 does not introduce a regression?

org.apache.poi.ss.usermodel.BorderStyles.HAIR and DOTTED are now the single entry-points for setting and getting hairline and dotted cell borders.