No difference between "none" Table style's border and non-exitent Table style

No difference between "none" Table style's border and non-exitent Table style

Posted by: eyal.ofri on 20 May 2023, 7:04 pm EST

• 

  eyal.ofri

  • Post Options:
  • Link
    Copy

  Posted 20 May 2023, 7:04 pm EST - Updated 20 May 2023, 7:12 pm EST

  I created an excel file that has 2 custom table styles in it.

  1. Has only “Whole Table” borders, without any “Row Header” styles
  2. Has “Whole Table” borders and in addition has “Row Header” style that define “topBorder: none”.

  When I import this file into GrapeCity it’s displayed correctly.
  
  But when I try to inspect the properties in Java I don’t see any difference between the 2 tables that indicates the actual difference in styles between the 2 tables.

  The path I looked at:
  
  worksheet.getTables().get(0).getTableStyle().getTableStyleElements().get(TableStyleElementType.HeaderRow)

  I attached the excel file I used and described above.table.zip

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2023, 11:37 pm EST

  Hi,

  We are discussing this with the development team. Will get back to you once we have any update from them.[Internal Tracking Id - DOCXLS-8267]

  Best Regards,
  
  Nitin

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 22 May 2023, 11:26 pm EST

  Hi,

  As per the development team, there’s no such method that could get the difference from table API.
  
  While we can get the difference using the cell’s display format:

  IBorder b1 = wb.getWorksheets().get(0).getRange("B6").getDisplayFormat().getBorders().get(BordersIndex.EdgeTop);
  IBorder b2 = wb.getWorksheets().get(0).getRange("G6").getDisplayFormat().getBorders().get(BordersIndex.EdgeTop);
  System.out.println(b1.getLineStyle());
  System.out.println(b2.getLineStyle());

  Please refer the attached sample: GcExcel.zip

  Best Regards,
  
  Nitin