Log in to AnswerLog in to Follow
UserImage.jpg
David Nieuwenhuizen
23Views
1Comments
Unable to remove apostroph in excel columns after excel export
Question
Reactive
Import/Export Data
Application Type
Reactive
Service Studio Version
11.14.16 (Build 60354)

I am exporting a record list to excel which contains a text variable containing only a minus-sign. Excell sees this as a formula and therefore places an apostroph before the minus-sign. Is it possible in outsystems not let excell think the output is a formula?

0
0
18 May
2021-06-07 12-32-43
Pedro Costa
Champion

Hi David,

I don't know if this solution will please you, but you can solve this by adding a blank space before the - (minus-sign).

Assign:

Result:


Regards,

Pedro Costa

0
0
19 May
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.