We are generating worksheets with Aspose.grid having text in spanish, and of course it uses characters with tilde (ñ,Ñ) and acute (á,é,í,ó,ú). The pages are shown right in both development and production environments. when we export the grid to an excel file at the development environment it works fine. However when we export the same data to an excel file at the production environment, all those characters are converted to a question mark (?).
Production web server is Windows 2003 Server 64-bit/ IIS 6.0 in SPANISH.
Development environment web server is Windows 2003 SBS 32-bit/IIS in ENGLISH.
When the application is tested on any development workstation, Windows Vista / IIS 7.0 in ENGLISH, the exported files work fine.
We have changed all regional settings in our development environment to match those in the production environment but nothing changes. It still working fine.
We have changed the regional settings in our production environment to match those in the development environment and nothing changes. It still replacing those characters to question marks.
Any help will be appreciated.