Re: [libreoffice-users] Big decimal numbers as text
At 20:34 05/07/2017 -0400, Doug McNutt wrote: 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. I see only one previous (public) reply, very probably because you hijacked another thread, so anyone not reading that thread would not have seen your plea. '20170428153706454600(works ok) `20170428153706454600(fails) Er, exactly: what you need is a plain, unvarnished typewriter apostrophe - nothing else will do. Using menu item, insert-special character Aaargh! The easiest way to get an "X" is to type it on the keyboard. The easiest way to get a "7" is to type it on the keyboard. The easiest way to get a "$" is to type it on the keyboard. The easiest way to get a plain, unvarnished typewriter apostrophe is to type it on the keyboard. That seems to work but it sometimes doesn't. The only reason this might not work is if you have LibreOffice set to replace single quotes (apostrophes) with smart quotes. If that is the problem, either: o Go to Tools | AutoCorrect Options... | Localized Options | Single quotes, and remove the tick from Replace (perhaps temporarily), or o Go to Edit | Undo (or Ctrl+Z) immediately after typing the apostrophe to remove the automatic "correction". If I choose a cell and declare its format to be Number-Scientific, ... Your problem is that you are handling something that looks like a number but is actually (to you) a text string. Telling Calc that you want it handled as a number is asking for trouble. Why would you do that? I don't see any way to declare a cell as number, 63 bit binary integer with leading sign. Again, this is not what you want. Rereading your original query, I see that you are trying to enter long strings of digits that look like numbers (as your example above) but which you want handled *as text*. Stop trying to tell Calc that you want them seen as numbers! I suspect that LibreOffice does what Excel does; all numbers use IEEE floating point. This is irrelevant: you are handling text, not numbers. (Did I mention that?) My recommendation for repair is to remove the possibility of space characters being introduced anywhere. I'm not sure what you think need repairing. As to space characters, am I not to be able to enter "Doug McNutt" into a cell - with its helpful space? Am I not to be able to enter a telephone number, also appropriately spaced? Some thoughts: 1. Think of your example value above: 20170428153706454600. Is there any sense in which this means to you (or your bank) twenty quintillion, one hundred and seventy quadrillion, four hundred and twenty-eight trillion, one hundred and fifty three billion, seven hundred and six million, four hundred and fifty-four thousand, six hundred? Surely not (or are you richer than I imagine?). If you don't believe me, tell me what it would mean if the next label the bank provided was exactly half this? That is the sort of question you can ask about numbers, but not about text. These are text strings that just happen to be formed of digits. 2. You say previous replies helped, but you make no reference to what happened when you tried the advice to format the cells as Text before entering values. 3. You say previous replies helped, but you make no reference to what happened when you tried the advice to use Edit | Paste Special... (or Ctrl+Shift+V) instead of ordinary Paste. 4. Instead of using copy and paste at all, save the source text first as a plain text (.txt or .csv) file and use Insert | Sheet From File... to browse to and import the data. The Text Import window provides a very flexible system for getting data into Calc the way you need it - even including being able to set the "Column type" to Text. (Oh, *please* use Text for these strings of digits.) The new data will appear on a new sheet, but it is a simple task to move it to an existing sheet (probably using ordinary Paste this time). I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Big decimal numbers as text
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 U+B4 nope U+2BC nope U+384 nope U+1FBD nope U+1FBF nope U+2018 nope U+2019 nope U+27 seems to be an 8 bit byte but really is 0027 requiring two bytes. I get 27 (hex, 1 byte) using the lower case of the quote mark, ", on my keyboard. That seems to work but it sometimes doesn't. What has been reliable is when I perform a simple copy from a row that has worked in the past and paste a copy into the the cell where I want the new text string which happens to be all decimal digits. I can then open the new cell displaying the old data and the magic prefix. Now I can very carefully select only the digits, 19(10) of them, and attempt to replace the old digits with the new. The worksheet thinks it knows better and adds space characters where I don't want them. One is at the end of the line of digits and seems to be treated as a carriage return when the cell is closed to editing. If I use the mouse to cut everything after the digits even though I can't see the characters I can get what I want when I save. That's why the cell seems to push the digits into what looks like the cell above. It's just trying to add a new line to the top of the cell which doesn't have any vertical space available. Sometimes the paste from a GEDIT window acquires yet another space at the beginning of the line of digits. It does not show in the test file but, if you're not very careful, will somehow absorb the 27(hex) and you see the digits but the procedure won't work the second time. You have to remove the space without disturbing the initial character. That is hard to do if the mouse is dirty. If I choose a cell and declare its format to be Number-Scientific, I copy my string of characters taken as a text string. The cell has been declared to be a number but the system or the spreadsheet recognizes the non numeric character and treat the paste as a string. If I remove the first character the copy displays 2.01706241556575E+019 which is the result of a transform into IEEE floating point. It's wrong because the floating point has a limit of accuracy approximately 14 decimal digits, 52 bits. I don't see any way to declare a cell as number, 63 bit binary integer with leading sign. I suspect that LibreOffice does what Excel does; all numbers use IEEE floating point. (Sometimes I think that also applies to counters controlling a loop.) There still seems to be a problem that I haven't figured out: Take a working cell with 19 digits and the special symbol present. Open it up as if to be edited. Place a space between the special symbol and the first digit. Close the cell. The funny symbol U+27 is no longer recognized as a keep-out symbol but the space is removed and the symbol displays, on this Ubuntu box, as a lower case quote mark. My recommendation for repair is to remove the possibility of space characters being introduced anywhere. Do others have problems with that? Is the spreadsheet trying to use features written for writing a book? Is the spreadsheet trying too hard to use 16 bit super-bytes to support non-Latin characters? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base
On 07/05/2017 02:14 AM, Alexander Thurgood wrote: Le 05/07/2017 à 01:20, Girvin Herr a écrit : Hi Girvin, Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try to log in to Mariadb to access my database, LO crashes hard. This worked fine in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java config under Options and it is fine. I tried deleting the profile directory and starting from scratch. It still crashed. LO also crashes when I use the "Test Connection" button in the database configuration dialog to try to log in to Mariadb. Any ideas before I return to 5.1.6? Could be several things, although off the cuff, LO5.2.x was known to crash in certain circumstances with JDKu112, so either: - revert back to LO5.1.x or else - try updating your JDK to a much more recent one and see if that makes a difference with LO5.2.x, or else - move to LO5.3.x and a current JDK. Why do I mention a Java problem ? Because the devs changed the version number recognition pattern for JDK/JVM instantiation somewhere between 5.1 and 5.2, and this is what caused crashing for some. This was fixed in 5.3. Of course, it could all be specific to your Slackware setup... Alex Alex, Thanks for your prompt response. I have been working on this problem all morning. I first upgraded jdk-8u112 with jdk-8u131 with the same results. I then tried LO 5.2.7.2 with the same results. I then tried LO 5.3.4.2 with the same results. I then upgraded the MySQL Connector from 5.1.40 to 5.1.42 with the same results. Nothing I do seems to affect whatever is causing LO to crash. I also started LO from a console to see if LO spit out any pertinent messages when it crashed - none. Whatever is happening here, it is broad. I even tried to use my OpenOffice Base odb file with the same LO results. Now this file works fine in AOO. There are two datapoints I had not thought of when I posted my message yesterday. One is that I successfully edited and printed a report on 6/19/17 with LO 5.2.6.2. So, it was working at that time. The other is that I upgraded glibc from version 2.23 build 1 to 2.23 build 2 yesterday, before I noticed LO crashing. But I tried returning to the old glibc version and LO still crashed, so I doubt glibc was the cause. The other Slackware packages that I changed yesterday are: bind, irssi, mozilla-firefox, openvpn, sudo, the Linux kernel, httpd, libcgroup, libcrypt, mkinitrd, mozilla-thunderbird, nasm, and pkg-config. None of these should have affected LO, but... There is something else going on besides Base crashing. I was checking the "Tools" | "Options" with nothing loaded and when I got to the bottom item, "Internet" | "MediaWiki", LO crashed when I selected it. I wasn't even close to MySQL or Base at the time. BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux and Java, 8GB RAM, and 10% of 1TB disk space used. So it shouldn't be a lack of resources. Besides, as I said, OpenOffice is still running fine. My problem with using AOO, is that it does not have the Base Report Generator I need to print my reports. Hope this helps narrow this problem down. I am about to issue a bug report on this. It is certainly repeatable, if frustrating. Thanks. Girvin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base
Le 05/07/2017 à 01:20, Girvin Herr a écrit : Hi Girvin, > Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try to log > in to Mariadb to access my database, LO crashes hard. This worked fine > in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java > config under Options and it is fine. I tried deleting the profile > directory and starting from scratch. It still crashed. LO also crashes > when I use the "Test Connection" button in the database configuration > dialog to try to log in to Mariadb. > > Any ideas before I return to 5.1.6? Could be several things, although off the cuff, LO5.2.x was known to crash in certain circumstances with JDKu112, so either: - revert back to LO5.1.x or else - try updating your JDK to a much more recent one and see if that makes a difference with LO5.2.x, or else - move to LO5.3.x and a current JDK. Why do I mention a Java problem ? Because the devs changed the version number recognition pattern for JDK/JVM instantiation somewhere between 5.1 and 5.2, and this is what caused crashing for some. This was fixed in 5.3. Of course, it could all be specific to your Slackware setup... Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted