AL icon indicating copy to clipboard operation
AL copied to clipboard

Excel Layout changes with project build

Open gntpet opened this issue 9 months ago • 2 comments

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

gntpet avatar Apr 02 '25 09:04 gntpet

A follow-up question, do the two developers in this scenario use the same version of the VSIX? It's likely this is a version mismatch between the two

BazookaMusic avatar Apr 08 '25 10:04 BazookaMusic

A follow-up question, do the two developers in this scenario use the same version of the VSIX? It's likely this is a version mismatch between the two

That's a first thing we checked. We compared Al extension version across multiple machines and they were identical

gntpet avatar Apr 10 '25 10:04 gntpet