Skip to content

Conditional formatting hides the adjacent borders #200

@partomatl

Description

@partomatl

Description

Whenever a conditional format is set on a cell and the criterion is met, then this cell "hides" the adjacent borders.

Steps to reproduce the issue:

  1. Set a conditional format on a cell so that its criterion is met.
  2. Watch how it hides the adjacent borders.

Use this code:

xlsx.SetCellValue("Sheet1", "C20", 20)
style, err := xlsx.NewConditionalStyle(`{"font":{"color":"#09600B"}}`)
if err != nil {
	panic(err)
}
xlsx.SetConditionalFormat("Sheet1", "C20:C20", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"0"}]`, style))

Describe the results you received:

The cell C20 hides the adjacent borders.
capture d ecran 2018-03-28 a 19 17 12

Describe the results you expected:
capture d ecran 2018-03-28 a 19 17 08

Output of go version:

go version go1.10 darwin/amd64

Excelize version or commit ID:

Commit ID: 9d7b94d760126aa51485d7d864b1b98a8720017c

Environment details (OS, Microsoft Excel™ version, physical, etc.):
macOS High Sierra 10.13.3, Microsoft Excel 2016 for Mac 16.9

Thank you for your work!

Metadata

Metadata

Assignees

No one assigned

    Labels

    confirmedThis issue can be reproduced

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions