https://bugs.documentfoundation.org/show_bug.cgi?id=155384
--- Comment #9 from Pierre Fortin <[email protected]> --- 1. my first attachment was the wrong file -- no idea how that happened since that was not a file I had open. 2. sample file 2 is correct. 3. I know how to use fixed width; the issue is that fixed width does not work correctly if there are >= N (unknown to me) rows that *appear* to imply that ALL data is like these initial N samples. 4. Try it yourself: a) to see the problem as reported: - select cell D1 - Ctrl+down-arrow - do you see digits in column D? That is the issue! b) to reproduce the problem: - select column A - Copy it - right-click on E1 or any column to the right; NOT on column A-D as they already contain data at the bottom. - Paste Special > Unformatted Text - Fixed width - set the divider line between characters 2 and 3 - Note that the sample display is only 6 characters wide - OK - check the bottom rows... is your pasted data in 2 or 3 columns? Unless this bug has been fixed, you should have "AH" in column E, 4 digits in column F, and 1 digit in column G. With a huge sample of ~1.5M rows, you would see this in the bottom rows: AH, 1234, 567 vs the expected AH, 1234567 HTH -- You are receiving this mail because: You are the assignee for the bug.
