Forum Discussion
"Automatically resize to fit contents" setting breaks pasting from Excel using "Merge Table"
I am seeing the issue described here: https://learn.microsoft.com/en-us/answers/questions/5432795/issue-merging-table-data-from-excel-to-word.
My workflow is:
- Copy some cells from Excel
- Click into an existing table in Word (of the same "width", ie: number of columns as copied) and paste
- Select "Merge Table" (Windows) or "Merge With Exsiting Table" (macOS)
- Rows are added to the table, with the content of the Excel cells mapped to them as desired
This worked up to 16.94. After 16.95, this process splits the existing table in two and adds a third table in between, making the first row pasted into a new header row. This weird new table will not merge with the other tables in the way an ordinary table can be merged with "Alt + Shift + Up".
I've tracked down that this issue does not occur if "Automatically resize to fit contents" is ON. If it's off (as in our templates), the table splits into three when "merging"!
(I've tried several times to post this to Microsoft Q&A, but I keep running into errors. To be honest I'm now thoroughly confused about which forum a general customer is allowed to be on and use…)
3 Replies
- auximenesCopper Contributor
Thank you for doing that. The issue is not yet fixed, as of 16.103.1 – macOS – and Version 2510 (Build 19328.20190 Click-to-Run) – Windows.
- auximenesCopper Contributor
A version of this popped up with an answer on https://learn.microsoft.com/en-us/answers/a/12184532 but then disappeared again for "violating the code of conduct" or something. Not worth trying to ask for help now is it, if a bot can just delete you without explanation!
Allegedly this is a "known issue" despite not appearing in any searches and is supposedly fixed in 16.99. However, in 16.100 it isn't fixed and trying to join the tables back together using the arrow key shortcuts exhibits unpredictable behaviour.
The spam filter in the Q&A forum is aggressive. I have restored the thread at https://learn.microsoft.com/en-us/answers/questions/5522483/ , if that helps.