Re: [users] Basic OpenOffice Install questions
David Thanks much for your response. I will try to keep this short. My initial attempt to download OOo from the official website met with failure with an indication that the Mac PPC platform version of OOo was not available. Further investigation of other OOo pages uncovered a list of 3rd part providers of the OOo software. I found an outfit in the list called The Open Source Community stationed out of Eatonville, Washington that indicated that it could provide OOo for Mac PPC platform. I purchased and received their cd ($5.95). The Setup Guide came on that CD and it was dated 2005 (3 years old). This document provided the info on dlcompat and the dynamic libraries as well as brief info on X11. I also got some clues on OOo installation and X11 from this OOo website document link: http://porting.openoffice.org/mac/Howto_OOo_2.0_MacOSX_english.pdf Since the documentation from the vendor above is 3 years old, I have serious doubts about it being worth while to try to install the OOo software from their disk... I may have just learned a $6.00 lesson. As to the discussion on my iMac, it was not a typo. It was originally purchased with OS 9 installed. Through purchase of subsequent install CD's, I was able to upgrade it to OS X 10 and ultimately to OS X 10.3. I got to 10.4 through on-line purchase and pachage download and install. I did indeed acquire the X11 software from the 10.3 install disk. On Aug 9, 2008, at 05:57, David Lowe wrote: On Aug 8, 2008, at 22:56 , Kevin Richardson wrote: According to a setup guide I found for OpenOffice.org, I need to locate three files which are as follows: dlcompat libdl.dylib libdl.0.dylib These files are nowhere to be found on my hard drive. How can these files be acquired?? I don't know what 'setup guide' you are looking at, but you needn't muck about in any of the OS innards to install OpenOffice. I fear it is also quite old: since Panther [OS X 10.3] dlcompat has only been needed for outdated programs. The dynamic libraries are stored in a folder hidden from the Finder [/usr/lib] in order to prevent casual tampering from breaking the OS X installation. Here is a brief rundown on the machine I would like to install OpenOffice.org 2.0 on: Apple iMac modelPowerMac2.2 CPU TypePowerPC 750 (83.2) CPU Speed 500 MHz Memory 1 GB OS version OS X v10.4.11 X11 has been installed from a OS X 10.3 install disk. The version of X11 is somewhat confusing though. When I right-click on the X11 icon and select Get Info it tells me version 1.0 Copyright 2003. But when I activate the X11 application and type in X -version and enter, it tells me XFree86 Version 4.3.0 I am concludiing the version to be 4.3.0 Do I need to upgrade my version of X11?? If os, any suggestions on how to do so. So you say you are running Tiger [OS X 10.4] but you installed X11 from the Panther [OS X 10.3] install disk. I would say this kind of cross-versioning is generally a Bad Idea, but i also know this has to be the result of a typo: the Panther install disk did not include X11. I have to assume that you meant to say that you installed X11 from the Tiger disk, and Apple's version 1.0 of X11 is consistent with that. The 4.3.0 is the version of XFree86 that was used as a basis for Apple's X11 1.0. The immediate question you have is whether you *need* to upgrade your X11 installation. The answer to that is no. The 1.0 version is quite robust enough to run OpenOffice. In fact, it is more stable/usable than the cutting edge version of X11 included in Tiger [OS X 10.5]. Apple has made a minor upgrade available to 1.0 [1.1.3, IIRC], but it is bells-and-whistles stuff that most users never need. If you wish to install that, run the Software Update program to fetch the update. The normal process for a brand new installation would look like this: 1. Install OS X and update as desired. 2a. Users of 10.3 and 10.4 need to install X11 separately from the OS. 2b. Users of 10.5 should install the XQuartz updates over their broken X11 installation. 3. Install OpenOffice - for recent versions this is as simple as dragging the application icon into the Applications folder. Not too hard, eh? I wonder why you think you need some kinky setup guide. If you trying this obscure procedure because you are getting errors from either OpenOffice or X11, then you may as well share the errors with us - we might be able to walk you through fixing it. -- Using a rusty Amiga 4000T, a shiny PowerMac G5, a homebuilt Ubuntu box What was the greatest thing before sliced bread? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: A question
Roy Montgomery wrote: Someone made me aware of your Suite and have been looking at your webpages. My question is: If I download and use your Suite, where is the data stored? In otherwords, do you house the data or is it only on my machine. Thanks, Roy Montgomery, DVM, PhD, Executive Secretary Hi Roy, After installing Openoffice, go to Tools-Options-OpenOffice.org-Paths. There you will see where Openoffice will store your docs my default (it's called My Documents). You can change this to something more convenient if you wish and you can always save any file anywhere you wish. The My Documents setting is only the default option. Cheers, Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
Wade Smart wrote: James Knott wrote: louis wrote: James Knott wrote: Louis-H Desouvrey wrote: Hi, I need to put a math formula (e.g. widevec{?}) into a text frame from the draw functions. Is there a way to do it in the current version of OOo? Thanks! Yes. When in the text box, click on Insert Object Formula. This will open the math editor, where you can create the desired formula. It doesn't work. When I am in a text frame from the draw functions, the menu insert object formula and all other options are disabled. I can't use either copy and paste. Curious, it works here on both Linux and Windows versions. 20080809 1925 GMT-6 I just tried it and it works fine - Im on Ubuntu (linux). Wade - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Can you please give us some more information. What version of OpenOffice are you running on what operating system. How much RAM and what type of processor do you have, we can then try and see if there is anything different about that version on that system. Thanks Rob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
hello, I have encounter the same trouble as Louis. see the link, I have upload a sample doc at mediafire. In this document, I just wanted to group all elements into a whole, but the formula element refused to join. http://www.mediafire.com/?sharekey=a7eb93d843c677e6d2db6fb9a8902bda
Re: [users] How to insert a math formula into a text frame?
Doesn't work for me either: OpenOffice.org 2.4.1 Ubuntu 8.04 The Insert → Object is grayed out. I have tried with rectangle and text box. Same result in both cases. J.R.
[users] Comment out?
Like a programming language, I hope the OO Writer has the similar ability. namely, comment out some words from the content. I am writing a paper, some words should not appear in the final result. But these words should be kept for two reasons. 1. for inspiration 2. for improvement. It seems that keeping 2 copies of a document is not a good idea. Why? just think of which one should be modified in the future. Any Suggestion?
Re: [users] How to insert a math formula into a text frame?
Sorry, the link should be: http://www.mediafire.com/?0aanca3iafg On Sun, Aug 10, 2008 at 4:42 PM, Xiang Liu [EMAIL PROTECTED] wrote: hello, I have encounter the same trouble as Louis. see the link, I have upload a sample doc at mediafire. In this document, I just wanted to group all elements into a whole, but the formula element refused to join. http://www.mediafire.com/?sharekey=a7eb93d843c677e6d2db6fb9a8902bda
Re: [users] Convert text to number (and date)
2008/8/7 Cor Nouws [EMAIL PROTECTED] Hi all, A little moment to ask attention for the latest version of CT2N – Convert Text To Number (and date): http://extensions.services.openoffice.org/project/CT2N Especially of interest for those fighting / playing / studying numbers and dates. This version includes conversion of date-strings in two modes: limited and full OOo-date conversion. The idea and first step to implement text-date conversion came from one of the users. As many other ideas came from users. By the way: really interesting to see what strange things (in my eyes) people do with numbers and formatting in spreadsheets ;-) I have the impression that few useful features extra might be possible, so don't hesitate to write... Kindest regards, Cor Hi! Nice extension. Here are some comments: The close button on the upper right corner (☒) doesn't seem to work. Nothing happens when clicking it. I'm on Ubuntu 8.04, OpenOffice.org 2.4.1. The Close button, the one with the text Close on it, works as expected. How can I help translating the extension to Swedish? Maybe off topic, but it would be nice if it was possible to convert numbers to numbers as well, such as the conversion from 20080810 → 39670 (=2008-08-10 if the cell is formatted as the ISO 8601 date format). I actually have a file with such dates. In my case I formatted the cells like -00-00 to make it look like dates, but now, a few years later, I realize that there are many advantages by converting them to real dates…
Re: [users] How to insert a math formula into a text frame?
2008/8/10 Xiang Liu [EMAIL PROTECTED] Sorry, the link should be: http://www.mediafire.com/?0aanca3iafg That's the document I tried. On Sun, Aug 10, 2008 at 4:42 PM, Xiang Liu [EMAIL PROTECTED] wrote: hello, I have encounter the same trouble as Louis. see the link, I have upload a sample doc at mediafire. In this document, I just wanted to group all elements into a whole, but the formula element refused to join. http://www.mediafire.com/?sharekey=a7eb93d843c677e6d2db6fb9a8902bda
Re: [users] Comment out?
Xiang Liu wrote: Like a programming language, I hope the OO Writer has the similar ability. namely, comment out some words from the content. I am writing a paper, some words should not appear in the final result. But these words should be kept for two reasons. 1. for inspiration 2. for improvement. It seems that keeping 2 copies of a document is not a good idea. Why? just think of which one should be modified in the future. Any Suggestion? Conditional hidden text? See the Help files under hidden text. Peter HB - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Convert text to number (and date)
Hi Johnny, Johnny Rosenberg wrote (10-8-2008 11:28) Nice extension. Here are some comments: The close button on the upper right corner (☒) doesn't seem to work. Nothing happens when clicking it. I'm on Ubuntu 8.04, OpenOffice.org 2.4.1. The Close button, the one with the text Close on it, works as expected. I know. I've used the window as a non-modal one (you can still toch the spreadsheet while the window is opened). Probably I have to do something extra to make the window's close button work. Bit since I never user those ;-) I didn't yet put any effort in it. How can I help translating the extension to Swedish? Would be great! It's quite easy: the strings are in the source of the extensions basic library. But I send you them off-list in English. Maybe off topic, but it would be nice if it was possible to convert numbers to numbers as well, such as the conversion from 20080810 → 39670 (=2008-08-10 if the cell is formatted as the ISO 8601 date format). I actually have a file with such dates. In my case I formatted the cells like -00-00 to make it look like dates, but now, a few years later, I realize that there are many advantages by converting them to real dates… Can you send me a short example? Maybe it is not that complicated to make. Thanks for your feed back! Cor -- The Year of 3 -2008- Het jaar van 3 Cor Nouws - Arnhem - Netherlands marketing contact - http://nl.OpenOffice.org Zeker van OpenOffice.org - www.nouenoff.nl - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] A question
Roy, Adding to what others have said... - Files are stored on your computer - You can choose where on your computer they are stored - for additional information about where files are stored and how to modify the location refer to page 63 of... http://documentation.openoffice.org/manuals/oooauthors2/0100GS-GettingStarted.pdf there's just a little bit of text and an illustration On Thu, Aug 7, 2008 at 11:19 AM, Roy Montgomery [EMAIL PROTECTED]wrote: Someone made me aware of your Suite and have been looking at your webpages. My question is: If I download and use your Suite, where is the data stored? In otherwords, do you house the data or is it only on my machine. Thanks, Roy Montgomery, DVM, PhD, Executive Secretary EBVMA PO Box 5444 Mississippi State, MS 39762 (662) 325-1279 [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
On 7 Aug 2008 at 14:43, Louis-H Desouvrey wrote: Hi, I need to put a math formula (e.g. widevec{?}) into a text frame from the draw functions. Is there a way to do it in the current version of OOo? Thanks! This may depend on whether you're working in Writer or Draw. The option (Insert|Object|Formula) is greyed out in Writer's text box, but seems to work in Draw. Might explain why some say it works, some say not. XP/2.4.1, BTW. (Gets out soapbox and mutters about consistency.) -- This is in response to your message to users@openoffice.org, an email list for the support of the OpenOffice.org office suite. It is not a formal support team, but relies on volunteer users to provide help and advice via email to the list only. If you are not subscribed to this mailing list, you may miss replies. http://www.openoffice.org/mail_list.html for more information. Replies to users@openoffice.org only please. Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. Mike Scott = Harlow = Essex = England. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
mike scott wrote: On 7 Aug 2008 at 14:43, Louis-H Desouvrey wrote: Hi, I need to put a math formula (e.g. widevec{?}) into a text frame from the draw functions. Is there a way to do it in the current version of OOo? Thanks! This may depend on whether you're working in Writer or Draw. The option (Insert|Object|Formula) is greyed out in Writer's text box, but seems to work in Draw. Might explain why some say it works, some say not. XP/2.4.1, BTW. A text box in Writer??? The math editor works in both Writer and a Draw text box for me, on both Linux XP. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Comment out?
Great, Thank you! Peter.
[users] A bug?
try the following steps: 1. new writer document 2. type: hello, This is an equation: (input some math formula here, for example, dy over dx=f(x)y ), over 3. Menu: Edit--changes--Record. and make sure that the edit--changes--view is checked. 4. deleting text from an equation to over 5. save document 6. Now, Bug? here, you will find the formula has turn to a block named Object 2-like. And have no way to recover it. == 2.4.1 on WinXP.
Re: [users] How to insert a math formula into a text frame?
On 10 Aug 2008 at 10:09, James Knott wrote: mike scott wrote: On 7 Aug 2008 at 14:43, Louis-H Desouvrey wrote: Hi, I need to put a math formula (e.g. widevec{?}) into a text frame from the draw functions. Is there a way to do it in the current version of OOo? Thanks! This may depend on whether you're working in Writer or Draw. The option (Insert|Object|Formula) is greyed out in Writer's text box, but seems to work in Draw. Might explain why some say it works, some say not. XP/2.4.1, BTW. A text box in Writer??? The math editor works in both Writer and a Draw text box for me, on both Linux XP. ??? Now I was confused when I replied - I'm always muddling text /boxes/ and text /frames/ -- and I now see the OP explicitly said /frame/ (and implied Draw for that matter - I really must remember to read well before replying :-) ). If he meant /frame/, he must have been using Writer (using Insert|Frame) - afaik Draw doesn't allow text frames(*). And in this case a formula object appears to be insertable into a text /frame/ in the obvious way and behaves as part of the frame. If he meant text /box/ (ie the thing you get by clicking the T in the drawing tools bar), then my comment stands - with cursor inside the text box, in Writer, the Insert|Object menu entries are greyed out, while in Draw they're available -- but an inserted formula has its own existance separate from the text box. I can't see why your mileage should be so different :-( Perhaps the OP could clarify what he wants to achieve? Is this in Draw or Writer, and was it a text frame or a text box? (*) If I'm wrong here, please enlighten me! -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED]Mike Scott, Harlow, Essex, England - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Convert text to number (and date)
At 11:28 10/08/2008 +0200, Johnny Rosenberg wrote: Maybe off topic, but it would be nice if it was possible to convert numbers to numbers as well, such as the conversion from 20080810 â 39670 (=2008-08-10 if the cell is formatted as the ISO 8601 date format). I actually have a file with such dates. In my case I formatted the cells like -00-00 to make it look like dates, but now, a few years later, I realize that there are many advantages by converting them to real dates Try: =DATE(INT(x/1);MOD(INT(x/100);100);MOD(x;100)) and then Paste Special back over the original values with Date time ticked and Formulas not ticked? I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Comment out?
At 17:22 10/08/2008 +0800, Xiang Liu wrote: I am writing a paper, some words should not appear in the final result. But these words should be kept ... You need Notes. o Position the cursor. o Go to Insert | Note... . To view the note, hover the cursor over the yellow marker. The default is not to print these, but you can control what gets printed and where either at Tools | Options... | OpenOffice.org Writer | Print | Notes, or on the fly via the Options... button in the Print dialogue. I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
mike scott wrote: If he meant text /box/ (ie the thing you get by clicking the T in the drawing tools bar), then my comment stands - with cursor inside the text box, in Writer, the Insert|Object menu entries are greyed out, while in Draw they're available -- but an inserted formula has its own existance separate from the text box. I can't see why your mileage should be so different :-( Perhaps the OP could clarify what he wants to achieve? Is this in Draw or Writer, and was it a text frame or a text box? (*) If I'm wrong here, please enlighten me! As I did yesterday, in Draw, I click on the T and draw a text box. With the cursor in that box, I can insert items, including a formula. I can do this on both Linux Windows versions of OO. I don't have any idea why it doesn't work for you or the OP. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] A question
Roy: On Thu, Aug 07, 2008 at 10:19:48AM -0500, Roy Montgomery wrote: Someone made me aware of your Suite and have been looking at your webpages. My question is: If I download and use your Suite, where is the data stored? In otherwords, do you house the data or is it only on my machine. It is stored on your machine, in a location that you specify. Thanks, Roy Montgomery, DVM, PhD, Executive Secretary EBVMA PO Box 5444 Mississippi State, MS 39762 (662) 325-1279 [EMAIL PROTECTED] Dean -- Dean Provins, P. Geoph. [EMAIL PROTECTED] KeyID at at pgpkeys.mit.edu:11371: 0x9643AE65 Fingerprint: 9B79 75FB 5C2B 22D0 6C8C 5A87 D579 9BE5 9643 AE65 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
Louis-H: On Thu, Aug 07, 2008 at 02:43:06PM -0400, Louis-H Desouvrey wrote: Hi, I need to put a math formula (e.g. widevec{?}) into a text frame from the draw functions. Is there a way to do it in the current version of OOo? Thanks! It is not clear to me what you mean by inserting the formula from the draw functions, but if it means placing a formula into a text frame, and possibly copy/pasting into a drawing then it is easily done: Create a frame in a text document. Select the frame Insert the formula using the formula editor Copy the frame Paste into the drawing. Louis D. Dean -- Dean Provins, P. Geoph. [EMAIL PROTECTED] KeyID at at pgpkeys.mit.edu:11371: 0x9643AE65 Fingerprint: 9B79 75FB 5C2B 22D0 6C8C 5A87 D579 9BE5 9643 AE65 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Basic OpenOffice Install questions
On Aug 9, 2008, at 23:05 , Kevin Richardson wrote: My initial attempt to download OOo from the official website met with failure with an indication that the Mac PPC platform version of OOo was not available. Further investigation of other OOo pages uncovered a list of 3rd part providers of the OOo software. I found an outfit in the list called The Open Source Community stationed out of Eatonville, Washington that indicated that it could provide OOo for Mac PPC platform. I purchased and received their cd ($5.95). The Setup Guide came on that CD and it was dated 2005 (3 years old). This document provided the info on dlcompat and the dynamic libraries as well as brief info on X11. I also got some clues on OOo installation and X11 from this OOo website document link: http://porting.openoffice.org/mac/Howto_OOo_2.0_MacOSX_english.pdf Since the documentation from the vendor above is 3 years old, I have serious doubts about it being worth while to try to install the OOo software from their disk... I may have just learned a $6.00 lesson. OUCH! Yes, it is sad that OOo does no longer support us. However, the source code is available for anyone to compile, and other sites do compile it for us. Check out the good-day server ftp:// ooopackages.good-day.net/pub/OpenOffice.org/MacOSX/ NOTE: The English versions on good-day do not have -en in the file name. In any case, the most FAQ on this list has to be complaints about people being sold copies of what is available for free. Sometimes these vendors charge many times the price you paid, and then point their customers to this list as their paid support. Six bucks is reasonable for the disk, envelope and mailing costs. Did you at least get a recent version of OpenOffice? As to the discussion on my iMac, it was not a typo. It was originally purchased with OS 9 installed. Through purchase of subsequent install CD's, I was able to upgrade it to OS X 10 and ultimately to OS X 10.3. I got to 10.4 through on-line purchase and pachage download and install. I did indeed acquire the X11 software from the 10.3 install disk. Perhaps i remember wrongly. It might have been Jaguar that only offered X11 as a separate download. So is X11 starting okeh for you? -- Using a rusty Amiga 4000T, a shiny PowerMac G5, a homebuilt Ubuntu box What's the difference between a dog and a fox?Five beers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
On 10 Aug 2008 at 11:22, James Knott wrote: ... As I did yesterday, in Draw, I click on the T and draw a text box. With the cursor in that box, I can insert items, including a formula. I can do this on both Linux Windows versions of OO. I don't have any idea why it doesn't work for you or the OP. But that's not actually in the text box. Which will matter when the box is moved and the formula doesn't move with it. And in Writer? Maybe I'm confused, but I'm almost sure someone said they could do this in both. But I really think the OP needs to clarify exactly what he did and what he wants to achieve. As I said, he talks about drawing tools and text /frames/ (not boxes). Which kind of implies he's using writer and writer's tools. -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED]Mike Scott, Harlow, Essex, England - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: combine several spreadsheets in Calc
Christian: On Sat, Aug 09, 2008 at 12:10:29PM -0700, NoOp wrote: On 08/07/2008 07:45 AM, Christian Liebig wrote: Hi there, I am new to this list and I hope this is the right place for the following problem: I have several Excel files, each containing 1 sheet. I would like to combine them to 1 spreadsheet document where each file should be converted to a sheet in the new document. All original files are in 1 folder so my idea is to do some kind of batch import but I have no idea how to do that. Can anybody help? Kind regards, Christian Google shows a commercial application that does this: http://www.sobolsoft.com/calcjoinfile/ Disclaimer: I've not tried it, I just found it with a google search http://www.google.com/search?hl=enq=openoffice+%2Bcalc+%2Bbatch+import+files Did you try copy and paste? Seems to work within OO. Dean -- Dean Provins, P. Geoph. [EMAIL PROTECTED] KeyID at at pgpkeys.mit.edu:11371: 0x9643AE65 Fingerprint: 9B79 75FB 5C2B 22D0 6C8C 5A87 D579 9BE5 9643 AE65 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] A bug?
On 10/08/2008 15:36, Xiang Liu wrote: try the following steps: 1. new writer document 2. type: hello, This is an equation: (input some math formula here, for example, dy over dx=f(x)y ), over Do you mean enter **text** dy over dx=f(x)y or do you mean insert a **formula** using Math? 3. Menu: Edit--changes--Record. and make sure that the edit--changes--view is checked. 4. deleting text from an equation to over There are two occurrences of the word over in what you showed us. Which one do you mean here? 5. save document 6. Now, Bug? here, you will find the formula has turn to a block named Object 2-like. And have no way to recover it. == 2.4.1 on WinXP. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Comment out?
But the notes are simple, it could not contain complex objects such as formula. Best Regards, Xiang Liu On Sun, Aug 10, 2008 at 11:07 PM, Brian Barker [EMAIL PROTECTED]wrote: At 17:22 10/08/2008 +0800, Xiang Liu wrote: I am writing a paper, some words should not appear in the final result. But these words should be kept ... You need Notes.
Re: [users] Comment out?
Xiang Liu wrote: But the notes are simple, it could not contain complex objects such as formula. Best Regards, Xiang Liu ?? In your original post, you said some words should not appear in the final result. The notes will handle words. So you're really after things more complex than words I take it? On Sun, Aug 10, 2008 at 11:07 PM, Brian Barker [EMAIL PROTECTED]wrote: At 17:22 10/08/2008 +0800, Xiang Liu wrote: I am writing a paper, some words should not appear in the final result. But these words should be kept ... You need Notes. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] A bug?
Do you mean enter **text** dy over dx=f(x)y or do you mean insert a **formula** using Math? - using Math. the content between parentheses are explanation. - There are two occurrences of the word over in what you showed us. Which one do you mean here? Since the first over is a part of Math formula (in the equation editor), so only one over left.(namely, the end of line) - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Comment out?
Sorry, actually, I mean paragraphs. I apologize for it. I like peter's suggestion. Especially, the use of section with hide property(conditional hide). In this way, I can set a switch variable(a filed) in the beginning of document, then turn the wanted paragraphs into hidden section by inserting section. The visibility of sections is controled by the switch variable. Once a document has been finished, the only thing to do is turn the switch so as to hide all unnecessary text. But, even the note of OO, as a review tool, is not enough for technical document with equations, in contrast to Microsoft Word. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] A bug?
On 10/08/2008 17:55, Xiang Liu wrote: Do you mean enter **text** dy over dx=f(x)y or do you mean insert a **formula** using Math? - using Math. the content between parentheses are explanation. - There are two occurrences of the word over in what you showed us. Which one do you mean here? Since the first over is a part of Math formula (in the equation editor), so only one over left.(namely, the end of line) - I have filed issue #92636 describing this problem. I don't know of any workaround. Perhaps others would comment (in the issue) if they can confirm/deny it on non-Windows platforms and/or in v3 Beta. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] Convert text to number (and date)
2008/8/10 Brian Barker [EMAIL PROTECTED] At 11:28 10/08/2008 +0200, Johnny Rosenberg wrote: Maybe off topic, but it would be nice if it was possible to convert numbers to numbers as well, such as the conversion from 20080810 â†' 39670 (=2008-08-10 if the cell is formatted as the ISO 8601 date format). I actually have a file with such dates. In my case I formatted the cells like -00-00 to make it look like dates, but now, a few years later, I realize that there are many advantages by converting them to real dates… Try: =DATE(INT(x/1);MOD(INT(x/100);100);MOD(x;100)) and then Paste Special back over the original values with Date time ticked and Formulas not ticked? I trust this helps. Well, I know how to convert them, I just thought it would be a nice addition to the TextToNumbers extension, but thanks anyway for reminding me of the MOD function. I guess I would have done it without it, which would have lead to a way longer expression… J.R. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: combine several spreadsheets in Calc
On 08/10/2008 09:23 AM, Dean Allen Provins, P. Geoph. wrote: On Sat, Aug 09, 2008 at 12:10:29PM -0700, NoOp wrote: Google shows a commercial application that does this: http://www.sobolsoft.com/calcjoinfile/ Disclaimer: I've not tried it, I just found it with a google search http://www.google.com/search?hl=enq=openoffice+%2Bcalc+%2Bbatch+import+files Did you try copy and paste? Seems to work within OO. Perhaps you missed his previous: Hi Brian, thanks very much for your reply, both alternatives work fine. But if you work with a lot of files, let`s say 20 - 50, to be combined and you have to do that job once every 2 weeks it would be cool to find a more effective way to do it. That is why I am looking for a way to kind of automate this. The batch import was just one idea, because the files to be imported will always be in one folder and will always have the same names. I do not necessarily need all the data combined in one file, it would also be OK just to import certain columns from the original files to my main document. Is that somehow possible, maybe with a macro? Kind regards, Christian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert a math formula into a text frame?
mike scott wrote: On 7 Aug 2008 at 14:43, Louis-H Desouvrey wrote: Hi, I need to put a math formula (e.g. widevec{?}) into a text frame from the draw functions. Is there a way to do it in the current version of OOo? Thanks! This may depend on whether you're working in Writer or Draw. The option (Insert|Object|Formula) is greyed out in Writer's text box, but seems to work in Draw. Might explain why some say it works, some say not. XP/2.4.1, BTW. (Gets out soapbox and mutters about consistency.) Let's me clarify. When I am in OOo Writer, I can't insert a formula into a text box (created by clicking the T button in the Draw toolbar...). As you put it, the option Insert Object Formula is greyed out. Copy and paste are greyed out as well. In OOo Draw this option is enabled (i.e., it is not greyed out), but I can't group a formula with other drawings (a line, a triangle, etc.). XP-SP2,OOo 2.4.1. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Need a macro to open template
On Thu, 07 Aug 2008 18:10:39 -0400, Andrew Douglas Pitonyak wrote: If this does not work, email me directly: Booyah! Works as advertised, thanks! L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]