[users] Re: Thank you very much!
Dear Jeff: I also have used Oo for presentations during the 4 years I was in Toastmasters. At that time I was using it on an XT platform. Since the purchase of Sun by Oracle, I have gone to LibreOffice, but much is the same. I also use LibO on Fedora 16, and with double screens on my laptop, I use the external screen for the audience (or it could equally be a projector) and the Laotop screen for the speaker's screen. When I use my presenter, both screens change in synchronism. On the speaker's screen there are 3 parts: 1) is a small image of the image on the audience screen, so I can see where that is at without the need to turn my back to the audience. 2) is a similar image, but of the next screen to come up. 3) is a larger window with the annotatons (AKA teleprompter). This is a real help if the content of the speech/presentation is complex. Also it can speed getting back on track if you have an unexpected audience distraction. One more thing I have seen a great and too often neglected need for: Wherever in a speech or presentation, the content is dependent on the audience grasping the interrelations between a complex (often circumstantial) arrangement of interacting concepts, especially if those concepts are abstract ones, I have developped a strategy based on Draw. I call this organnigrammes. Organnigrammes is simply the French word for flowcharts. I used the French word in English to infer a distinction between traditional flowcharts and what I have done. First, I downloaded a simple screen of traditional flowchart symbols from the web. I then vectorised them and thence made variations of my vectorisations to represent added Graphic vocabulary to the project. More recently, I had to add symbols for the Boolean algebra concepts, AND, OR, NOT. For this, being an electronic technician, I vectorised they symbols used for AND and OR gates, added the little circle when a negation or inversion was needed, added text labels inside, and there it was. I also had created symbols to indicate reiterative loops and a few more. Aside from technical presentations, I see this as being a practical way to efficiently document and communicate personality sketches between managers, HR people and psychologists. (Note the ethical considerations are independent of the tools, as only humans can make such moral judgements, thus abrogating any such complaints that could be made against the tools rather than the user's use of them.) Since I save all the vectorised pieces in all the Draw work I do, they add ongoing to my working library. I also have a lot of tricks I use to do the tasks that a true CAD app would do better, and Draw does not do directly. Note that scale is a setting of Draw, not the .ODG file, so it may be expedient to have an extra page at the end for scraps and annotations of such items as scale and grid settings used for each file. To me the biggest caveat is that Draw has a math accuracy limit of only about 3 decimal places, rather than, say 12 for a true CAD app. Therefore in some cases I have to use a callout to show exact dims. This may help some out there who do presentations. On 3/15/2012 00:31, Jeffrey Deutsch wrote: Hello, Some time back, I posted asking for advice with OpenOffice.org's Impress. I just wanted to thank all of you for your help - my presentation was a huge success! Keep up the good work! Jeff Deutsch Speaker Life Coach A SPLINT - ASPies LInking with NTs http://www.asplint.com Your mood can affect how you read this e-mail. Please read it with a smile. (http://tonecheck.com) -- Best Regards, Bruce Martin -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Hyperlinks in docs
Hi Michael: This is no surprise. On a PC or in Linux, one would use {ctrl-click} to do the same, yet for a .PDF generated with the same hyperlinks embedded, one would merely click. Howqever I also find often enough that in my Calc workbooks (.ODS format), the hyperlinks on my summary sheet will jump nicely to the tens of other sheets without the need for the {ctrl-click}. It may be that the authors of Writer wanted to leave a simple click open to other uses, I'm not sure. Best regards from Canada, Bruce Martin. On 8/18/2011 22:36, Michael Reich wrote: On my Mac, I've found that I usually have to select the link text first (just left-click on it) and then Command-click to actually jump to the link. On 8/18/11 users-requ...@openoffice.org wrote: Subject: [users] Re: Hyperlinks in docs From: Guy Voets nimant...@gmail.com Date: Tue, 16 Aug 2011 10:46:42 +0200 To: users@openoffice.org 2011/8/15 Robert Peirce b...@peirce-family.com: Since my version of Word won't work in Apple OS 10.7, I am converting my doc files to odt. I opened a file that has hyper-links and it said to command click the link, which I did, but it didn't take me there. Does something need to be changed to get these to work in OpenOffice? I am running 3.3.0. Hello Robert, Yes, to activate a hyperlink on Macs, you use Command-click (next to space bar) in LibO and OOo. It works for me... Maybe take a look at menu EditHyperlink? -- Best Regards, Bruce Martin -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Hyperlinks in docs
Hi Guy: It is possible that your installation of Oo has the hyperlinks/macros setting set to high security. If so, you may need to set it to medium (more practical) This is done iunder Tools - Options. This is usually necessary following a new installation, and also (if it has not already been done) when using Laurent Goddard's DicOoo.SXW to install added language packs. (For that file, be sure you are using version 1.8 or higher!) Best regards from Canada, Bruce M. On 8/16/2011 04:46, Guy Voets wrote: 2011/8/15 Robert Peirceb...@peirce-family.com: Since my version of Word won't work in Apple OS 10.7, I am converting my doc files to odt. I opened a file that has hyper-links and it said to command click the link, which I did, but it didn't take me there. Does something need to be changed to get these to work in OpenOffice? I am running 3.3.0. Hello Robert, Yes, to activate a hyperlink on Macs, you use Command-click (next to space bar) in LibO and OOo. It works for me... Maybe take a look at menu EditHyperlink? -- Best Regards, Bruce Martin -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: No AUDIO or VIDEO
Dear Andy: 1)Download the PowerPoint (.PPT) 2)Right click on it, and choose open with 3)Follow the menus to open it with Oo Impress. 4)Then save the file as an .ODP for use with Open office. 5)This may contain embedded vectorial or executable content. Occasionally this content is misinterpreted when converted. If this shows as an issue, get back to me on the list. The file will then have to be opened with Power Point, taken apart and the pieces saved independently, then reconstructed in a combination of Oo Draw, Audacity, UPlayer and Oo impress finally. If there is video content, you can set that up in Windows media player if you are on a Windows platform. If you are running Linux (such as Fedora) you could look for Videolan or Cinelerra. Videolan is likely enough. Cinelerra is very high end and I have note seen a downloadable compiled RPM for it. It had to be compiled before installation and use by the end users. Best Regards, Bruce Martin QC, Canada On 7/22/2011 15:15, Andy Kun wrote: Just downloaded Open Office 3.3, it works fine, except there is no audio; but am getting a message PowerPoint Web App cannot play audio or video in presentations. To play audio or video, open this presentation in Microsoft PowerPoint. The whole idea was to get away from Microsoft. can you help? Thanks, Andrew Kun nosails...@hotmail.com mailto:nosails...@hotmail.com -- Best Regards, Bruce Martin -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
Re: [users] Lock formulas from being changed in Calc?
All cells in a sheet are, by default left ready to be protected when the sheet as a whole is protected. 1) Select the cells to be left unprotected. 2) Go format cells 3) Select the Cell protection tab. 4) To make the cells editable after the rest is protected, Uncheck the box protected 5) If you are going to sell your work in creating the spreadsheet, you may want to keep your formulas from being copied. For the cells in which there formulas exist, leave those cells protected, and check the Hide Formula box. 6) You can also choose to hide certain cells from printing, independently from whether they are visible on screen. 7) You must then select the sheet(s) to be protected, then go Tools and protect the sheets as a whole. This will require you to create a password. If you are doing this many times, I suggest you keep a record of the passwords in a password protected Calc workbook stored on a USB memory stick, so that most of the time the file is physically disconnected from your system or the internet. 8)Copyright/intellectual properties laws vary from country to country. Therefore if you are selling your work, you will want to have a contract from your clients first, which explicitly states in detail what you are licensing to the client and what you are not. A dispute could result if the client was expecting to have access to the formulas and had not signed a contract to the contrary. Often a client will tacitly (unspoken) have such expectations. If you are in the U.S.A., it is possible that your work could also be subject to export control laws of the U.S. Government, and before exporting, you should contact them to be sure you are legal. Best Regards, Bruce Martin Montreal, QC Canada On 1/6/2011 22:25, . wrote: I want to lock specific cells with formulas in a sheet so that they can't be changed while the remainder of the sheet must be editable How is it done? -- Best Regards, Bruce Martin
Re: [users] Can OOo be used on a Mac?
Dear List: As far as I know, Oo can run on a mac, Tiger and up. However Mac has gone several steps beyond Tiger by now, so If his OS is Tiger, he may need to use an older version. Also if he needs to share data with file systems other than HFS or HFS+, he will need to deal with spiltting and reassembling the mac fork for each Mac file, no matter what the application. Cheers, Bruce M. On 12/29/2010 12:51, Johnny Rosenberg wrote: Den 2010-12-29 15:57:13 skrev Earl Melton earlemel...@yahoo.com: 2010/12/29 Earl Melton earlemel...@yahoo.com: I know absolutely squat about mac computers, but have a friend who wants to use OOo on one. When I searched for 'openoffice on mac' on the openoffice.org/ site, I found several inquiries similar to mine, but no answers. Has anyone been successful at this? And, if the answer is Yes, could you please share a link or specific 1-2-3-type instructions on how to go about it? It is a laptop with Mac OS X v10.5.8 -- Earl Yes. Just click the link that corresponds to your language and operating system here: http://download.openoffice.org/other.html#tested-full Johnny Rosenberg Thanks Johnny, I hadn't seen that exact page. The only two Mac options I saw listed were OS Intel and PowerPC. Would either of those likely work on his OS X? If he has an Intel processor he should download the Intel version, otherwise the PowerPC version is the right one. -- Earl -- -- Best Regards, Bruce Martin
Re: [users] Where does Linux/Mint OOo Store RGB Color Codes?
Dear James and all: My experience is that Oo stores color codes, hatches and gradients all in the same place relative to itself. This alone does not give you the exact path, as that can vary in relation to the different platforms. However there is a simple procedure I use to load, store and migrate this data between Fedora, Win XP etc on my network, and carry it physically to friend's machines (as I have created a number of custom colours and gradients.) *_Procedure:_* In whatever installation of Oo you are using... 1)Open a blank Oo Draw file. 2)Draw a rectangle (size is minimally important, as long as it fits the page and is big enough to see the fill colour.) 3 ) Right click (PC) on the fill. 4)From the menu that appears, choose area. 5)Then choose the colours tab. 6)Close to the right side of the colour choice window, look for 2 icons, One usually a blue floppy, (to save as the colour palette), the other one above it to load a colour palette. 7)Open either one of these, and you will get the contents of the default folder that holds the color palette (usual extension: .SOC) The default file name is Standard.SOC, and the size will depend on the number of colours it contains at the time. (Mine, with added colours is only about 12 Kb.) 8)In the usual manner for navigating, start to navigate - more to see where the default folder is located than to actually do anything. 9)If you want to export a colour palette, load it into Oo, then save it with the other icon, navigating to your desired new location. Then you will end up saving a copy of it in that location, which can be a USB stick, and external or network drive or whatever you have. 10)Likewise, using the load icon, you can load a file from any other location, then save it as the Standard.SOC file, overwriting the one in the default folder and, providing the new file is a legitimate SOC, it will be the default colour palette once you close and restart Open office - no need to reboot as a rule. 11)All the preceding stuff repeats for Gradients (Default Standard.SOG) and Hatches - Default Standard.SOG 12)If the installation were on a MAC, either the HFS or HFS+ file system would likely generate the usual mac fork, or that might be done by the underlying Java runtime used with the MAC (Tiger and up.) 12a)When exporting from a MAC to a PC environment, it is normal to end up with 3 files for each part of the MAC fork: The Data Resource is the one you need for the PC, the Resource and other forks should be saved aside, so that when you need to re-import the file back from the PC world to the MAC world, you simply copy the modified PC file back into the folder where the other 2 files were kept, making sure the filenames (aside from the extensions) are identical, then, in the MAC environment, the re-integration of the 3 files back into the MAC fork is normally done automatically when you copy the file back into the MAC environment. On the older MACS, this was done with a PC formatted floppy used in the MAC floppy drive, as on either the 1.44Mb PC floppy and the same physical floppy, formatted as HFS (MAC) 900 Kb. were actually encoded MFM. On USB Sticks, the file system should be FAT16, but Likely could work with ext2 or ext3, providing the MAC OS is capable of reading those systems currently. In the case of an External HD (USB of IEEE1394/Firewire) the likely system would be FAT32. NAS drives are more complex, as they generally have a firmware OS which is network transparent. Personally here my NAS box is the D-Link DNS-323 which is a UNIX box. Since the latest major firmware upgrade flashes the obligatory initial initialise and format the box does on anew drive can be ext2 or ext3 (latter preferred) but other machines will see this as if it were NTFS, or, alternatively this box has built-in SFTP and Torrent servers as well as the more normal Windows network protocol. In Linux (Fedora 14 x_64) I access this via Samba. The box also has firmware RAID capability and scheduled automated download capability. This box can go well with D-Link's DIR-825, as it likes a Gb. Wired connection (CAT 6 cable required). Happy computing and learning! I hope you all find my answer a colourful answer (guffaw). Bruce M. On 12/12/2010 19:09, James Greenidge wrote: Seasons Greetings: I'd be happy enough just being pointed to where Linux/Mint OOo stores its color code files so I can figure out how to replace it with the one from Mac OOo to save my home school the time and tedium of inputting over eighty custom non-Sun color codes. Thanks. Jim - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Best Regards, Bruce Martin
Re: [users] Calc: How to see list of sheets
Dear Laurent: I create this easily on a regular basis in Calc, However it is not just 1 click. I add an extra sheet at the beginning (leftmost tab) then add hyperlinks to each of the sheets in Column B or C. Column A is a sequence number (or a priority number) so that I can sort by arbitrary criteria. With this I can jump to any sheet in a {ctrl-click}. This sheet can also use added columns for items such as a total from each of the other sheets if these sheets are, say accounts. Since the accounts can be part of an ongoing inventory reconciliation, Their end results can be in Lbs., Kg. Litres, Gallons, etc or the calculated value of the current stock level for each, also taking account of value from different currencies, Metric/English conversions, Averaged unit value across multiple purchases of the same stock item, differences in taxable status, etc. One of these applications I did was for an industrial inventory of powdered pigments that were subject to daily ins and outs, U.S. and Canadian currency, Metric and English Purchasing units, and other freight -in costs. This one was also used to do pre-production reservation of stock, so that nobody could end up using stock that was earmarked for another production batch. This application later served in another application where liquids were involved, and conversion to weight was needed. Another such large workbook application was a sales tracker for a car dealership. The dealership had 20 regular salesmen, each of which could sell up to 100 cars a month. Added to that was the fleet salesman, who could sell double that, as he was selling fleets typically to car rental companies. The workbook was about 25 sheets wide. 1 sheet for each salesman, another for the fleet salesman (total 21 sheets so far), then there were 2 summary sheets at the beginning. The sales department secretary entered all the sales data throughout the month, as each vehicle or fleet was sold, along with the model name, edition code for the model sold, length of the lease, profit figure for the sale, etc. At the end of the month, the 2 summary sheets were sorted and printed. Each of these sheets were about 1800 lines deep, and the formulate in most of the cells ran right off the edit line, they were so long. When the sheets were printed, each one only printed as many lines as there were records active, not the whole 1800 lines. The first of these print-out takeoffs went to the sales manager so he had a fast summary of what his sales staff were doing. The second went to the general manager, who, as far as I know used this to decide what cars he would order from the manufacturer for the next business cycle. since he was financially committed to the cost of those vehicles from the time they left the manufacturer, this made for a big financial responsibility. In this case, as we see, the application was serving 2 diverse sets of needs at the same time. My fee at the time to do that was about $CDN 365.00, although today it would be somewhat higher. I also have another application which related to an industry whose production is based on a recipe by weight which may also have ongoing experimental changes in the batch. Usually in this type of production, the recipe is predicated on a specific final batch weight which is based on the capacity of the mixing machinery used. When a client places an order for a much larger quantity, another part of the workbook calculates the total weight of each product needed for the whole order, which then becomes the pre-reservation in the inventory as previously mentioned. At the point where this transition happens, any stock shortages resulting from the calculation of the bill of materials for the client order are then passed to the purchasing agent who obtains the added stock needs. The purchasing agent, on advice from the marketing dept. and with financial executive approval, may increase the order to provide for expected demand, possibly getting a better price in the process due to his larger order. Best Regard$$$ On 11/18/2010 08:22, L Duperval wrote: Hi, In Excel 2K3, you can right-click on the sheet navigation arrows and have a list of all the sheets in the current workbook, so you can click on the one you need and go there directly. It makes it easier to navigate from one sheet to the other. What's the equivalent in Calc? Thanks, L -- Best Regards, Bruce Martin
Re: [users] changing OSes.
Dear Users: 1)As a generality: Hybridism of any kind has its upside and its downside (law of opposites is eternal and ubiquitous.) 2)Versatility and complexity go hand in hand. 3)Therefore anything that contains a degree of hybridism; i.e. Hybridism itself - has these pros and cons: 3a)Pro: Hybridism brings the added versitility and capabilities of each of its specialised and unique components,. This proportionality also applies to the closeness of the inter-relations between the various hybridised elements. 3b)Con: The greater the degree of the hybridism, and the greater the degree of close integration, the more complex it is to learn and understand, as is necessary to extract the benefits. Finally to me this appears to be simply common sense, so why do so many have difficulty with it? Using or changing from one OS to another is just an example of this. Each one has its pros and cons, and even If I only used, say, Windows XP, I could sill use multiple installations on the same machine with a single license to do things which I could not do with a single installation. This is particularly true with Twain applications and scanners or cameras that use specialised software and drivers, as one of mine does. On 11/12/2010 20:05, Mark C. Miller wrote: On 11/06/2010 02:05 PM, Twayne wrote: snip Most peope are happy with whichever OS they started with and don't think much about changing, whether that's good or bad I don't care; it's just a fact. Twayne` /snip It's called BDS -- Baby Duck Syndrome. Just like a baby duck, most computer user imprint on the first OS they use. And can become rather rabid about changing (that's part of a theory called Cognitive Dissonance). Changing the imprint can be difficult, but it's possible. I go back to MS-DOS and hated the thought of windows when I first saw it; I got better. I was pushed into the Unix world for awhile, but in reality I was thoroughly a Windows guy when I got a job teaching at a high school that was a Mac [infested!] environment. I stayed with my preference to Windows. Then a friend introduced me to Ubuntu (I didn't start until 8.04), and I've not looked back. Still, I get on line with an old friend from time-to-time and re-hash those early days when we thought we were HS. - Best Regards, Bruce Martin
Re: [users] Problem
Dear Ashok Ravinder: This lurking techie in the background suspects either you have a Java runtime problem or possibly a problem at one of the lower levels. These could be OS memory management in combination with the exact nature of your hardware, or possibly a hardware problem. RAM could also cause these problems, and intermittently to boot. also electrical power disturbances and/or heat problems could also be a part, but at a distance I suspect these are less likely. Sorry if this sounds complicated, but computers at the bottom level really arer all that and more. Usually we don't have to dig all that deep, but never say never. On 10/27/2010 02:48, Ashok Sinha wrote: I also faced similar problem many times and only solution I found was to reboot my computor and then I could open files . Some times even i had to uninstall openoffice and re-download openoffice 3.2 tosolve problems . Why it happens is not understood . Ashok Sinha From: ravinder singhme.ravinde...@gmail.com To: users@openoffice.org Sent: Fri, 22 October, 2010 12:41:27 AM Subject: [users] Problem Hello Sir/madam I am using open office 3.2. But I am facing big problem every time. when I need to open any word or excel file of open offfice.The problem is that file not open, after long wait does not find any receponce. why please help me,. Thanks Ravinder Singh - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Best Regards, Bruce Martin - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org