Intermittent issues on our Blogging System

Due to unforeseen circumstances, we are experiencing some intermittent issues with our Blogging system , we apologize for the inconvenience and are working hard to rectify the situation.

Jul 23, 2010 at 03:07 AM
# OLE: export quantity with decimals according to UoM

Dear Guru,

I encounter a problem when exporting data from Itab to Excel using OLE.

In the itab, there are many Quantity fields (with UoM). When I export to Excel, I want the number of decimals of each quantity field must comply with UoM (for ex: PC with 0 decimal, Kgs with 3 decimals).

I try to write the qty to text, it's ok but I also need the exporting qty is formatted as a number in Excel so user can do a sum.

The solution for this problem seems complicated. I have to write qty to text, convert text to number...But for a large number of data, it is really slow.

Is there anybody encounter the same problem? Please advice the solution.

Thanks.