Re: [users] Format error in Calc
Brian, Thank you for the clear and detailed response to my query. Even when I do not need the information you supply it is informative, giving insight to the workings of OOo. Exactly! Try this: o Take a copy of your document, so that you don't destroy the original. o Rename the file to change its extension from .ods to .zip. o Double-click the .zip file to get Windows to unzip it. o Open the content.xml file you will find in the archive using a plain text editor. o Experiment with editing the file to see if you can find and perhaps delete the part containing the error. I followed your suggestion to this point of opening the .xml file with the text editor, but that was way over my head. It contained 30 rows of 1024 columns and the 31st had 600 and a few. The message said the error was at 2,31029(row, col). One thought was row 23 column 1029, but they only went to 1024. So possibly row 24 column 5. That did not seem right or look promising. Or row 2 and count 31029 from there. I haven't looked there yet. Note that anything that you get will not be reliable, and you will have to check it thoroughly. You may get some data, but you would probably have to create any formulae anew if they were to be relied upon. Of course, the quicker method is probably to go back to your most recent back-up copy of the file and repeat your work from there. Er, you do keep back-ups? I trust this helps. I did have a back up file, which I accidentally deleted. However, today on the way home from work I remembered a program that recovers deleted files. Which I downloaded, installed and the program was running while I was working through your suggestion. The first time it did not recover the file. It had a deep search feature which turned up more files that had only numbers for names. Scanning them I remembered most of my files are .odt whereas the file I needed was .ods. First one I found was a working copy of the deleted file. Again, thank you for the assistance. I may play around with your suggestion, when I have some time. Julio Sotolongo - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Format error in Calc
I have a file in Calc which I created and have used to input information since June 1, 2009. Yesterday when opening it this error message appeared: Format error discovered in the file in sub-document content.xml at 2, 31029 (row, col). Clicking OK or closing the error both result in the file not loading. Is there a way of opening the file, even with the problem, or perhaps repairing the file? I tried using Draw to open the file, but the same message appeared. Nothing turned up in a search on OpenOffice. My computer is running XP sp3. The version of OOo is 3.2.0. Thank you for your assistance. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Another wrinkle on the subject of Unsubscribing
Greetings, I also have gotten multiple messages from Steven, but now multiple messages have appeared from other users as well. Two copies of Character color in WP documents from John Jason Jordon. These show different times 1:50 PM and 2:03 PM on August 30. Then at 5:10 PM seven copies from Harold Fuchs with subject: Open Office query. Then 5:28 PM five messages from John Gregson with subject: Base column Width. Next at 5:42 PM five messages from Harold Fuchs with subject: Not possible to unsubscribe me. Followed by three copies from Barbara Duprey with the subject: users Digest 29... all delivered at 5:54 PM. Also at 5:54 PM from Brian Barker three copies of Base import from Works. Has anyone else seen this? Perhaps more than just the actions of one person, maybe a brief glitch. Julio Andy wrote: Steven, I think I am starting to see a pattern here.. This address is sending three and more copies of the messages to the list.. That sounds like a good reason to block it from sending to the list.. Back in Fido that would get your echo mail cut off till you proved the problem was fixed.. Steven P. Ulrick wrote: Hello Everyone I must start by saying that I do want to be subscribed to this list. This message is only about my attempts at unsubscribing one particular address. Here we go: I run Fedora Linux on my computer, and I wanted to subscribe to users@openoffice.org from an alias that is delivered to a real user account. The alias is listsopenoffice...@afolkey2.net and it is delivered to the user account steve I have just checked my /etc/aliases file to make sure that listsopenofficeorg is still delivered to steve and I found the following: lists-openofficeorg:steve That is backed up by the fact that for the first time in a long time, I actually saw a message sent from listsopenoffice...@afolkey2.net arrive on this list. users@openoffice.org accepted my subscription request from the listsopenoffice...@afolkey2.net address. For a while (I don't know how long,) everything worked fine. I received all the email from this list, and I was able to send messages to the list. I have continued to receive messages from this list, but at some point my messages sent from my listsopenoffice...@afolkey2.net address ceased arriving on the list. In other words, I was RECEIVING mail from users@openoffice.org but I could not SEND mail... So I signed up for this list under the address st...@afolkey2.net. This has worked perfectly for sending and receiving. Then I tried to unsubscribe listsopenoffice...@afolkey2.net. Guess what? I NEVER received a confirmation to reply to. So, my address was subscribed enough to continue to receive messages from the list, but not subscribed enough to get an email through TO the correct address to get unsubscribed. Not the end of the world, mind you, but it is annoying. But tonight I sent a message to users@openoffice.org as as test FROM listsopenoffice...@afolkey2.net. It ARRIVED! Before I started this message, I attempted to unsubscribe listsopenoffice...@afolkey2.net again. I'm going to check right now and see if I got a confirmation yet... Well, nothing yet :( In closing, despite what some people on the list in question might think, it does appear to be possible to: 1. Subscribe to the list. 2. Receive mail from the list. 3. But not be able to send mail TO the list. 4. And also not be able to send a unsubscribe request TO users- unsubscr...@openoffice.org Hopefully I'll be able to unsubscribe listsopenoffice...@afolkey2.net from this list real soon, and just have one address subscribed to this list... Steven P. Ulrick - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Draw: perfectly straight line
Twayne, Good points, I'm reasonably certain my friend was using the same computer for both programs, but have not seen them on his computer. I did not get a good understanding, but said he was using something akin to Draw to add a line in an Excel program or possibly a table. I have read here that MSO does not have an equivalent to Draw. I am not sure just what he was using. I do not have MSO and only saw how OOo displayed on my relatively old monitor. It is a Compaq 7500. I got it used. I keep my drivers up to date. My video card is a nVidia GeForce 6100 GPU. I tried the suggestion of printing the line which on the monitor appeared to be short straight segments that were not connected. This same line printed nice and straight. Evidently he saw a difference how the two programs displayed. To use his words, it was driving him crazy. In some manner, he said he could 'snap' the line on MSO and it would be straight. By the time I came back with the information about displayed line on the monitor and printed line he had purchased a copy of MSO and uninstalled OOo. Anyway I have learned a few things and I mentioned that he could have both programs on his computer with no problem. Maybe he will give OOo another try. Thanks for the suggestion. I tried it, but still the result is segments of straight lines, not continuously straight from end to end. James Knott wrote: Julio Sotolongo wrote: Is there a way to create a perfectly straight line in Draw. This is for a friend that I am trying to interest in OOo. I tried unsuccessfully to accomplish it and then searched the documentation for help. Following the directions in the Draw Guide for drawing a straight line yielded the same results I achieved on my own. A line composed of segments of straight lines, but not continuously straight from end to end. According to my friend, this is possible MSO. It seems like it should be simple to accomplish. Any help would be appreciated. Have you tried the Lines and Arrows button? No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.19/1854 - Release Date: 12/17/2008 7:21 PM Julio, Not to detract from anything James Knott said, here's a different take on it: Is it possible this is a display issue? When you say MSO does it fine and OOo doesn't, is that being done on the same exact physical machine, or on two machines? If it's all on the same machine, then the rest of this is moot and you can quit readingg. If it's on two different machines, and if the line isn't perfectly vertical or horizontal, then it may look jagged as you seem to describe. This can be attributed to differences in video card settings, program settings and probably other areas I'm not thinking of right now. The higher the screen resolution, the smoother a line will look. The lower the resolution, the more jagged it'll look. Same thing at print time. And especially true with jpeg files. And if it's smooth but just not straight as in not vertical or not horizontal, it could even be the rotations settings on the video drivers or the monitor. There are more too, but before I seem to appear to be talking down to you, I'll stop here and wait for confirmation or further clarifications. HTH Twayne - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.19/1857 - Release Date: 12/19/2008 10:09 AM - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Draw: perfectly straight line
The only thing I can think of to say is cool. 8-) Julio NoOp wrote: I just tested with WinXP MSO 2002 and OOo 3.0 and I see what your friend is talking about. On MSO, a diagonal line will appear jagged (stairstep effect) in the draw box until the mouse is released. As soon as the mouse is released the line appears perfectly smooth - even when viewed at 500%. In OOo the line renders in stairstep (minor, but still noticeable). That's on a .24pixel professional quality monitor and also tested on a two other systems w/like monitors. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Draw: perfectly straight line
Is there a way to create a perfectly straight line in Draw. This is for a friend that I am trying to interest in OOo. I tried unsuccessfully to accomplish it and then searched the documentation for help. Following the directions in the Draw Guide for drawing a straight line yielded the same results I achieved on my own. A line composed of segments of straight lines, but not continuously straight from end to end. According to my friend, this is possible MSO. It seems like it should be simple to accomplish. Any help would be appreciated. Julio Sotolongo - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Draw: perfectly straight line
Thanks for the suggestion. I tried it, but still the result is segments of straight lines, not continuously straight from end to end. James Knott wrote: Julio Sotolongo wrote: Is there a way to create a perfectly straight line in Draw. This is for a friend that I am trying to interest in OOo. I tried unsuccessfully to accomplish it and then searched the documentation for help. Following the directions in the Draw Guide for drawing a straight line yielded the same results I achieved on my own. A line composed of segments of straight lines, but not continuously straight from end to end. According to my friend, this is possible MSO. It seems like it should be simple to accomplish. Any help would be appreciated. Have you tried the Lines and Arrows button? No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.19/1854 - Release Date: 12/17/2008 7:21 PM
Re: [users] Draw: perfectly straight line
Thank you Brian and James. I tried printing my line and it was indeed straight. I knew it was simple. Unfortunately my friend purchased a copy of MSO before finding a solution. I will email him your input anyway. I told him it was possible to have both on his computer at the same time. As to what part of MSO he was using I will have to ask him. After he told me I wondered myself. 20:36 17/12/2008 -0500, Julio Sotolongo wrote: Is there a way to create a perfectly straight line in Draw. This is for a friend that I am trying to interest in OOo. I tried unsuccessfully to accomplish it and then searched the documentation for help. Following the directions in the Draw Guide for drawing a straight line yielded the same results I achieved on my own. A line composed of segments of straight lines, but not continuously straight from end to end. According to my friend, this is possible MSO. It seems like it should be simple to accomplish. Any help would be appreciated. You may be confusing two things here. Like most office products, OpenOffice Draw is geared towards creating printed output. And if you print your document or export it to PDF, you may well find that your line is sufficiently straight. But compared with most printers, your computer's screen has a comparatively coarse resolution, of course. And it is impossible within the limitations of the screen pixels to create an exactly straight line display. So the screen image within Draw shows a poor imitation, but you may find the final printed or exported result satisfactory. You can also get an idea of what is happening here if you change the zoom factor at View | Zoom... . Your line will still be imperfect, but will be different in detail from before. This demonstrates that it is the display of your line, rather than the line itself, which is the limitation. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.19/1854 - Release Date: 12/17/2008 7:21 PM
[users] when 3.0 available
Has 3.0 been released? It is listed on this site, but not on the official ooo site. http://www.filehippo.com/ -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] when 3.0 available
M Henri Day wrote: 2008/10/10 Dan Klinglesmith [EMAIL PROTECTED] On Oct 10, 2008, at 12:23 PM, M Henri Day wrote: 2008/10/10 Julio Sotolongo [EMAIL PROTECTED] Has 3.0 been released? It is listed on this site, but not on the official ooo site. http://www.filehippo.com/ Looks like it - are we always the last to know ?... Henri OOo 3.0 is still in Beta. It has not been released as of yet. word on the street is it should be final later this month. the latest Release Candidate is OOo 3.0rc4 which is available from the link above as well as http://www.openoffice.org. Dan, if you look more closely at the web page to which Julio provides a link, I think you will discover that, in addition to the RC4 (which is placed in the list of «Old Versions», FileHippo offers readers a download of what they call «OpenOffice.org 3.0.0». If one clicks the download button, one is invited to save a «OOo_3.0.0_Win32Intel_install_en-US.exe» file to one's machine Henri I downloaded the file and attempted to install it. The options during the install process were modify, repair, or uninstall. The news page for ooo has this headline: OpenOffice.org 3.0 Launch Party in Paris on October 13th. Maybe on Monday... -- Julio Sotolongo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: OO Updater keeps trying to update already updated software.
This has also happened to me a number of times when opening OOo. Something that occurred to me is I have both 2.4.1 3.0 installed. The update prompt occurs when opening 2.4.1. Could it be detecting the updated version? Have nothing definite to base this on, but it is a possibility. Cannot remember why, but I had to uninstall then reinstall both versions and it stopped. Stephan G wrote: Jim Allan wrote: Stephan G wrote: Recently, the automatic updated that is part of OO gave me a nudge suggesting that I download and install version 2.4.1. I did so, and installed the new software without incident. When I look at Help-About OpenOffice.org, it tells me that I am running version 2.4.1. However, I keep getting annoying nudges telling me that I need to install 2.4.1, which is (as I have explained) already installed. So I went through re-installing it, and the installer didn't even give install as an option. It gave only Modify, Repair and Remove. So I chose Repair, and the installer chugged along for about fifteen minutes, and again indicated a no-problem solution. Software seems to work fine. But I do keep getting bugged about updating to, you guessed it, the same software I already have installed. If I go to Help-Check for Updates, it either fails with the message Checking for an update failed., or it tells me You are running version 2.4. There is a new update, 2.4.1, do you want to download it? But of course, I am ALREADY running 2.4.1. I am also running OO under Windows Vista Home Premium SP1, and have not encountered anything like this. Nor have others come to this site or any other site that I have seen with this problem. It would appear to be rare or even unique to you (unless others now come forth with similar problems). That information is of no help. All I see to suggest is to try uninstalling OpenOffice.org altogether, and then installing it again. (Note, as long as you have OOo_2.4.0_Win32Intel_install_wJRE_en-US.exe from your previous install, your should not need to download again, though it wouldn’t hurt to download again if the download doesn’t take too long.) Indeed, if you have the time, the most complete attempt you can make is to blow away OpenOffice.org entirely in uninstalling it and then blow away any paths that match those in Format → Options... → OpenOffice.org → Paths and all OpenOffice directories in c:\Program Files\. Then install version 2.4 as a clean install. Note: this will mean that you will lose any templates and backups and settings that you might have made. You can keep these, perhaps by just renaming the paths rather than blowing them away and then, after you have reinstalled, mover the contents of the renamed paths back into the newly created paths, file by file. However, if the only problem is the nudges, then as a work-around, you might more easily make things appear to be fine by just telling OOo to stop prompting you. Jim Allan I have now completely made it a clean install, by unistalling and reinstalling. And the installer program I had is, in fact, not the one you wrote but: OOo_2.4.1_Win32Intel_install_wJRE_en-US.exe But in the work directory it creates, the readmes all still refer to 2.4, and the installer itself says (in its own status bar) that it is installing 2.4. So I guess there is just a weird bug here. I am clearly running 2.4.1. Open Office tells me that in the Help-about menu. But it also tells me when it nudges me or when I check for updates that I am only running 2.4.0 (which is wrong) and that there is a new 2.4.1 out there. I suspect some sloppiness on the creation of this installer, since I have been using the automatic installation and upgrade paths for OpenOffice since version 2.1, and have never seen this behavior. It is pretty annoying. Thanks for your input though. -s P.S. I even checked the md5sum of my installer -- everything is A-OK. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 270.3.0/1505 - Release Date: 6/16/2008 7:20 AM -- Julio Sotolongo [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] RE: OOo 3 beta - Can you have 3.0 and 2.4 together?
Alec McAllister wrote: -Original Message- I would like to know if you can have OOo 3.0 beta and 2.4 on the same computer/laptop? I've got them both running with Vista. Haven't tried it with XP yet. It seems to be just a matter of installing them into different directories. Version 3 Beta looks great and has some really nice features, but is noticeably slower to load and seems to hang every time I try Save As. However, I haven't done exhaustive tests yet, so perhaps it's actually a Vista problem. Alec McAllister I could not find anything specific in the documentation, so I just downloaded the beta version to see what would happen. Running the install showed that the default directory was different from OO 2.4. Now both versions are installed on my computer, which is running Windows XP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] insert text in column using styles
Barbara Duprey wrote: JOE Conner wrote: Julio Sotolongo wrote: Peter Hillier-Brook wrote: Julio Sotolongo wrote: SNIP snip snip snip Peter HB snip snip. When you get what you want, then copy/paste into the WRITER document. I doubt the transfer from Calc into Writer wold be all that clean, though I haven't played with that. A two-column table really should work just fine, but Julio is finding that formatting one column's text is affecting the other column. I'm not sure why that would be happening. Julio, could you explain more about what you're doing to format text in one column, and what you see happening to the other one? Are you modifying the Table Contents paragraph style? Also, can your text get more than a page in depth, or otherwise need to deal with page boundaries? If so, what would you like to have happen then? Barbra, Thanks for your response. It helped me to look more closely at what was happening. Creating 2 columns using tables does result in them being independent from each other. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] insert text in column using styles
Hello, briefly this is my first post to this list, but I have been using OOo for 6 years and it is great. Today I created a doc with 2 columns using styles and formatting. Opened styles and formatting, choose page, right clicked default, modify, selected columns, choose 2, then clicked OK. Great now I had a doc with 2 columns. Was able to insert text in the right hand column, but cannot put anything in the left column. Surely this is a simple to do. What am I doing wrong? I created 2 columns using insert, columns, selected 2. This allowed me to write in both columns, but the functioning is different. My computer is running XP SP2 with OOo 2.4. Searching the documentation I did not find anything. Likely I missed the right information. I would appreciate any assistance you could provide. -- Julio Sotolongo [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] insert text in column using styles
Peter Hillier-Brook wrote: Julio Sotolongo wrote: Hello, briefly this is my first post to this list, but I have been using OOo for 6 years and it is great. Today I created a doc with 2 columns using styles and formatting. Opened styles and formatting, choose page, right clicked default, modify, selected columns, choose 2, then clicked OK. Great now I had a doc with 2 columns. Was able to insert text in the right hand column, but cannot put anything in the left column. Surely this is a simple to do. Could you elaborate a little. As you describe your actions the result will be newspaper columns, where one column flows into the next. It is not possible to enter data into column 'b' until column 'a' has been filled, unless you use a column break to force the issue. What am I doing wrong? I created 2 columns using insert, columns, selected 2. This allowed me to write in both columns, but the functioning is different. Same question here. The Insert menu does not have a Column function, so it is difficult to guess at the cause of your problem, or how you arrived at your result. Peter HB - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Peter, Thanks for your response, it was helpful. I did not know columns in styles were newspaper style, flowing from 1 to the other. Regarding the other, the correct path was insert, tables, not columns. What I want is to format 2 columns where text can be entered independently of each other, as in a flyer. With the tables format text in 1 column moves text in other column. Are these the only options or is there a third? Thank you for the help. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]