Hyphen formatted numbers issue when exporting to excel.

Ali

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

Venki9902

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.