Re: [users] Re: What is the use case for multiple sheets in Calc?
On 03/11/2010 00:11, Andreas Säger wrote: Am 02.11.2010 23:20, Dotan Cohen wrote: Almost any use case for Calc could be massaged into a use case for Writer. ... if you are ready to change the entire document model including the file format standard which is based on one sequence of paragraphs and compatible to the competitor's document model. If the document model is wrong^Winappropriate, then it needs changing. The model should reflect real-world needs, not restrict usage. Compatibility with the competitor's model is surely a red herring. I'd never thought about the PP's issue, but it seems a valid point to raise. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Zotero and OOo 3.2.1 and FF 3.5.9
Does anyone have Zotero working with OOo 3.2.1 and Firefox 3.5.9 or later on Linux? If so, can you tell me what versions of the FF and OOo plugins you have installed? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Combining Mathematical Functions in a Spreadsheet
Hello, I am trying to create a spreadsheet to keep track of my work ours. This is what I have: Column A - Number of hours I've worked that day - X Column B - The amount I get paid per hour - Y Column C - The amount I get for bus fair per day - Z Column G - Should be the result (in currency format) of X multiplied by Y plus Z equals T. I was able to enter the following in column G: =PRODUCT(A2:A30,B2:B30) to get the result of money I get paid for the number of hours I worked. My problem is: What do I have to write to add the amount I get for a round trip by bus for that day. G has to be the final gross amount of money I get paid for that month. Thanks! -- .::. Amichai Rotman Registered Linux User#: 201192 [http://counter.li.org/] Registered Ubuntu User #12851 [http://ubuntucounter.geekosophical.net] .::.
Re: [users] Combining Mathematical Functions in a Spreadsheet
Amichai Rotman wrote: Hello, I am trying to create a spreadsheet to keep track of my work ours. This is what I have: Column A - Number of hours I've worked that day - X Column B - The amount I get paid per hour - Y Column C - The amount I get for bus fair per day - Z Column G - Should be the result (in currency format) of X multiplied by Y plus Z equals T. I was able to enter the following in column G: =PRODUCT(A2:A30,B2:B30) to get the result of money I get paid for the number of hours I worked. My problem is: What do I have to write to add the amount I get for a round trip by bus for that day. G has to be the final gross amount of money I get paid for that month. Thanks! Why not write the formula just as you stated it? Enter this in G1: = A1*B1+C1 Copy this formula in G2 through G31. To do this, click cell G1. A little square appears at the bottom right of that cell. Move the cursor over this little square. The cursor should become a +. Drag the little square down to cell G31. Finally, in H1 write this formula: = SUM(G1:G31) H1 will not have the final gross amount of money you get paid for a given month. (Remember that sometimes the 31st of a month is a work day.) Or if you want G1 to have the final gross amount, try this: = SUMPRODUCT(A1:A31;B1:B31) + SUM(C1:C31) SUMPRODUCT gives you the sum of all the products for X*Y, SUM gives the sum of all the Z. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Combining Mathematical Functions in a Spreadsheet
Thanks Dan! That last suggestion did exactly the trick! I was using a comma instead of a semicolon - and got an error. Thanks! On Wed, Nov 3, 2010 at 13:18, Daniel Lewis elderdanle...@gmail.com wrote: (A1:A31;B1:B31) + SUM(C1:C31) -- .::. Amichai Rotman Registered Linux User#: 201192 [http://counter.li.org/] Registered Ubuntu User #12851 [http://ubuntucounter.geekosophical.net] .::.
[users] Inserting Dates Automatically into a Column
Hi All, Continuing my last question: I'd like to create a Sheet for each month. In column A of each sheet I'd like to automatically generate the specific month's dates: Is there a wizard I can use to specify the dates range (say: Nov 2010 till December 2010) and it will create a Sheet for each month with the dates automatically entered in column A - from A2 to A31 (or 30, if that moth is shorter). Of course I want to use it on a different file for next year too I hope I was clear enough... Thanks! -- .::. Amichai Rotman Registered Linux User#: 201192 [http://counter.li.org/] Registered Ubuntu User #12851 [http://ubuntucounter.geekosophical.net] .::.
[users] VLOOKUP COUNTIF with numbers and text
VLOOKUP and COUNTIF will not find a numeric search value in a list of text cells. They will, however, find a text value in a list of numeric cells. Why one way but not the other? I am not a fan of strong typing in end-user applications (it's fine for programming languages, but not all spreadsheet users have a programmer's mindset or dilligence). At least VLOOKUP and COUNTIF are mutually consistent - Excel will not work either way in VLOOKUP, but works both ways (text in a list of numbers, and number in a list of texts) in COUNTIF. Having said that - if the list contains the text being looked for and the same value as a number, then COUNTIF as text will find both and return 2. If looking for it as a number, it only finds one of them. So, is 1 in the list once or twice? That depends on how you look. Not ideal. This inconsistency raises this behaviour from a feature to a bug in my opinion. Phil. -- Don't you just hate self-referential sigs?
Re: [users] Upgrade 3.1.1 to 3.2.1 (Fedora)
On 2010-11-02 1:16 PM, John Jason Jordan wrote: 3) I have a ton of personal settings and extensions in ~/.openoffice.org. Are there any issues with 3.2.1? The biggest reason for me not to upgrade was the loss of the colored document icons (they are all greyscale in 3.2.1)... I understand this huge (but admittedly only a cosmetic) bug is fixed in LibreOffice, Go-OO, and other alternatives... - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Opening a MIME file
I get a regular report from a system that generates a .xls file but it is MIME encoded, and looks like this: MIME-Version: 1.0 Content-Type: Multipart/Related; type=text/html; boundary=saw_part_boundary_0 --saw_part_boundary_0 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMC8vRU4iPg0KPGh0bWwg ZGlyP... Excel can open this file, but OpenOffice.org can't. Any suggestions? Phil Hibbs. -- Don't you just hate self-referential sigs? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: What is the use case for multiple sheets in Calc?
Personally, I'd be interested in having a composite document with Calc and Writer sheets in the same file. I'd like to have Calc cells directly referenced by Writer documents, without cross-document links that break easily. If an ODF document could have multiple tabs some of which are Calc sheets and some of which are Writer documents, that would be full of win. Unlikely to happen though. Phil Hibbs. -- Don't you just hate self-referential sigs? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: What is the use case for multiple sheets in Calc?
snip If my memory serves me correctly, I first encountered multiple sheets in a spreadsheet many years ago in Lotus 1-2-3 when it was touted as a 3D modeling tool. Two-dimensional data with identical formats in each sheet could be aggregated in a top sheet. Of course, the same result could be achieved by defining various zones in a single sheet, but review of the data in each sheet is facilitated by being able to go from tab to tab. One could imagine a document model in which associated writer, spreadsheet, database and presentation documents would be held in a single file, with the ability to reference data between them. OOo already allows some such interaction, albeit with data in separate files. I wouldn't hold my breath waiting for such a redesign to happen. Of course, if someone provided the resources... Jomali
[users] Re: [moderated]
william lepage william.lepage...@sympatico.ca wrote in message news:blu0-smtp91020e4c830c5b583be22bcc...@phx.gbl... How do I open ppp power point presentations I think you mean ppt. You can either associate .ppt files to OpenOffice.org after which a double click will invoke Impress, or just right click on one of the files in question and choose Open with The former is permanent (till you change the association). The latter needs doing every time unless you choose the always open with ... option. Please note that strictly speaking this is a Windows question, not an OpenOffice.org question. Using File Associations is a fundamental part of using Windows. See the Windows Help for more details. -- Harold Fuchs London, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: What is the use case for multiple sheets in Calc?
On 03/11/10 14:25, Phil Hibbs wrote: Personally, I'd be interested in having a composite document with Calc and Writer sheets in the same file. I'd like to have Calc cells directly referenced by Writer documents, without cross-document links that break easily. If an ODF document could have multiple tabs some of which are Calc sheets and some of which are Writer documents, that would be full of win. Unlikely to happen though. And while we're at it, lose the distinction between Writer and Draw; it's unnecessary. Beware low flying pigs. Actually, the distinction between 'spreadsheet', 'word processor' and 'drawing' is unnecessary and a thorough nuisance, I guess based on practice born of historical necessity. Look at the inconsistent mess in OOo where nominally similar/the same things are treated quite differently (Calc and tables in Writer [/why/ do they have different syntax?]; fields in Writer and Draw [Draw offers a most miserly subset]; graphics object treatment in Writer and Draw [just try aligning two objects in Writer!!]; text frames in Write and Draw [I want to flow text between frames in Draw yes, well :-{ ].. I won't go on!) I'd better find a nice parapet to duck behind. :-} -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: [moderated]
Harold, you might want to check your computer clock. It appears you sent this message on Sunday. One thing I recommend is to configure computers to use NTP, which sets the clock very accurately. http://en.wikipedia.org/wiki/Network_Time_Protocol Harold Fuchs wrote: william lepage william.lepage...@sympatico.ca wrote in message news:blu0-smtp91020e4c830c5b583be22bcc...@phx.gbl... How do I open ppp power point presentations I think you mean ppt. You can either associate .ppt files to OpenOffice.org after which a double click will invoke Impress, or just right click on one of the files in question and choose Open with The former is permanent (till you change the association). The latter needs doing every time unless you choose the always open with ... option. Please note that strictly speaking this is a Windows question, not an OpenOffice.org question. Using File Associations is a fundamental part of using Windows. See the Windows Help for more details. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Presentation query
Hi all, I have Open office 3.2 installed on ubuntu 10.04, my query is , when opening a .pps presentation it goes staight into a slide show, is there any way I can set it so that it will not go to the slide show without my actually telling it? Many thanks in advance. Take Care Winton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On Tue, 2 Nov 2010 18:27:01 -0700 Julie Flaming julie.flam...@gmail.com dijo: I've been having huge Zotero problems for months! Glad to know it's not just me. Not sure about any answers for you, though. 8-( I finally succeeded in getting Zotero working in OOo 3.2.1 and Firefox 3.5.9 on Fedora 11. How to do it is kind of involved, but there is a thread on the Zotero forums where my trek is documented: http://forums.zotero.org/discussion/15016/firefox-could-not-load-the-component/#Comment_74429 I hope that helps someone else get Zotero working. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On 11/03/10 13:14, John Jason Jordan wrote: On Tue, 2 Nov 2010 18:27:01 -0700 Julie Flaming julie.flam...@gmail.com dijo: I've been having huge Zotero problems for months! Glad to know it's not just me. Not sure about any answers for you, though. 8-( I finally succeeded in getting Zotero working in OOo 3.2.1 and Firefox 3.5.9 on Fedora 11. How to do it is kind of involved, but there is a thread on the Zotero forums where my trek is documented: http://forums.zotero.org/discussion/15016/firefox-could-not-load-the-component/#Comment_74429 I hope that helps someone else get Zotero working. I had to reinstall OOo and cannot get it to Stop Recovering Untitled 1. Did not have this before I tried Zotero on Ubuntu 10.10. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] OT: Sending Email on Sundays (was [users] Re: [moderated])
On 03/11/2010 14:54, James Knott wrote: Harold, you might want to check your computer clock. It appears you sent this message on Sunday. One thing I recommend is to configure computers to use NTP, which sets the clock very accurately. Errm. Yes, I did send it on Sunday. At about twenty to eight in the evening my time. Why do you feel it necessary to comment or to think that my computer clock may be wrong? I use NIST's time server. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Unsub
Pls unsubscribe me from all OO mailings. Thanks, Lisa On Wed, 3 Nov 2010 14:17:34 +, Phil Hibbs sna...@gmail.com wrote: I get a regular report from a system that generates a .xls file but it is MIME encoded, and looks like this: MIME-Version: 1.0 Content-Type: Multipart/Related; type=text/html; boundary=saw_part_boundary_0 --saw_part_boundary_0 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMC8vRU4iPg0KPGh0bWwg ZGlyP... Excel can open this file, but OpenOffice.org can't. Any suggestions? Phil Hibbs. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Inserting Dates Automatically into a Column
On 03/11/2010 12:55, Amichai Rotman wrote: Hi All, Continuing my last question: I'd like to create a Sheet for each month. In column A of each sheet I'd like to automatically generate the specific month's dates: Is there a wizard I can use to specify the dates range (say: Nov 2010 till December 2010) and it will create a Sheet for each month with the dates automatically entered in column A - from A2 to A31 (or 30, if that moth is shorter). Of course I want to use it on a different file for next year too I hope I was clear enough... Thanks! Amichai I think the easiest way is this. 1) Create a start spreadsheet. 2) On the top line cell A1 type in the 1st date in the month e.g. 1/11/10 3) On the second line below the 1st date set a cell a2 with = a1 + 1. The cell will show 2/11/10 4) Copy cell a2 downwards for as many days as you require and the dates will appear. 5) In a new spreadsheet copy and paste the 31 days you require from the first spreadsheet. Change the date at the top of the column to be whatever start date you require and all the others will appear. I hope that it clear Thanks Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Unsub
On Wed, 03 Nov 2010 19:20:25 + Lisa Hebbard lisahebb...@cooptel.net wrote: Hello Lisa, Pls unsubscribe me from all OO mailings. We, as users, can't do that for you. Instructions for how to do it are included in most messages that are sent out via the list server. Just in case; quote To unsubscribe, e-mail: users-unsubscr...@openoffice.org /quote -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent I hope I live to relive the days gone by Old Before I Die - Robbie Williams signature.asc Description: PGP signature
Re: [users] Upgrade 3.1.1 to 3.2.1 (Fedora)
Tanstaafl wrote: On 2010-11-02 1:16 PM, John Jason Jordan wrote: 3) I have a ton of personal settings and extensions in ~/.openoffice.org. Are there any issues with 3.2.1? The biggest reason for me not to upgrade was the loss of the colored document icons (they are all greyscale in 3.2.1)... I understand this huge (but admittedly only a cosmetic) bug is fixed in LibreOffice, Go-OO, and other alternatives... Tools Options OpenOffice.org View. Look in the Icon size and style section, right dropdown list. I'm not sure what your selection is (Automatic Galaxy, Galaxy (Default), High Contrast, Industrial, Crystal, Tango, Oxygen, or Classic). But try some other selections. Some of them will be colored icons. I use Galaxy (Default). Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On Wed, 03 Nov 2010 14:34:14 -0400 webmas...@krackedpress.com webmas...@krackedpress.com dijo: On 11/03/10 13:14, John Jason Jordan wrote: On Tue, 2 Nov 2010 18:27:01 -0700 Julie Flaming julie.flam...@gmail.com dijo: I've been having huge Zotero problems for months! Glad to know it's not just me. Not sure about any answers for you, though. 8-( I finally succeeded in getting Zotero working in OOo 3.2.1 and Firefox 3.5.9 on Fedora 11. How to do it is kind of involved, but there is a thread on the Zotero forums where my trek is documented: http://forums.zotero.org/discussion/15016/firefox-could-not-load-the-component/#Comment_74429 I hope that helps someone else get Zotero working. I had to reinstall OOo and cannot get it to Stop Recovering Untitled 1. Did not have this before I tried Zotero on Ubuntu 10.10. What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: What is the use case for multiple sheets in Calc?
Am 03.11.2010 08:53, Mike Scott wrote: On 03/11/2010 00:11, Andreas Säger wrote: Am 02.11.2010 23:20, Dotan Cohen wrote: Almost any use case for Calc could be massaged into a use case for Writer. ... if you are ready to change the entire document model including the file format standard which is based on one sequence of paragraphs and compatible to the competitor's document model. If the document model is wrong^Winappropriate, then it needs changing. The model should reflect real-world needs, not restrict usage. Compatibility with the competitor's model is surely a red herring. Who says it's wrong? It reflects most of the documents saving the user data of the last decades. Throwing away seven million lines of code because someone thinks it could be a good idea to reanimate MS Binder[1] would be the end of this project. There is plenty of page oriented software, even free one. [1] http://en.wikipedia.org/wiki/Microsoft_Binder - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On 11/03/10 15:36, John Jason Jordan wrote: On Wed, 03 Nov 2010 14:34:14 -0400 webmas...@krackedpress.com webmas...@krackedpress.com dijo: On 11/03/10 13:14, John Jason Jordan wrote: On Tue, 2 Nov 2010 18:27:01 -0700 Julie Flaming julie.flam...@gmail.com dijo: I've been having huge Zotero problems for months! Glad to know it's not just me. Not sure about any answers for you, though. 8-( I finally succeeded in getting Zotero working in OOo 3.2.1 and Firefox 3.5.9 on Fedora 11. How to do it is kind of involved, but there is a thread on the Zotero forums where my trek is documented: http://forums.zotero.org/discussion/15016/firefox-could-not-load-the-component/#Comment_74429 I hope that helps someone else get Zotero working. I had to reinstall OOo and cannot get it to Stop Recovering Untitled 1. Did not have this before I tried Zotero on Ubuntu 10.10. What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. The search finds none. The trouble is that the Recovery system freezes and you cannot get the window to close by pressing Finish, or xing out the box. I cannot even get it to force the closing. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
Hello webmaster, On Wednesday 03 November 2010, 16:53, webmas...@krackedpress.com wrote: What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. The search finds none. The trouble is that the Recovery system freezes and you cannot get the window to close by pressing Finish, or xing out the box. I cannot even get it to force the closing. you have to shutdown OpenOffice.org, including the quickstarter, and manipulate some configuration file, because the recovery information is stored inside OOo registry, in the configuration node /org.openoffice.Office.Recovery What OpenOffice.org version are you using? and which operative system? Regards -- Ariel Constenla-Haile La Plata, Argentina signature.asc Description: This is a digitally signed message part.
Re: [users] Broken Zotero
Thanks! I'll try this. On Wed, Nov 3, 2010 at 10:14 AM, John Jason Jordan johnjas...@gmail.comwrote: On Tue, 2 Nov 2010 18:27:01 -0700 Julie Flaming julie.flam...@gmail.com dijo: I've been having huge Zotero problems for months! Glad to know it's not just me. Not sure about any answers for you, though. 8-( I finally succeeded in getting Zotero working in OOo 3.2.1 and Firefox 3.5.9 on Fedora 11. How to do it is kind of involved, but there is a thread on the Zotero forums where my trek is documented: http://forums.zotero.org/discussion/15016/firefox-could-not-load-the-component/#Comment_74429 I hope that helps someone else get Zotero working. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Unsub
Some of us have tried and the system won't let us unsubscribe. I've even written to the owner of one list and didn't even get an acknowledgement. I still get the mail, though. Alan Frayer E-Commerce Manager Goodwill Industries-Suncoast, Inc. http://www.goodwill too.com On Nov 3, 2010, at 3:29 PM, Brad Rogers b...@fineby.me.uk wrote: On Wed, 03 Nov 2010 19:20:25 + Lisa Hebbard lisahebb...@cooptel.net wrote: Hello Lisa, Pls unsubscribe me from all OO mailings. We, as users, can't do that for you. Instructions for how to do it are included in most messages that are sent out via the list server. Just in case; quote To unsubscribe, e-mail: users-unsubscr...@openoffice.org /quote -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent I hope I live to relive the days gone by Old Before I Die - Robbie Williams - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Unsub
On Wednesday 03 November 2010 23:20:03 Alan Frayer wrote: Some of us have tried and the system won't let us unsubscribe. I've even written to the owner of one list and didn't even get an acknowledgement. I still get the mail, though. WHAT system won't let you unsubscribe? If you speak of one list, it sounds like you haven't been able to unsubscribe from several lists. If you send your unsubscribe requests in the manner prescribed by the particular list, it has to work. For example, just writing Unsub in the subject line is bound NOT to work. In any case, there is literally nobody here that is able to unsubscribe you. Alan Frayer E-Commerce Manager Goodwill Industries-Suncoast, Inc. http://www.goodwill too.com On Nov 3, 2010, at 3:29 PM, Brad Rogers b...@fineby.me.uk wrote: On Wed, 03 Nov 2010 19:20:25 + Lisa Hebbard lisahebb...@cooptel.net wrote: Hello Lisa, Pls unsubscribe me from all OO mailings. We, as users, can't do that for you. Instructions for how to do it are included in most messages that are sent out via the list server. Just in case; quote To unsubscribe, e-mail: users-unsubscr...@openoffice.org /quote - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Stan Goodman Qiryat Tiv'on Israel - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: VLOOKUP COUNTIF with numbers and text
Am 03.11.2010 14:02, Phil Hibbs wrote: VLOOKUP and COUNTIF will not find a numeric search value in a list of text cells. They will, however, find a text value in a list of numeric cells. Why one way but not the other? I am not a fan of strong typing in end-user applications (it's fine for programming languages, but not all spreadsheet users have a programmer's mindset or dilligence). At least VLOOKUP and COUNTIF are mutually consistent - Excel will not work either way in VLOOKUP, but works both ways (text in a list of numbers, and number in a list of texts) in COUNTIF. Having said that - if the list contains the text being looked for and the same value as a number, then COUNTIF as text will find both and return 2. If looking for it as a number, it only finds one of them. So, is 1 in the list once or twice? That depends on how you look. Not ideal. This inconsistency raises this behaviour from a feature to a bug in my opinion. Phil. Pardon? What are you talking about? Would you mind to post some example data? A spreadsheet *is* a simplified programming language. You will get wrong results if you do not understand the difference between 123 and 123 or the difference between values and formatting. What you get is not what you see. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On 11/03/10 16:15, Ariel Constenla-Haile wrote: Hello webmaster, On Wednesday 03 November 2010, 16:53, webmas...@krackedpress.com wrote: What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. The search finds none. The trouble is that the Recovery system freezes and you cannot get the window to close by pressing Finish, or xing out the box. I cannot even get it to force the closing. you have to shutdown OpenOffice.org, including the quickstarter, and manipulate some configuration file, because the recovery information is stored inside OOo registry, in the configuration node /org.openoffice.Office.Recovery What OpenOffice.org version are you using? and which operative system? Regards They Tell me I am using Go-oo 3.2.1 OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1 using Ubuntu 10.10 64 bit version on a quad-core desktop. How do you turn off the quickstarter in Ubuntu? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Opening a MIME file
From: Phil Hibbs sna...@gmail.com | I get a regular report from a system that generates a .xls file but it | is MIME encoded, and looks like this: | MIME-Version: 1.0 | Content-Type: Multipart/Related; | type=text/html; | boundary=saw_part_boundary_0 | --saw_part_boundary_0 | Content-Type: text/html; charset=windows-1252 | Content-Transfer-Encoding: base64 | PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMC8vRU4iPg0KPGh0bWwg | ZGlyP... | Excel can open this file, but OpenOffice.org can't. Any suggestions? | Phil Hibbs. | -- | Don't you just hate self-referential sigs? Why is this regular report being generated as an a MIME encoded .xls file ? Is it sent by email ? WinZIP and other archivers can open MIME encoded files. Have you tried that method ? -- Dave Multi-AV Scanning Tool - http://www.pctipp.ch/downloads/dl/35905.asp - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
Hello webmaster, On Wednesday 03 November 2010, 20:27, webmas...@krackedpress.com wrote: On 11/03/10 16:15, Ariel Constenla-Haile wrote: Hello webmaster, On Wednesday 03 November 2010, 16:53, webmas...@krackedpress.com wrote: What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. The search finds none. The trouble is that the Recovery system freezes and you cannot get the window to close by pressing Finish, or xing out the box. I cannot even get it to force the closing. you have to shutdown OpenOffice.org, including the quickstarter, and manipulate some configuration file, because the recovery information is stored inside OOo registry, in the configuration node /org.openoffice.Office.Recovery What OpenOffice.org version are you using? and which operative system? Regards They Tell me I am using Go-oo 3.2.1 OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1 using Ubuntu 10.10 64 bit version on a quad-core desktop. How do you turn off the quickstarter in Ubuntu? simply right-click on the system tray icon and select the last menu option: Exit quickstarter. do a ~]$ pgrep soffice.bin to make sure there is no instance running. If this commands returns a number, then this is the number that identifies the process, and yo have to kill that process: ]$ kill -kill PROCESS_NUMBER or ]$ kill -kill `pgrep soffice.bin` Then you can safely change the configuration file: go to your OOo user directory. Vanilla OOo, and some distros (like Fedora) use the default directory: ~/.openoffice.org/3/user IIRC for go-oo it may be: ~/.ooo/3/user you can check the right value in the Options dialog (menu Tools - Options - OpenOffice.org - Paths), for example, my Path for AutoText is /home/ariel/.openoffice.org/3/user/autotext this means the user dir. is a hidden folder located at /home/ariel/.openoffice.org/3/user/ Then go to ~/.openoffice.org/3/user/registry/data/org/openoffice/Office and look at the Recovery.xcu file, sure you will find in it an entry in the RecoveryList node, this indicates there is file to recover (in your case, your the property Title has for value Untitled 1 ). If you know something about XML, remove every node in the RecoveryList. If not, simply remove the whole Recovery.xcu file. This should fix your issue. If not, please report back. Regards -- Ariel Constenla-Haile La Plata, Argentina signature.asc Description: This is a digitally signed message part.
Re: [users] Presentation query
2010/11/3 squareyes square...@internode.on.net: Hi all, I have Open office 3.2 installed on ubuntu 10.04, my query is , when opening a .pps presentation it goes staight into a slide show, is there any way I can set it so that it will not go to the slide show without my actually telling it? Hello, squareyes! Yes, you can. Just change file extension from .pps to .ppt. -- Tarball 74r8...@gmail.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Unsub
Apparently the address that I use to receive emails is not the same as the one my ISP sends, but my ISP translates it on their server. As a result, my unsub command carries an address that isn't in the database, and every attempt to modify the acknowledgement email has failed, as I'm still getting messages. And while the typical reader/volunteer cannot help, a moderator must occasionally read these messages, and that person can bring this to the attention of the list owner (who apparently ignores emails written by me directly). And yes, I'm on this list and the Discuss list, so I am speaking of multiple lists. I apologize for hijacking the original thread, but I can't think of any better way to get a moderator's attention without being obnoxious. Alan Frayer E-Commerce Manager Goodwill Industries-Suncoast, Inc. http://www.goodwill too.com On Nov 3, 2010, at 5:50 PM, Stan Goodman stan.good...@hashkedim.com wrote: On Wednesday 03 November 2010 23:20:03 Alan Frayer wrote: Some of us have tried and the system won't let us unsubscribe. I've even written to the owner of one list and didn't even get an acknowledgement. I still get the mail, though. WHAT system won't let you unsubscribe? If you speak of one list, it sounds like you haven't been able to unsubscribe from several lists. If you send your unsubscribe requests in the manner prescribed by the particular list, it has to work. For example, just writing Unsub in the subject line is bound NOT to work. In any case, there is literally nobody here that is able to unsubscribe you. Alan Frayer E-Commerce Manager Goodwill Industries-Suncoast, Inc. http://www.goodwill too.com On Nov 3, 2010, at 3:29 PM, Brad Rogers b...@fineby.me.uk wrote: On Wed, 03 Nov 2010 19:20:25 + Lisa Hebbard lisahebb...@cooptel.net wrote: Hello Lisa, Pls unsubscribe me from all OO mailings. We, as users, can't do that for you. Instructions for how to do it are included in most messages that are sent out via the list server. Just in case; quote To unsubscribe, e-mail: users-unsubscr...@openoffice.org /quote - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Stan Goodman Qiryat Tiv'on Israel - 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] Presentation query
On 04/11/10 11:08, Tarball wrote: 2010/11/3 squareyessquare...@internode.on.net: Hi all, I have Open office 3.2 installed on ubuntu 10.04, my query is , when opening a .pps presentation it goes staight into a slide show, is there any way I can set it so that it will not go to the slide show without my actually telling it? Hello, squareyes! Yes, you can. Just change file extension from .pps to .ppt. Many thanks Tarball and Brian, am just a control freak, like to be able to do what I want. Don't like machines telling me what to do :-) Take care Winton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On 11/03/2010 08:05 PM, Ariel Constenla-Haile wrote: Hello webmaster, On Wednesday 03 November 2010, 20:27, webmas...@krackedpress.com wrote: On 11/03/10 16:15, Ariel Constenla-Haile wrote: Hello webmaster, On Wednesday 03 November 2010, 16:53, webmas...@krackedpress.com wrote: What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. The search finds none. The trouble is that the Recovery system freezes and you cannot get the window to close by pressing Finish, or xing out the box. I cannot even get it to force the closing. you have to shutdown OpenOffice.org, including the quickstarter, and manipulate some configuration file, because the recovery information is stored inside OOo registry, in the configuration node /org.openoffice.Office.Recovery What OpenOffice.org version are you using? and which operative system? Regards They Tell me I am using Go-oo 3.2.1 OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1 using Ubuntu 10.10 64 bit version on a quad-core desktop. How do you turn off the quickstarter in Ubuntu? simply right-click on the system tray icon and select the last menu option: Exit quickstarter. do a ~]$ pgrep soffice.bin to make sure there is no instance running. If this commands returns a number, then this is the number that identifies the process, and yo have to kill that process: ]$ kill -kill PROCESS_NUMBER or ]$ kill -kill `pgrep soffice.bin` Then you can safely change the configuration file: go to your OOo user directory. Vanilla OOo, and some distros (like Fedora) use the default directory: ~/.openoffice.org/3/user IIRC for go-oo it may be: ~/.ooo/3/user you can check the right value in the Options dialog (menu Tools - Options - OpenOffice.org - Paths), for example, my Path for AutoText is /home/ariel/.openoffice.org/3/user/autotext this means the user dir. is a hidden folder located at /home/ariel/.openoffice.org/3/user/ Then go to ~/.openoffice.org/3/user/registry/data/org/openoffice/Office and look at the Recovery.xcu file, sure you will find in it an entry in the RecoveryList node, this indicates there is file to recover (in your case, your the property Title has for value Untitled 1 ). If you know something about XML, remove every node in the RecoveryList. If not, simply remove the whole Recovery.xcu file. This should fix your issue. If not, please report back. Regards Sorry Did not work OOo keeps crashing due to a unexpected error I edit the file, I remove the file, but no go. = - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
Hello webmaster, On Wednesday 03 November 2010, 22:37, webmas...@krackedpress.com wrote: On 11/03/2010 08:05 PM, Ariel Constenla-Haile wrote: Hello webmaster, On Wednesday 03 November 2010, 20:27, webmas...@krackedpress.com wrote: On 11/03/10 16:15, Ariel Constenla-Haile wrote: Hello webmaster, On Wednesday 03 November 2010, 16:53, webmas...@krackedpress.com wrote: What happens if you close OOo, then using your file browser search for Untitled 1, and when you find it, delete it. Then relaunch OOo. I think OOo automatically creates backup copies as well, but I've never needed them so I don't know where they are. The Help file should tell you. Also, if there is an Untitled 1 with the backups it should show up with the file browser search. The search finds none. The trouble is that the Recovery system freezes and you cannot get the window to close by pressing Finish, or xing out the box. I cannot even get it to force the closing. you have to shutdown OpenOffice.org, including the quickstarter, and manipulate some configuration file, because the recovery information is stored inside OOo registry, in the configuration node /org.openoffice.Office.Recovery What OpenOffice.org version are you using? and which operative system? Regards They Tell me I am using Go-oo 3.2.1 OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1 using Ubuntu 10.10 64 bit version on a quad-core desktop. How do you turn off the quickstarter in Ubuntu? simply right-click on the system tray icon and select the last menu option: Exit quickstarter. do a ~]$ pgrep soffice.bin to make sure there is no instance running. If this commands returns a number, then this is the number that identifies the process, and yo have to kill that process: ]$ kill -kill PROCESS_NUMBER or ]$ kill -kill `pgrep soffice.bin` Then you can safely change the configuration file: go to your OOo user directory. Vanilla OOo, and some distros (like Fedora) use the default directory: ~/.openoffice.org/3/user IIRC for go-oo it may be: ~/.ooo/3/user you can check the right value in the Options dialog (menu Tools - Options - OpenOffice.org - Paths), for example, my Path for AutoText is /home/ariel/.openoffice.org/3/user/autotext this means the user dir. is a hidden folder located at /home/ariel/.openoffice.org/3/user/ Then go to ~/.openoffice.org/3/user/registry/data/org/openoffice/Office and look at the Recovery.xcu file, sure you will find in it an entry in the RecoveryList node, this indicates there is file to recover (in your case, your the property Title has for value Untitled 1 ). If you know something about XML, remove every node in the RecoveryList. If not, simply remove the whole Recovery.xcu file. This should fix your issue. If not, please report back. Regards Sorry Did not work OOo keeps crashing due to a unexpected error I edit the file, I remove the file, but no go. then you have *another* type of error: it is not the recovery that tries to recover a file that makes OOo crash, but simply a crash on the application start-up. Did I get it right? If this crash started after installing Zotero, you will have to remove the extension manually (delate the folder in the user directory). If you just want to test first that this is indeed a problem with your user installation, run OOo from the console with a brand new user profile, like this: ]$ soffice -env:UserInstallation=file:///tmp/ooo-user-dir this will create (and use) a new user dir. in /tmp/ooo-user-dir If everything works fine with this brand new user dir., then the problem is in your user dir. Regards -- Ariel Constenla-Haile La Plata, Argentina signature.asc Description: This is a digitally signed message part.
[users] Re: Broken Zotero
On 11/03/2010 04:27 PM, webmas...@krackedpress.com wrote: ... using Ubuntu 10.10 64 bit version on a quad-core desktop. How do you turn off the quickstarter in Ubuntu? Start a new thread... this has *nothing* to do with Zotero. Nor does it have anything to do with standard OOo which has QS off by default (linux). https://bugs.launchpad.net/bugs/562027 [[ooo-build] OOo QuickStarter: unable to shutdown / reboot / logout when quickstarter is active] - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Broken Zotero
On 11/03/10 22:06, Ariel Constenla-Haile wrote: Hello webmaster, Sorry Did not work OOo keeps crashing due to a unexpected error I edit the file, I remove the file, but no go. then you have *another* type of error: it is not the recovery that tries to recover a file that makes OOo crash, but simply a crash on the application start-up. Did I get it right? If this crash started after installing Zotero, you will have to remove the extension manually (delate the folder in the user directory). If you just want to test first that this is indeed a problem with your user installation, run OOo from the console with a brand new user profile, like this: ]$ soffice -env:UserInstallation=file:///tmp/ooo-user-dir this will create (and use) a new user dir. in /tmp/ooo-user-dir If everything works fine with this brand new user dir., then the problem is in your user dir. Regards I even tried to deal with Oracle's OOo, but no luck. Even worse. I then deleted every OOo folder I could outside of the TERMINAL and no sudo. After that, I reinstalled the .deb files again. So far, it is not crashing. Now I have to reinstall all my extensions. But not going near Zotero. Well I no longer using Go-oo 3.2.1 but Oracle's version on OOo's site OOO320m18 (Build:9502) This version already has given me the pop-up about and upgrade available. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Broken Zotero
On 11/03/10 22:22, NoOp wrote: On 11/03/2010 04:27 PM, webmas...@krackedpress.com wrote: ... using Ubuntu 10.10 64 bit version on a quad-core desktop. How do you turn off the quickstarter in Ubuntu? Start a new thread... this has *nothing* to do with Zotero. Nor does it have anything to do with standard OOo which has QS off by default (linux). https://bugs.launchpad.net/bugs/562027 [[ooo-build] OOo QuickStarter: unable to shutdown / reboot / logout when quickstarter is active] Well it was Zotero that caused the problems. BUT now I am using the version from OOo's site, not Go-oo's version that came with Ubuntu. We shall see if it stays fixed. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] [http://qa.openoffice.org/issues/show_bug.cgi?id=112163 - Multiple sheets in Writer] Re: What is the use case for multiple sheets in Calc?
On 11/02/2010 02:17 AM, Dotan Cohen wrote: Thanks, all. I am looking to build support with these use cases for a parallel feature in Writer: http://qa.openoffice.org/issues/show_bug.cgi?id=112163 So why not just put that in the subject rather than having folks rehash the history of the spreadsheet? Personally I think your example for a single file with multiple documents: quote Example: _Desired_Writer_behaviour_: The user would open resume.odt and within that file are three sheets: englishResume, hebrewResume, and russianResume. Within the single resume.ods file are three different, but related documents. /quote is flawed. Master documents takes care of that situation if they are to be merged. And it is not much of an effort to simply open all three in individual windows w/multiple instances of OOo - you can do this with 'Window' select window/resize to show side-by-side etc. I think a better example would tabbed sections; for a book writer each tab would be for each chapter, or a screen writer where each tab would be for each scene. In the end, both the book writer screen writer would be able to create links, etc., between the individual tabs/sections for cross referencing, styles, etc. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org