VAT worksheet copy to clipboard misalignment

Hello, I’m using the Dutch VAT worksheet option, before updating I could use “Copy to clipboard” to copy the results to excel with the columns being layout perfectly. After running the latest update data isn’t being pasted in the right columns anymore needing a lot of manual adjustment.

Can this be fixed?

Running desktop version 26.3.10.3191 on windows 11

Cloudversion 26.3.11.3195.

Works well with LibreOffice Calc using the standard paste method.

You may need to try one of the other paste options in Excel.

1 Like

Thank you for responding Ries, I tried that but sadly it makes no difference for ms excel.

However you did inspire me to try it with google sheets, there it works, so for now I can do this as an extra step.

Hello @maarten,

This is because you previously used Text to Columns feature delimited by ,.

This setting will persist whenever you paste new data, it will be split by coma.

To solve this, you need to go back to Text to Columns and uncheck the delimiters from there.

Alternaviely, you can simply restart Excel.

1 Like