Output to Excel Creates Merged Cells preventing sort
Any way around merge cell sort issue when exporting report out to Excel that has a header section, body, and total section? Did discover that I needed to have the end of file in its own column in the body section to avoid report merging that column area and now when adding back in header and total section merge cell issue comes up again. Thanks, Rick.
GSTORE
STORE_LOC
DM
DMIT
TSM
TARGET
NON_COMP
PY_NC
MIS_CODE
12/31/99
999,999
999.0
999.9
999,999
999,999
999
999.0
999.0
999.9
999.9
999.9
999.9
999.9
999.9
999.00
999.9
999.9
999.9
999.9
999.9
999.9
999.9
999.9
999.9
999.9
9.99
9.99
99.9
99.9
99.9
99.9
E
GSTORE
STORE_LOC
DM
DMIT
TSM
TARGET
NON_COMP
PY_NC
MIS_CODE
12/31/99
999,999
999.0
999.9
999,999
999,999
999
999.0
999.0
999.9
999.9
999.9
999.9
999.9
999.9
999.00
999.9
999.9
999.9
999.9
999.9
999.9
999.9
999.9
999.9
999.9
9.99
9.99
99.9
99.9
99.9
99.9
E