Text-to-Column Vertical Shift

[gskerry]

This issue is unique.

• [x] I have used the search tool and did not find an issue describing my bug.

Operating System

macOS 10.12 or higher

Version information

8.3.1

Expected Behavior

Text-to-Column function will split cells leaving them vertically in-place (i.e. they will not change row position).

Actual Behavior

The split cells are shifted (I believe always up) to a new row. When using the undo button and then repeating the action, it interestingly behaves as expected, with no shift.

Reproduction Steps

1. Highlight full column of data to be split
2. Use text-to-column

Additional information

Screen Recording:

[gskerry]

I am getting a failure on upload of the screen recording. It is 22MB. Perhaps this is over the size limit.

Gif below appears to upload

[Dmitry-Kov]

Hello @gskerry,

I tried to reproduce your issue, but I wasn’t able to. Could you please attach the problematic file? Also, I wanted to check if you’ve updated to the latest version to see if the issue still occurs there.

[gskerry]

Hi @Dmitry-Kov, PFA sample workbook with the issue presenting.

bug-demo2.xlsx

(Confirmed still occurring in v8.3.3) Thanks.

[Dmitry-Kov]

Dear @gskerry,

I created bug 74334 for your problem. When some fixes will be done we'll text you here in this issue. Thank you for the report!

Problem can be reproduced in DocumentServer.

[gskerry]

Hi @Dmitry-Kov, Sounds good. No problem - thanks!