Re: [libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

At 14:56 26/03/2017 -0400, Doug McNutt wrote: Wow. The Sunday response is warmly appreciated. No probs! I'm going to change the fixed width to "tab separated". As advised. Good. There is also something called "text delimiter" ... If your input data had text which looked like numbers

Re: [libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

Wow. The Sunday response is warmly appreciated. Re-copying from the spreadsheet into gedit 03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular 03/24/1703/24/17EPMTp$159.64HOUSWaste Management 03/24/1703/29/17EPMTp$330.65

Re: [libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

Hi, I tried your example with the Fedora text editor and I was able to reproduce the behaviour you are describing. The way out is to tell Calc what type of data you have in the columns before you hit the "OK" button of the import panel. To do so, make sure the arrows are placed at the right place

Re: [libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

At 11:50 26/03/2017 -0400, Doug McNutt wrote: Here are three lines copied from a LibreOffice Calc page 03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular 03/24/1703/24/17EPMTp$159.64HOUSWaste Management 03/24/1703/29/17EPMTp

Re: [libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

2017-03-26 17:50 GMT+02:00 Doug McNutt : > Here are three lines copied from a LibreOffice Calc page > 03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular > 03/24/1703/24/17EPMTp$159.64HOUSWaste > Management > 03/24/17

[libreoffice-users] Mixing LibreOffice Calc formats with ASCII text

Here are three lines copied from a LibreOffice Calc page 03/24/1703/24/17EPMTp$16.96COMM Consumer Cellular 03/24/1703/24/17EPMTp$159.64HOUSWaste Management 03/24/1703/29/17EPMTp$330.65COMMPair Networks The first two