Hi team,
Skip first lines does not behave like in 5.7 and previous versions. When you skip n lines, the headers will not be on n+1 but on n+2 row. The only way to avoid this is to check the option "Do not automatically offset imported range". At least I guess it should be check by default to behave the same way. It's a big regression.
What do you think guys ?
We hear you and are looking into it.
Hi Romain,
Are you importing a sheet or a range?
Is it possible for you to share the imported file with us?
A sheet. Note that the first cells are empty. I will see what I can send you.
I compared the import behavior with and without empty first cells in versions 5.7.3 and 5.8.2, and I see no differences. Can you please also post the exact versions you were using previously and are using now, and a screenshot of the action settings including the "Advanced options..." popup?
Seems that this behaviour was already existing in 5.7.2.7. Use the excel attached. Import Feuil2 and skip the 6 first lines. I would expect that Easymorph starts to read the 7th and see there are columns Q1...Q3. But it's not. If I check "do not automatically offset imported range", it's working : Q1 Q2 and Q3 appears. Note that the checkbox is not checked by default.
Here is the good configuration.
I saved the project and it was written "previously saved in 5.6.x" can't remember x. So I think it was ok in 5.6 and not anymore after.
Classeur1.xlsx (18.3 KB)
Romain, thank you for the file. I tested the import with several older versions, back to version 3.8.0. And the behaviour with your file was the same. The "Do not automatically offset imported range" was introduced in version 3.1 and was always turned off by default.
I'm not sure that happened in your case, but the logic here is simple. By default, all the empty columns to the left and the top empty rows are ignored. But if you still would like to import those empty values, you should check the "Do not automatically offset imported range" option. There is no need to use the "Skip first lines" option to skip empty rows.
Is it possible that the file you are trying to import initially had some data in the first lines?
I understand now the option. Well it's strange because I'm absolutely sure this was working before, as I had a job perfectly working in production, and after upgrade to 5.8, it did not. As this kind of excel is very very rare (can't answer your question because it's a business file), it's not important. Thanks !
You are welcome!
