mibuso.com
Home› NAV Three Tier
Options

Why M.Excel automatically merge cell when save file.

sagesage Member Posts: 29
edited 2015-04-01 in NAV Three Tier
Hi,

My customer raises one issue about the report which she saves to M.Excel from PrintPreview page. When They opens it, some columns has been merged to one column and this is not what customer has expected. She wants one column excel per one column of data, doesn't want merged cell.

It's quite hard to explain. So, please see below pic.

For more information.
I didn't merge any column in Visual Studio.
NAV 2009R2.

Thank you.

Comments

  • Options
    lakshanvindanalakshanvindana Member Posts: 79
    this can happen if there is a report header/ footer.

    to avoid this kind of issue, remove header & footer of the report. (if customer going for excel means, customer do not need the header)
    Lakshan Kulawansa
    ERP Consultant - MS Dynamics NAV
    https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/592
  • Options
    sagesage Member Posts: 29
    lakshanvindana wrote:
    this can happen if there is a report header/ footer.

    to avoid this kind of issue, remove header & footer of the report. (if customer going for excel means, customer do not need the header)

    thanks youuuuuu :D
Sign In or Register to comment.