Symptom
- You are exporting a list containing Date field (Data Type=DATS) using the export to Microsoft Excel function.
- The resulting spreadsheet file displays Date field cells incorrectly. i.e:
Read more...
Environment
- SAP Basis releases 4.6C to 7.00 with SAP Basis component lower than : SAPKB46C57, SAPKB62063, SAPKB64019, SAPKB70010
- SAP GUI 7.10 and higher.
- Microsoft Office 2007 and higher.
Product
SAP R/3 Enterprise 4.7x200 (Extension Set 2.00)
Keywords
Office 2007, Office 12, SET_FORMAT, XXL Export, Format Column, DATS, Data Type, (YYYYMMDD) stored as char(8), Date field , KBA , BC-FES-OFFI , SAP Desktop Office Integration , BC-FES-XXL , XXL List Viewer/Lotus Connections , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.