Snapshot release 11-Nov-21

News
1

This snapshot release:

  • Fixes a crash bug and some issues related to cascading column changes in the 08-Nov-21 snapshot.
  • There is now an ignore empty columns option when inputting from file or clipboard.
  • Additional Is empty and Is not empty matches are now available in the Filter, If, New Rows and Slice transforms.
  • Fixed a bug where no header was written to empty Excel sheets when write header and if empty were checked in the Right pane for the output item.
  • Fixed a bug where delimited text files without a final carriage return could show a spurious “Number of values per row vary” warning.

This is in addition to the other changes listed at Snapshot release 08-Nov-21 .

You can download and install this snapshot release using these links:

You can install this release over the top of it the 08-Nov-21 snapshot, if you have installed it.

This snapshot is made available for customers to give feedback on. It has not been tested as fully as a production release, but it should be fairly stable. Please reply to this thread if you have any feedback.

2

I have noticed something. But does not know if it is only in the snapshot.
XLSX Output.transform (12.6 KB)
In this transform on my macOS machine, then specialcharacters when outputting to XLSX is messed up.
But in XLS they are correct.

Microsoft Excel-output(6).xls - Skrivebeskyttet - Kompatibilitetstilstand 2021-11-12 at 13.01.45
Microsoft Excel-output(6).xls - Skrivebeskyttet - Kompatibilitetstilstand 2021-11-12 at 13.01.451068×638 230 KB

3

@jimmyhartington Thanks for reporting this.

There is a known issue with writing Arabic to Excel on Mac, using Overwrite/Sheet or Append mode, which I can replicate here.

But I haven’t been able to replicate your issue, so far. What version of Excel do you have?

2021-11-12_12-30-05
2021-11-12_12-30-051378×918 192 KB

4

Excel is version 16.56

Microsoft Excel-Om Excel 2021-11-12 at 14.26.59
Microsoft Excel-Om Excel 2021-11-12 at 14.26.59482×579 36.3 KB

5

I’ve got 16.43 here. I will try updating.

6

Also seems to work fine with Excel 16.54. I wonder what is different on your machine?

7

Also tried your example .transform with Excel 16.54 on a different Mac. Still coudn’t reproduce the problem.

Can anyone else reproduce this on Mac?

8

I have created this very simple package with a transform, which also shows the error.

Microsoft Excel-Input 2021-11-13 at 21.00.30
Microsoft Excel-Input 2021-11-13 at 21.00.301000×487 77.8 KB

My system is set to Danish. I do not know if that has anything to do with this.
But I am willing to test stuff, if we find out in which area we should look.