[libreoffice-users] Big decimal numbers as text

2017-07-05 Thread Doug McNutt
First post was on Sat, 29 Apr 2017 17:56:37 -0400 "Big decimal numbers as text" And: Thank you for the replies last time. You helped get a bit further on. '20170428153706454600(works ok) `20170428153706454600(fails) Using menu item, insert-special character U+60 nope U+27 nope with exception

[libreoffice-users] Big decimal numbers as text

2017-04-29 Thread Doug McNutt
I'm having a problem, once again, for copy and paste from US Bank downloads into my spreadsheet which was initially created in Excel 5 or so. It's running on Ubuntu which I was just told needs a newer version than the dot 10 that I'm running. Interoffice stuff was reloaded a few weeks ago and

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

2017-03-26 Thread Doug McNutt
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

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

2017-03-26 Thread 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/1703/29/17EPMTp$330.65COMMPair Networks The first two

Re: [libreoffice-users] How to delete ~/.config/libreoffice/

2017-02-28 Thread Doug McNutt
In ubuntu and all Apple systems there is a "Files" or other option which will allow you to drag icons representing files into places like "trash". Files starting with a dot as does ".config" are not visible until you find a button to "show all". When you find the directory .config open it up

[libreoffice-users] Working with PDF docs that have data fields

2017-02-22 Thread Doug McNutt
Previous usage does not seem helpful but .. Then, when you export the PDF, make sure the "Create PDF form" option is selected on the "General" tab. 10/17/2016 12:44 PM, Ken Springer What I want to do is mess with the "data" file in the way Adobe does it. It's US tax forms and in the past they

[libreoffice-users] Clean old things from Excel

2016-12-01 Thread Doug McNutt
I have managed to move my finance workbook from a CY 2001 version of Excel to libre-office-calc. I had a lot to learn and I'm still frustrated when I want to insert a few lines of entries from the bank. It's a pain having to do a separate entry of the number of lines and then paste in

[libreoffice-users] Clean old things from Excel

2016-12-01 Thread Doug McNutt
I have managed to move my finance workbook from a CY 2001 version of Excel to libre-office-calc. I had a lot to learn and I'm still frustrated when I want to insert a few lines of entries from the bank. It's a pain having to do a separate entry of the number of lines and then paste in

Re: [libreoffice-users] Master Document Chapters Auto-numbering

2016-10-16 Thread Doug McNutt
The problem of counting has been a pain of my life. As a mathematics and physics student I learned that there are two kinds of numbers: Cardinals include a zero, decimal points, and negatives. If you want the length of a fence you had better start counting posts with number zero. The common

Re: [libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

2016-10-13 Thread Doug McNutt
What I have learned: Most important: Brian is very helpful. Thank you. Dates are really floating point numbers and the unit is one day. Somewhere there must be a way of setting the zero point. 1900, 1904, 1970 are common. My startup worksheet came from an old, 2001, Apple version of Excel

[libreoffice-users] Re: Apostrophe prepended to MM/DD/YYYY

2016-10-06 Thread Doug McNutt
"Trial of Libre Office" was not the correct place. Please excuse me. Brian Barker had some things to say about it and he did offer some help which I appreciate. I did use the prefix "Open". openSCAD is what I was working with earlier and I mistakenly started typing "opencalc". Everything I'm

Re: [libreoffice-users] Re: Trial of LibreOffice

2016-10-05 Thread Doug McNutt
I'm not sure this thread is about my problems but the title sure fits. I have had some real problems with what used to be an Excel 2001 spreadsheet running on a Mac 8500 with which I am now having hardware problems. I am also using Linux these days and I find it a real release from the likes