Error setting the cell pattern when exporting to Excel, a backslash is added before the space

0

Good day! Using property net.sf.jasperreports.export.xls.pattern when setting a template to a cell:

<textField>
    <reportElement style="Style1" x="1300" y="0" width="50" height="15"
                   uuid="9e73ee83-1f96-4291-a45a-176bf0d4d31f">
        <property name="com.jaspersoft.studio.spreadsheet.connectionID"
                  value="0dd5392d-7e43-4517-bb61-b58e9341e410"/>
        <property name="net.sf.jasperreports.export.xls.pattern">
            <![CDATA[_-* # ##0.00_р_._-;-* # ##0.00_р_._-;_-* &quot;-&quot;??_р_._-;_-@_-]]>
        </property>
        <property name="com.jaspersoft.studio.unit.height" value="px"/>
    </reportElement>
    <textFieldExpression><![CDATA[$F{PROSR_KOM_E}]]></textFieldExpression>
</textField>

But after export, the wrong template is displayed in Excel: _-* #\ ##0.00_р_._-;-* #\ ##0.00_р_._-;_-* "-"??_р_._-;_-@_-

Where does this slash come from? How to remove it? Tried changing the space to a unicode sysvol, did not help. I use XLSX.

kulaev.dm's picture
Joined: Mar 9 2020 - 2:53am
Last seen: 1 month 6 days ago

0 Answers:

No answers yet
Feedback