Exporting for XLS formatting problem

38 views
Skip to first unread message

LeandroS

unread,
May 10, 2020, 9:14:10 AM5/10/20
to myfyireporting
Hi Masters,

I'm using the last version of fyireporint design editor (4.15.7435) and my exports to XLS failing with formatted fields, see this example:

                   <Textbox Name="Textbox18">
                      <Value>=(( {VALORREALIZADO}*100) /{VALOR})-100</Value>
                      <Style xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
                        <BorderStyle>
                          <Default>None</Default>
                          <Left>None</Left>
                          <Right>None</Right>
                          <Top>None</Top>
                          <Bottom>Ridge</Bottom>
                        </BorderStyle>
                        <BorderColor>
                          <Bottom>Lightgrey</Bottom>
                        </BorderColor>
                        <BorderWidth />
                        <Format>#,##0.00</Format>
                        <PaddingRight>15pt</PaddingRight>
                      </Style>
                    </Textbox>



On the Preview Designer I see the correct value, but when I export to XLS I get this:


Designer:  33.00 
LibreOfficeCalc  3300



My temporary solution is delete any format from column before to export.


Has anyone run into the same problem?

Best Regars
Leandro S.


Ps. Sorry My English is not enough!!
Reply all
Reply to author
Forward
0 new messages