Numbers in reports exported in excel are formatted as text.

Diogo Thomaz shared this question 6 months ago
Answered

When we export a report in xlsx format numbers are now treated as text. This happens in reports that were previously exporting OK from YF.

Can I do something to fix this?

Thank you,

Diogo

Comments (9)

photo
1

Hi Diogo,

I hope all is well,

I have looked at this and I believe this is a bug that HAS been logged here at YF, however I would like to investigate further... Can I question what happens when you toggle between the Keep Formatting button when saving? Does this resolve? Does this continue to format as text as opposed to number? I would also like to question what version/build this previously worked in if you know this?

If you can get back to me with the answer to this I would appreciate this greatly. I look forward to your reply.

Regards,

Mark

photo
1

Hello Mark,

Thank you for the fast support.

I tried to export keeping and not keeping the format and when I switch to Do Not Keep format then it exports well, as numbers and not text...

The problem we have is that our users export from embedded reports and there I don't think they can choose to keep or no the format...

Any suggestions?

Diogo

photo
1

Hi Diogo,

Thank you for the update. So we have identified that when selecting Do Not Keep Formatting it exports as a number, which is what we wanted, however from what you have stated these reports are embedded and you do not have this option to toggle between the formatting options... Is this correct Diogo?

Regards,

Mark

photo
1

Hi Diogo,

I hope all is well,

I just want to touch base to see if you need any further assistance with this issue. If you could get back to me asap I would appreciate this greatly. I look forward to your reply.

Regards,

Mark

photo
1

Hello Mark,

Wishes of an excellent 2019 for you and yours.

We have nothing new here. As I said, the reports are embedded and therefore there is no option to format or not. So the problems remains for our customers and I would appreciate if you can keep me informed of its reaolureso when it happens.

Regards,

Diogo

photo
1

Hi Diogo,

Thank you for getting back to me. From what I can see this was raised with our devs, I will add your information to this to help push for a "possible fix" in the near future. I hope this is ok.

Regards,

Mark

photo
1

Thanks

photo
1

Hello Mark,

I see a new release is out. Has this issue been resolved? It remains a problem with many of our customers...

Thanks

photo
1

Hi Diogo,

I hope all is well,

I have just checked this an unfortunately we have no movement on this. I have added some notes so that we can try and get this pushed. I do apologise.

Regards,

Mark