Re: [libreoffice-users] how to have output in table from calc data?

2011-08-06 Thread planas
Hi On Sat, 2011-08-06 at 11:06 +0530, soumalya ray wrote: hi, i searched for this but since i am totally new to calc i could not even understand what to search for. i have calc sheet named students demography with the name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need

Re: [libreoffice-users] how to have output in table from calc data?

2011-08-06 Thread soumalya ray
thanks.will try let you know On 6 August 2011 12:26, planas jsloz...@gmail.com wrote: Hi On Sat, 2011-08-06 at 11:06 +0530, soumalya ray wrote: hi, i searched for this but since i am totally new to calc i could not even understand what to search for. i have calc sheet named students

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread Stan Goodman
On 08/06/2011 06:25 AM, planas wrote: On Fri, 2011-08-05 at 20:53 +, toki wrote: On 08/05/2011 05:57 PM, upscope wrote: our government is looking for big budget cuts. One would be replace all the MS stuff with open source software. If the united states government, or the government

Re: [libreoffice-users] Printing

2011-08-06 Thread Cor Nouws
Hi Alaric, Alaric wrote (06-08-11 03:23) Can anyone help with a print problem. I cannot print landscape. The page style says landscape, the printer settings menu says landscape, the printer properties menu says landscape and the preview screen says landscape but the printer says portrait and

Re: [libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread Onyeibo Oku
On 06/08/2011 06:40, Andrew Douglas Pitonyak wrote: snip Removed sheets may have references, a new sheet can not have any references nor is it referenced. bAC = isAutomaticCalculationEnabled() doc.enableAutomaticCalculation(False) do_stuff doc.enableAutomaticCalculation(bAC) Thanks

Re: [libreoffice-users] Printing

2011-08-06 Thread Alaric
On 06/08/11 19:46, Cor Nouws wrote: Hi Alaric, Alaric wrote (06-08-11 03:23) Can anyone help with a print problem. I cannot print landscape. The page style says landscape, the printer settings menu says landscape, the printer properties menu says landscape and the preview screen says landscape

[libreoffice-users] Re: Base / Postgresql support

2011-08-06 Thread ponsiarceds
No luck with the sdbc driver. I disabled the driver then removed it. I even went so far as to rename my /.libreoffice dir, re-install it start afresh. Looking at https://bugs.freedesktop.org/show_bug.cgi?id=35784 the driver is currently broken. JDBC works, but it might be slower. -

Re: [libreoffice-users] Printing

2011-08-06 Thread Tom Davies
Hi :) You know that Mageia is almost identical to Mandriva but looks like it's going to be a much more stable organisation? It's likely to develop faster than Mandriva too as it is unlikely to get side-tracked by external politics or general craziness. It's a bit like what LibreOffice and the

Re: [libreoffice-users] Printing

2011-08-06 Thread Tom Davies
Hi :) This guide would let you install both side-by-side http://wiki.documentfoundation.org/Installing_in_parallel I think it's good to have options Regards from Tom :) From: Alaric um@xtra.co.nz To: users@global.libreoffice.org Sent: Sat, 6 August, 2011

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread Tom Davies
Hi :) Yes, hence the use of TCO (=Total Cost of Ownership). Macs usually have a much lower TCO than MS because systems are less prone to malware and need less maintenance. Also they are a status symbol so who cares if it actually works or not? TCO is not just licensing and re-training

Re: [libreoffice-users] new book

2011-08-06 Thread Chad Homan
Thanks, look awesome. Keep up the great work On Sat, Aug 6, 2011 at 12:34 AM, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Your very welcome! On 08/05/2011 09:22 PM, jorge wrote: Thank You Mr. Pitonyak for your Book. El vie, 05-08-2011 a las 09:49 -0300, rogerio dandrea

Re: [libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread Tom Davies
Hi :) Sorry for side-tracking this but what is this listener you refer to? Just curious because it's new to me. Regards from Tom :) From: twohot two...@fedoraproject.org To: users@global.libreoffice.org Sent: Sat, 6 August, 2011 6:14:15 Subject: Re:

[libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread Andreas Säger
General rule of thumb: 99% of all spreadsheet macros are potentially harmful, counter productive, badly implemented and reveal nothing but the author's ignorance against the underlying spreadsheet application. Could it be that a most simple database would solve all your problems without a

[libreoffice-users] Re: looking for help on Base

2011-08-06 Thread Andreas Säger
It appears to still have issues. I'm getting this error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed I'll post back when I get it figured out. Since many years I have never read some write-up where somebody managed to access mdb under Linux nor Mac.

[libreoffice-users] Extending selection in Calc (LibreOffice 3.4.2, Linux)

2011-08-06 Thread chimak111
Hello, I'm using LibreOffice 3.4.2 OOO340m1 (Build:203) on a PC running Linux Mint 11. I'm having difficulty with extending a selection as I'll try to describe below. I have six columns with headers named A: date B: scrip C: buy D: total E: cum avg F: shares Every cell in the first four columns

Re: [libreoffice-users] new book

2011-08-06 Thread Vic Dura
new book http://www.pitonyak.org/OOME_**3_0.odthttp://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work +1 on that. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread Onyeibo Oku
Hi I'm thinking of the best way to explain. its a code that is attached to a software object that monitors that object for changes and runs another code as a result. For example you may want your alarm to ring by 7pm so you set up a code to watch (listen to) the system clock and tell that

Re: [libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread Tom Davies
Hi :) Lol, wow!! That sounds scarily intriguing. Suddenly gives me 1 more reason to trust OpenSource more than proprietary code! Thanks and regards from Tom :) From: Onyeibo Oku twoho...@gmail.com To: Libre, Users users@global.libreoffice.org Sent: Sat, 6

Re: [libreoffice-users] new book

2011-08-06 Thread webmaster for Kracked Press Productions
On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil 498 pages

Re: [libreoffice-users] Problem with subscript in Impress

2011-08-06 Thread Ilja Gerhardt
I observe a similar behavior in LO 3.4.? under Ubuntu Linux. I am also coming from the Chemistry perspective here. It seems to be better now. I basically work with one font (Gill Sans) and had the feeling that it might be better with different fonts (Arial). A workaround here would be to align

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread soumalya ray
this post is getting very interesting On 6 August 2011 17:13, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Yes, hence the use of TCO (=Total Cost of Ownership). Macs usually have a much lower TCO than MS because systems are less prone to malware and need less maintenance. Also they are

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread webmaster for Kracked Press Productions
On 08/06/2011 07:43 AM, Tom Davies wrote: Hi :) Yes, hence the use of TCO (=Total Cost of Ownership). Macs usually have a much lower TCO than MS because systems are less prone to malware and need less maintenance. Also they are a status symbol so who cares if it actually works or not? TCO is

Re: [libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread Onyeibo Oku
1) True but what I'm doing is more computational than relational though the end result will be a material for building a proper database. A spreadsheet is more suited for this ... Trust me on this. 2) All the macro does is create and remove sheets as needed (for now). All calculations are done

Re: [libreoffice-users] new book

2011-08-06 Thread Tom Cloyd
On 08/06/2011 06:27 AM, Vic Dura wrote: new book http://www.pitonyak.org/OOME_**3_0.odthttp://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work +1 on that. Yes, this is wonderful to have. As far as I'm aware, it fills a real hole in the docs. I'll use it. t.

[libreoffice-users] Re: password problem

2011-08-06 Thread NoOp
On 08/04/2011 07:44 PM, Bob Stia wrote: Hello, I;ve just joined this list in hopes of solving my password problem on one dpcument. First of all I am running openSUSE 11.3, KDE3.5, and LibreOffice 3.3.1 This is going to be a problem for an expert in LibreOffice. I have a document that

Re: [libreoffice-users] Re: Need Calc help

2011-08-06 Thread Preston Smith
Hi Andreas, Thanks for your suggestion I know nothing about databases however I just successfully imported an xls file into LO's Base. I assume the next step is to import the second xls file to create a second table. Now for the difficult bit - how do I compare the record associated with a

[libreoffice-users] Re: looking for help on Base

2011-08-06 Thread NoOp
On 08/06/2011 04:31 AM, Andreas Säger wrote: It appears to still have issues. I'm getting this error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed I'll post back when I get it figured out. Since many years I have never read some write-up where somebody

Re: [libreoffice-users] Need Calc help

2011-08-06 Thread Betti Ann and Preston Smith
Thank you Jorge, My first quick glance suggests that these programmes may not work well with xls/ods files - I will look more closely at them Regards, Preston On 8/5/2011 10:33 PM, jorge wrote: Hi There are two programs that you can use for check the diferences between both files:

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread Tom Davies
Hi :) Moving to OpenSource for a type of product is a one-time major migration but it can be done in baby-steps. Staying with proprietary systems ensures that a similar level of disruption is guaranteed every 3-5 years as companies need to sell their new product. No baby-steps, just

[libreoffice-users] Lotus WordPro

2011-08-06 Thread Brian Grawburg
For several years Word Pro has been my primary word processing program for all major projects involving multiple chapters and sections within a chapter. For example, training manuals and personal books often consisting of +100 pages and more than a dozen divisions/chapters. I specifically

RE: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread Dennis E. Hamilton
Although discussion of migration strategies and switching costs is interesting, I want to come back to the odd title of this thread. To the best of my knowledge, what the US Federal CIO is concerned with does not directly govern whether or not Open Source is used in the White House. As I

Re: [libreoffice-users] Lotus WordPro

2011-08-06 Thread Brian Barker
At 14:01 06/08/2011 -0400, Brian Grawburg wrote: I specifically use Word Pro because I can create a division and then easily click on the chapter tab to go to a specific location. If LibreOffice included such an option it would become my only word processing program, ... Have you tried the

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread planas
Hi On Sat, 2011-08-06 at 18:44 +0100, Tom Davies wrote: Hi :) Moving to OpenSource for a type of product is a one-time major migration but it can be done in baby-steps. Staying with proprietary systems ensures that a similar level of disruption is guaranteed every 3-5 years as

Re: [libreoffice-users] Re: Need Calc help

2011-08-06 Thread planas
Preston On Sat, 2011-08-06 at 14:22 -0300, Preston Smith wrote: Hi Andreas, Thanks for your suggestion I know nothing about databases however I just successfully imported an xls file into LO's Base. I assume the next step is to import the second xls file to create a second table.

Re: [libreoffice-users] Re: Slow Calc Macros

2011-08-06 Thread planas
Hi, On Sat, 2011-08-06 at 13:31 +, Onyeibo Oku wrote: 1) True but what I'm doing is more computational than relational though the end result will be a material for building a proper database. A spreadsheet is more suited for this ... Trust me on this. 2) All the macro does is create

Re: [libreoffice-users] password problem

2011-08-06 Thread Bob Stia
On Friday 05 August 2011 00:37:47 Dennis E. Hamilton wrote: ..lots of snipping so we can focus.. Dennis. so, following your advice: One thing you can do with the file that fails is try to open it with a Zip utility and run a test on it. If the Zip tests all right, it means

Re: [libreoffice-users] Extending selection in Calc (LibreOffice 3.4.2, Linux)

2011-08-06 Thread Cor Nouws
Hi .., chimak111 wrote (06-08-11 14:11) See attached image. http://nabble.documentfoundation.org/file/n3230960/Screenshot.png Screenshot.png In LibreOffice 3.3.2, I could click on D2, extend the selection to E2 with shift and the right arrow, and then move down straight to cell E5 (the next

Re: [libreoffice-users] Lotus WordPro

2011-08-06 Thread Roland Hughes
We have been begging for tabbed divisions from the OpenOffice/LO/Symphony community for years. It has become quite obvious that the developers on these projects have only ever used Microsoft Word and can't fathom why anyone would want something other than a clone of that. IBM seriously dropped

Re: [libreoffice-users] Lotus WordPro

2011-08-06 Thread Roland Hughes
Navigator is a lot like Microsoft saying We're stable because we made it one whole hour without crashing. Tabbed document divisions were created by God and given to Lotus WordPro. It's not just the navigation, but the grouping and reordering and skipping and everything else. If you create a tab

RE: [libreoffice-users] password problem

2011-08-06 Thread Dennis E. Hamilton
Bob, No worries about running the test. It looks like the file extracted without any problem. Most Zip utilities have an option to test a package rather than extract it. The test report would indicate whether or not one of the files had some sort of discrepancy. You can try it, but it

[libreoffice-users] Re: password problem

2011-08-06 Thread NoOp
On 08/06/2011 02:40 PM, Bob Stia wrote: On Friday 05 August 2011 00:37:47 Dennis E. Hamilton wrote: ..lots of snipping so we can focus.. Dennis. so, following your advice: One thing you can do with the file that fails is try to open it with a Zip utility and run a test

RE: [libreoffice-users] Re: password problem

2011-08-06 Thread Dennis E. Hamilton
How is being able to access the encrypted Zip streams in a Hex editor going to help Bob? All of the extracted files (except the mimetype) are encryptions of the original compressed files. They are shown as extracted because the ciphertext is not itself compressed. The plaintext is. The

[libreoffice-users] Re: password problem

2011-08-06 Thread NoOp
On 08/06/2011 05:37 PM, Dennis E. Hamilton wrote: How is being able to access the encrypted Zip streams in a Hex editor going to help Bob? All of the extracted files (except the mimetype) are encryptions of the original compressed files. They are shown as extracted because the ciphertext

Re: [libreoffice-users] Base / Postgresql support

2011-08-06 Thread planas
Hi Walt On Thu, 2011-08-04 at 11:05 -0700, Walt wrote: Hi Anyone know how to get native pgsql support on base - it seems missing from the connect to an exsitng database options. I've checked under both Linux and Windows. Also is it possble to mix and match datasources on one base

[libreoffice-users] New user to BASE

2011-08-06 Thread Wayne
Hi, A couple of three days ago someone, on this list, mention not to use BASE, as there wasn't much development going on. Their suggestion was to look for a different front end to use. Can someone make a suggestion as to what would be a good alternative to use? No wars please. Just good advice.

Re: [libreoffice-users] Lotus WordPro

2011-08-06 Thread John B
Dear Brian Being a Lotus Word Pro user myself and with the help of Tom Davis, I did post Divisions / Tabs as a feature request some months ago This is the reply:- https://bugs.freedesktop.org/show_bug.cgi?id=38401 --- Comment #1 from Michael Meeksmichael.me...@novell.com 2011-06-20

Re: [libreoffice-users] New user to BASE

2011-08-06 Thread Simon Cropper (The foss Workflow Guides)
On 07/08/11 11:55, Wayne wrote: Hi, A couple of three days ago someone, on this list, mention not to use BASE, as there wasn't much development going on. Their suggestion was to look for a different front end to use. Can someone make a suggestion as to what would be a good alternative to use? No

Re: [libreoffice-users] There goes Open-Source in the White House

2011-08-06 Thread soumalya ray
not only US govt;even indian govt organisations forces users to use MS product.though obviously US is a much bigger cat. for example,during my post-graduate entrance exam form filling up,the site ( www.aiimsexams.org) told me that only IE is allowed,nothing else. so i used the useragent changer

Re: [libreoffice-users] New user to BASE

2011-08-06 Thread planas
Wayne On Sat, 2011-08-06 at 21:55 -0400, Wayne wrote: Hi, A couple of three days ago someone, on this list, mention not to use BASE, as there wasn't much development going on. Their suggestion was to look for a different front end to use. Can someone make a suggestion as to what would be a

Re: [libreoffice-users] New user to BASE

2011-08-06 Thread Wayne
On 08/06/2011 10:56 PM, Simon Cropper (The foss Workflow Guides) wrote: On 07/08/11 11:55, Wayne wrote: Hi, A couple of three days ago someone, on this list, mention not to use BASE, as there wasn't much development going on. Their suggestion was to look for a different front end to use. Can

Re: [libreoffice-users] New user to BASE

2011-08-06 Thread Wayne
On 08/06/2011 11:07 PM, planas wrote: Wayne On Sat, 2011-08-06 at 21:55 -0400, Wayne wrote: Hi, A couple of three days ago someone, on this list, mention not to use BASE, as there wasn't much development going on. Their suggestion was to look for a different front end to use. Can someone make

[libreoffice-users] HELP WITH CODE excel

2011-08-06 Thread Joseph Da Silva
Hi I was wondering if someone could help me with this code it works in excel but not with libra office. =INDIRECT(CELL(ADDRESS,INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The help would be greatly appreicated -- For

Re: [libreoffice-users] HELP WITH CODE excel

2011-08-06 Thread nvrk
On Sat, Aug 6, 2011 at 8:13 PM, Joseph Da Silva joseph_da_si...@hotmail.com wrote: Hi I was wondering if someone could help me with this code it works in excel but not with libra office. =INDIRECT(CELL(ADDRESS,INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The

Re: [libreoffice-users] Re: password problem

2011-08-06 Thread Bob Stia
On Saturday 06 August 2011 19:55:50 NoOp wrote: On 08/06/2011 02:40 PM, Bob Stia wrote: On Friday 05 August 2011 00:37:47 Dennis E. Hamilton wrote: ..lots of snipping so we can focus.. Dennis. so, following your advice: One thing you can do with the file that fails is

Re: [libreoffice-users] password problem

2011-08-06 Thread Bob Stia
On Saturday 06 August 2011 18:36:54 Dennis E. Hamilton wrote: Bob, No worries about running the test. It looks like the file extracted without any problem. Most Zip utilities have an option to test a package rather than extract it. The test report would indicate whether or not one of the

Re: [libreoffice-users] LibreOffice base - cannot make a convenient form to add data

2011-08-06 Thread Tom Cloyd
I think I can help... On 08/05/2011 01:24 AM, 3flight wrote: I'm trying to make a small base with a couple of forms to view and add data. For instance, I have a table Objects and it has two fields location and assigned to of type INTEGER, because they are linked to ID fields of tables locations

Re: [libreoffice-users] Printing

2011-08-06 Thread Alaric
On 06/08/11 21:58, Tom Davies wrote: Hi :) This guide would let you install both side-by-side http://wiki.documentfoundation.org/Installing_in_parallel I think it's good to have options Regards from Tom :) From: Alaricum@xtra.co.nz To: