microsoft / microsoft/AL

Excel Layout changes with project build

Open
#8,001 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

accepted
Dominant language
PowerShell
Stars
881
Forks
285
Avg merge
3d 36m
Merged PRs (30d)
1

Description

1. Describe the bug
When building a project with excel layout in it, we keep getting changes on excel layout file.

Upon closer look at the excel files (extraced xlsx with 7zip) we noticed that there differences in these files (see screenshot)

Image

All 3 files comes with the same difference. On one machine schema is part of Ignorable list, while in another it's not.

Image

2. To Reproduce
Developer A builds a project and publishes results to the shared git repository.
Developer B retrieves the changes, & builds the same project (branch) gets a change on excel Layout file.

3. Expected behavior
File should remain the same across different environments

4. Actual behavior
Excel Layout file changes when build is executed

5. Versions:

  • AL Language: 14.3.1327807 (identical on both developer machines)
  • Visual Studio Code: 1.98.2 (identical on both developer machines)
  • Business Central: "platform": "25.0.0.0", "application": "25.5.0.0",
  • List of Visual Studio Code extensions that you have installed: N/A
  • Operating System: Windows

Internal work item: AB#573512

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the project build on two Windows machines with the listed AL Language, Visual Studio Code, and Business Central versions. Extract the generated Excel layout XLSX files and compare the XML differences, especially whether schema appears in the Ignorable list. Done means identical Excel layout files are produced across environments.

Written by the indexing model from the issue text.

Assessment

Tech stack
vscode
Domain
build-system
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.