RE: [sap-dev] ALV Grid exporting to Excel - negative values are exported as positive
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by john.louk (Workflow Designer) on May 11 at 2:40 PM |  Mark as helpful |
In the ALV, what is the negative indicator? Or, what shows it as a negative value?
What SAP table are you getting the information from?
Cheers
John
From: RBVaccaro via sap-dev [mailto:sap-dev@groups.ittoolbox.com]
Sent: Tuesday, May 11, 2010 2:31 PM
To: Louk, John
Subject: [sap-dev] ALV Grid exporting to Excel - negative values are exported as positive
Posted by RBVaccaro
on May 11 at 2:29 PM
Dear SAP Comunity,
When working with SAP ABAP ALV Grid there is a standard resource to export list results to an Excel file (save as local file: unconverted, spreadsheet, Rich text, HTML). What is happening is in Excel all values are positive, even those negative displayed in the ALV Grid. Do not matter which option is used (HTML, Rich text, unconverted) all of them do not show negative values. More: when trying to use the Microsoft Excel option (not saving as local file, directly calling via Excel button in the ALV Grid) no results are showed in the Excel sheet displayed, only blank tabs Format, Tabs, Pivot, Sub1...Sub10, RawData and RawHeader.
My SAP version is 5.0 This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
__.____._ What SAP table are you getting the information from?
Cheers
John
From: RBVaccaro via sap-dev [mailto:sap-dev@groups.ittoolbox.com]
Sent: Tuesday, May 11, 2010 2:31 PM
To: Louk, John
Subject: [sap-dev] ALV Grid exporting to Excel - negative values are exported as positive
Posted by RBVaccaro
on May 11 at 2:29 PM
Dear SAP Comunity,
When working with SAP ABAP ALV Grid there is a standard resource to export list results to an Excel file (save as local file: unconverted, spreadsheet, Rich text, HTML). What is happening is in Excel all values are positive, even those negative displayed in the ALV Grid. Do not matter which option is used (HTML, Rich text, unconverted) all of them do not show negative values. More: when trying to use the Microsoft Excel option (not saving as local file, directly calling via Excel button in the ALV Grid) no results are showed in the Excel sheet displayed, only blank tabs Format, Tabs, Pivot, Sub1...Sub10, RawData and RawHeader.
My SAP version is 5.0 This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
john.loukSAP Development Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
