Excel Layout changes with project build
Nobody has claimed this yet.
- 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)
All 3 files comes with the same difference. On one machine schema is part of Ignorable list, while in another it's not.
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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