Export to OpenOffice, value with apostrophe at the beginning

Stimulsoft Reports.NET discussion
satvcd
Posts: 12
Joined: Fri Feb 08, 2013 6:46 am

Export to OpenOffice, value with apostrophe at the beginning

Post by satvcd »

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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Export to OpenOffice, value with apostrophe at the begin

Post by HighAley »

Hello.

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

Thank you.
satvcd
Posts: 12
Joined: Fri Feb 08, 2013 6:46 am

Re: Export to OpenOffice, value with apostrophe at the begin

Post by satvcd »

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.
Attachments
SampleProject.zip
(192.14 KiB) Downloaded 266 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Export to OpenOffice, value with apostrophe at the begin

Post by HighAley »

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.
satvcd
Posts: 12
Joined: Fri Feb 08, 2013 6:46 am

Re: Export to OpenOffice, value with apostrophe at the begin

Post by satvcd »

Hellou.

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

Thank you.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Export to OpenOffice, value with apostrophe at the begin

Post by HighAley »

Hello.

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

Thank you.
satvcd
Posts: 12
Joined: Fri Feb 08, 2013 6:46 am

Re: Export to OpenOffice, value with apostrophe at the begin

Post by satvcd »

Fixed?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Export to OpenOffice, value with apostrophe at the begin

Post by HighAley »

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.
satvcd
Posts: 12
Joined: Fri Feb 08, 2013 6:46 am

Re: Export to OpenOffice, value with apostrophe at the begin

Post by satvcd »

Hello,
Is there any new information about this problem?

Thank you.

Sat
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Export to OpenOffice, value with apostrophe at the begin

Post by Alex K. »

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.
Post Reply