<pen> border of cell not editable in excel

[schmatte]

Hello,

I've got a problem while using JExcelApiExporter of JasperReports 3.7.1, because the border of the created cell in the excel-stylesheet is fixed. In the created excel-file I can't open the context-menu of the cell - with the content of the staticText -, to change any settings. Nevertheless the color of the cell-font or the content is editable, but not the cell-border. I use Excel 2003 SP3.

1.) Is this a common problem of excel, which doesn't depend on the version?
2.) Does there exist another jasper-template-tag to create borders, which avoid this border-problem and to get fully editable excel-cells?

Regards.

Template:

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"
              name="firstReport">
 <detail>
  <band height="20">
    <staticText>
     <reportElement mode="Transparent" x="120" y="0" width="275" height="20"/>
     <box>
      <pen lineWidth="1"/>
     </box>
     <text><![CDATA[Text with border]]></text>
    </staticText>
  </band>
 </detail>
</jasperReport>

Exporter-parameters:
   
   xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, print);
   xlsExporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
   xlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
   xlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);
   xlsExporter.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BORDER, false);
   xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false);
   
 

[slow]

same problem...

have you find a solution?

[schmatte]

No, I tried the same with Apache POI 3.6 directly. Here I've got the same problem, but only with cells, which doesn't have any content. The cells, which contained some content (for instance plain text) were still full editable, afterwards a border has been added.

[slow]

I use iReport 1.3.3 in an old project so this mean use

jasperreports-1.3.3
poi-2.0-final-20040126
jxl-2.6

...very very old...

I have got the problem wen I use JExcel from IReport preview... (with POI it works fine...) but when i run the report programmatically I've got the same problem... so I think there's library version problem.

thanks...