I have SET NODATA = ''; in my procedure for and xlsx output.But i still get '.' in my columns.But when I output as EXL2k it works fine.
Am I missing something
WF8105M windows 10This message has been edited. Last edited by: FP Mod Chuck,
October 20, 2018, 06:57 PM
Siva1925
When I used SET EMPTYCELLS = OFF SET NODATA = - It is working. But i need blanks when there is no data. How can I do it.
October 20, 2018, 07:09 PM
Siva1925
I got this fixed
October 22, 2018, 07:49 AM
MartinY
quote:
I got this fixed
Could be great if you can also share your solution. It may help other people to avoid the same error/issue. Not a good team spirit to tell that you solve it and not saying how
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
October 22, 2018, 09:29 AM
Siva1925
Sorry I was in a hurry to clear the issue during the weekend. It was a silly mistake on the code. we were using -SET NODATA = ''; Removing the '-' cleared the issue.