Creating reports and dashboards | Stimulsoft community forum

Hi,
I want to export data to OpenOffice. I created report dynamically:

StiText dataText = new ...
dataText.Text = "{Data." + DC.ColumnName.Replace(" ", "_") + "}";
...

But when I export data to OpenOffice, values with date, numbers have apostrophe at the beginning.
Examples:
Exported value: 08.02.2013
Value in OpenOffice: '08.02.2013

Exported value: 12
Value in OpenOffice: '12

I think I must set type of column, but i don't know how?
Can you please help me?

Thank you.

Hello.

Please, try to set the Format of the Text boxes to the respectively to its content.

Thank you.

Hi, thank you for you answer.
I tested this:
dataText.TextFormat = new Stimulsoft.Report.Components.TextFormats.StiDateFormatService("dd.MM.yyyy", "");
but I have still apostrophe at the begin in OpenOffice.

I attached sample project.

Thank you for your help.

Hello.

We have reproduced your issue. We need time to solve this problem.
Meanwhile, you can use next workaround method: remove apostrophes before numbers in OpenOffice Calc

Thank you.

Hellou.

Do you have any new information about patch for this problem?

Thank you.

Hello.

There are some technical difficulties. We need more time to fix this issue.

Thank you.

Fixed?

Hello.

There are some problems with implementation of this feature.
We are still working on it, but we need additional time for implementation.

Thank you.

Hello,
Is there any new information about this problem?

Thank you.

Sat

Hello,

We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.

Thank you.