Re: Spreadsheet problem
Forwarding reply to users list Sent from my iPhone > On Apr 25, 2019, at 7:19 PM, Dee Thompson wrote: > > What version of Apache OpenOffice are you using? 4.1.6 > > What operating system (OS) are you using? Windows 10 > > What version of the OS are you using? Windows 10 version 1803 > > How big is the file of your spreadsheet? 2949Kb > > How much RAM does your computer have? 6 Gb > > Please respond to the users list so that we can assist you. > > I hope I got all this correct. > > Dee > > >> On Thu, Apr 25, 2019 at 8:39 PM Steven Ahlers wrote: >> Dee, >> >> What version of Apache OpenOffice are you using? >> >> What operating system (OS) are you using? >> >> What version of the OS are you using? >> >> How big is the file of your spreadsheet? >> >> How much RAM does your computer have? >> >> Please respond to the users list so that we can assist you. >> >> Steve >> >> > On Apr 25, 2019, at 2:08 PM, Dee Thompson wrote: >> > >> > I have a ongoing problem with one of my spreadsheets crashing quite >> > frequently. Usually this happens when I go to save the document (which I do >> > frequently as it crashes so often). When the software goes through the >> > recovery process my data is OK at the point of the last save. Sometimes I >> > save after each line I have entered to avoid having to enter the data >> > again. I usually have two documents open at open as their data is related >> > to each other. >> > >> > Do you have a suggestion about this issue? I would appreciate your help. >> > >> > Dee Thompson
Re: Spreadsheet problem
Dee, What version of Apache OpenOffice are you using? What operating system (OS) are you using? What version of the OS are you using? How big is the file of your spreadsheet? How much RAM does your computer have? Please respond to the users list so that we can assist you. Steve > On Apr 25, 2019, at 2:08 PM, Dee Thompson wrote: > > I have a ongoing problem with one of my spreadsheets crashing quite > frequently. Usually this happens when I go to save the document (which I do > frequently as it crashes so often). When the software goes through the > recovery process my data is OK at the point of the last save. Sometimes I > save after each line I have entered to avoid having to enter the data > again. I usually have two documents open at open as their data is related > to each other. > > Do you have a suggestion about this issue? I would appreciate your help. > > Dee Thompson - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Spreadsheet problem
I have a ongoing problem with one of my spreadsheets crashing quite frequently. Usually this happens when I go to save the document (which I do frequently as it crashes so often). When the software goes through the recovery process my data is OK at the point of the last save. Sometimes I save after each line I have entered to avoid having to enter the data again. I usually have two documents open at open as their data is related to each other. Do you have a suggestion about this issue? I would appreciate your help. Dee Thompson
Re: [Spreadsheet] problem
At 16:54 29/05/2015 +0300, Algis Noname wrote: I found a mistake. See file in the attachment. There is no mistake - apart from in your understanding of what is happening. Numbers are stored in computer in binary form, so what looks like a precise number that terminates - such as your two numbers in A1 and B1 - will not necessarily be stored exactly. When you subtract these values in C1, the difference is stored as very slightly different from the rounded value you see in the display. You can confirm this by setting the cell formatting to show more fractional places. If I do that, I see -196.8098 in C1. If you add exactly 196.81 to that, you will not get exactly zero but the value you see (correctly!) displayed in C3. Numbers will be stored in your computer as 64-bit floating-point numbers. The significant part of the numbers occupies 53 of those bits, so they have precision to 53 binary digits, which corresponds to about fifteen decimal digits. You will see that the difference value above differs from the exact result at the fifteenth digit in the number. You should take account of such rounding errors when designing your spreadsheets. There are workarounds: o Format C3 to show a suitable number (perhaps 2) of fractional places. You will see the displayed value rounded to zero. o Go to Tools | Options... | OpenOffice Calc | Calculate and tick Precision as shown. Now change the cell formatting of C1 to have an explicit value for Decimal places (say 2), rather than relying on the General format you were using. Now you will see zero in C3 (and in G1). But beware of genuinely incorrect values created by rounding errors that you will see if you do this. Incidentally, this matter has no connection with (Microsoft) Excel, as your subject header suggests: you are handling a spreadsheet document in the Calc component of Apache OpenOffice. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Spreadsheet Problem
Hi, I don't seem to be able to complete the attached spreadsheet. Whatever I try to enter in the mileage column gives me the box saying If this is your first claim etc Any ideas? 2013 Volunteer expense claim form V2.7.xls Description: MS-Excel spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Spreadsheet Problem
Sorry Gary, The spreadsheet is locked, therefore nobody can help without the password. Unless you have a password none of the cells will register, perhaps that is the problem. I assume you didn't create this spreadsheet form, so you need a password. Take Care. Scooter College Park, MD USA Gary Jackson wrote on 1/26/2015 9:09 AM: Hi, I don't seem to be able to complete the attached spreadsheet. Whatever I try to enter in the mileage column gives me the box saying If this is your first claim etc Any ideas? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
RE: Spreadsheet Problem
I opened the document in Excel 2013 to see exactly what protections were in effect. The first thing that happened (after enabling editing of a file from the Internet), was that Macros were disabled. I did not enable macros, just to see what I could do without them. I was then able to make entries in mileage and mileage-rate cells. When I attempted to change a caption, I was told that cell was protected. I did not see the warning that occurs when the file is opened in either Apache OpenOffice or LibreOffice. In both LibreOffice and Apache OpenOffice I see the same message that Gary is reporting. I also saw a macro warning and I did not allow macros to be enabled. I did what the message says, but the message is repeated if I attempt to enter any mileage greater than 0.01 in any row of the sheet. When I saved the document, I received warnings about the output format and then when I said I wanted .xsl anyhow, the save was reported as unable to preserve all macros. Both LibreOffice and ApacheOpenOffice recognize that some cells are protected and some are not. The validation message about first-time use, etc. is apparently not related to protection. There is some other incompatibility involved. - Dennis PS: For any follow-up, please reply to users @ openoffice.apache.org where other experts may have advice and others can learn the solutions to common problems. The OpenOffice Forums have an extensive knowledge base at https://forum.openoffice.org/ as well. PPS: I also uploaded the .xslx file to OneDrive to see if it could be edited in a browser. Unfortunately, no. The Microsoft Office Web App reported that the file could not be opened on the web and that I would need Office on my computer (which I do have, as already reported) to work with the file. I suspect that has to do with the protections and possibly the macros used on the document. (I was able to open the file in OneDrive on my old-model Windows Phone, but I could not edit it there.) -Original Message- From: Scooter [mailto:st...@scootersdesk.com] Sent: Monday, January 26, 2015 06:50 To: users@openoffice.apache.org Subject: Re: Spreadsheet Problem Sorry Gary, The spreadsheet is locked, therefore nobody can help without the password. Unless you have a password none of the cells will register, perhaps that is the problem. I assume you didn't create this spreadsheet form, so you need a password. Take Care. Scooter College Park, MD USA Gary Jackson wrote on 1/26/2015 9:09 AM: Hi, I don't seem to be able to complete the attached spreadsheet. Whatever I try to enter in the mileage column gives me the box saying If this is your first claim etc Any ideas? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Spreadsheet Problem
At 14:09 26/01/2015 +, Gary Jackson wrote: I don't seem to be able to complete the attached spreadsheet. Whatever I try to enter in the mileage column gives me the box saying If this is your first claim etc. Any ideas? Here's a potential workaround: o Open the spreadsheet in OpenOffice (Calc). o Go to File | Save As..., select ODF Spreadsheet (.ods) for Save as type and save in OpenOffice's native format. o In the Re-type Password dialogue, click Re-type for Volunteer Form (the visible sheet). o In the further Re-type Password dialogue, select Remove password from this protected item. o Click OK and OK. o Close the new file. o Reopen the new file. o Populate the spreadsheet. o If desired, save the document back as .xls for submission. The document appearance is likely to be similar to what is expected, but there are no guarantees as to the hidden functionality. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
spreadsheet problem
Hello, I use the open office spreadsheet for work. Today I went to the data tab, hit the sort tab, column A, ascending…then ok (or whatever is says to begin the process). I have certain rows highlighted, when I sorted the spreadsheet, the columns were still highlighted, but all the data was gone! Help! I use this spreadsheet for work. It has all of my clients names, contact info and notes listed! How do I retrieve this information? Thank you Tana McColl 910-987-6654
Re: spreadsheet problem
Hopefully, you did not save it after sorting . . . Did you try Edit, Undo? Tana McColl wrote: Hello, I use the open office spreadsheet for work. Today I went to the data tab, hit the sort tab, column A, ascending…then ok (or whatever is says to begin the process). I have certain rows highlighted, when I sorted the spreadsheet, the columns were still highlighted, but all the data was gone! Help! I use this spreadsheet for work. It has all of my clients names, contact info and notes listed! How do I retrieve this information? Thank you Tana McColl 910-987-6654
Re: spreadsheet problem
If you closed without saving, the original pre-sorted file should be available . . . rather than close the spreadsheet, try to open a second copy of it (read only message will appear). Hopefully, your information will be there - just save the read only with a new file name. As for backup, go to OpenOffice Help - OpenOffice Calc, find. Search term: Backup. Hope these suggestions help . . . Tana McColl wrote: i’m not sure if I hit the save button or not. I did try the edit undo and was unable to undo it. Isnt there an automatic back up in openoffice? *From:* Tubular mailto:tubu...@iinet.com *Sent:* Monday, March 31, 2014 1:37 PM *To:* users@openoffice.apache.org mailto:users@openoffice.apache.org, Tana McColl mailto:tana...@outlook.com Hopefully, you did not save it after sorting . . . Did you try Edit, Undo? Tana McColl wrote: Hello, I use the open office spreadsheet for work. Today I went to the data tab, hit the sort tab, column A, ascending…then ok (or whatever is says to begin the process). I have certain rows highlighted, when I sorted the spreadsheet, the columns were still highlighted, but all the data was gone! Help! I use this spreadsheet for work. It has all of my clients names, contact info and notes listed! How do I retrieve this information? Thank you Tana McColl 910-987-6654