I’ve got cells formatted as ‘Text’.
When I copy cells from an HTML table of text and paste them into my spreadsheet, Calc changes the formatting to ‘Number’.
I have to manually change the cell formatting back to ‘Text’.
I can get around this by copying the original material as plain text. But that loses the table html. I don’t want to lose the table html because Calc very helpfully uses it to put the html table entries in different columns. When I copy as plain text it all just copies into Calc in one lump, into one cell.
How do I make it keep my cell formatting but also copy separate html cells into separate columns?
Build ID: 420m0(Build:2)