When exporting to an xls in cognos star office is not keeping the formatting. If the file is open is MSOffice formating is in tact. To our knowledge we have the latest SO patch. Looks like an interpretation issue.
Has anyone seen this before between other system that export to xls. Is there something I can have cognos point to. Yes, I understand this is a SO forum but to some degree since SO is downstream I would like to start there before I dig deeper somewhere else.
It is strictly formating for number fields in SCALC. It is not keeping the currency formating, decimal fields etc... The rest remains pretty clean.
My goal is to stop the proliferation of MSOffice by our sales force. Any guidance would be appreciated.