Hyphen formatted numbers issue when exporting to excel.
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed.
Issue
When setting a numbered line item to hyphen format. When exporting as xls or xlsx, the hyphen formatted cell will only ever display a hyphen, even when edited to be non zero cell values.
Workaround
The only means to workaround this is to remove the custom formatting on the cell in excel until this has been fixed.
---
Internal Reference: CORESRV-11117
Answers
-
Hi @Ali ,
Could you please elaborate your question if possible?
So as per my understanding when export a module which has hypen-number formatted line item and after exporting that module as xls . if you are trying to edit non-zero cell still you are getting hypen only right?.
I tried and it is working fine for me.
Attaching screenshot for your reference.
0 -
Hi Venki,
My apologies for any confusion caused. This was fixed some time ago which is why you cannot reproduce it.
0
