[libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Andreas Säger
Say X99 displays 0.005. Turn on menu:ViewHighlight Values [Ctrl+F8]. What is the font color of X99? A blue color proves that X99 is a number. Text appears black. Get some unused cell and enter =X99=0.005 What is the result? Should be either TRUE or FALSE. If FALSE, what is the result of

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Tom Davies
Hi :) I think there is another way to build reports?  I think Andreas uses a different way inside Base.  Other people seem to start with the report builder and then hack it around.  It might be worth search the archives to find how Andreas does reports! Regards from Tom :)  --- On Thu,

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Tom Davies
Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not sure it's much help for you

Re: [libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tom Davies
Hi :) Could it be a problem with the user profile? https://wiki.documentfoundation.org/Documentation/UserProfile It's often good to start by renaming the User Profile just to see if whatever weirdness vanishes after doing that.  You might end-up copying the user profile back, or chunks of it

Re: [libreoffice-users] Re: LibreOffice is listed as an educational software for math

2012-05-25 Thread Tom Davies
Hi :) First time i went up to Manchester the university had just completed building a huge building that had been designed to fit the latest best machine of the day.  Unfortunately by the time the building work was done a better machine was small enough to fit on one of the desks in one of

Re: [libreoffice-users] Python and Tkinter

2012-05-25 Thread Tom Davies
Hi :) Who is TKinter? Regards from Tom ;) --- On Thu, 24/5/12, SuneOskar sune.nordst...@telia.com wrote: From: SuneOskar sune.nordst...@telia.com Subject: [libreoffice-users] Python and Tkinter To: users@global.libreoffice.org Date: Thursday, 24 May, 2012, 18:39 Is Tkinter supported ? --

[libreoffice-users] Re: [3.5.3/XP/Write] Items with arrows?

2012-05-25 Thread Gilles
Thanks everyone, it worked. Another application I use simply pastes the new object on top of the previous one, so I was used to this and expected LibreOffice to do the same. Copying the original object, unselecting it, then pasting the new object works. Considering how often we write use that

[libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Joep L. Blom
I have a simple question: I have a sheet with business cards (made with the correct template, etc.) but as I have a different printer I want to adjust the dimensions as to fit them perfectly. How is that done? I can not find a modify button anywhere and page formatting is not the correct way

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Andreas Säger
Am 25.05.2012 09:35, Tom Davies wrote: Hi :) I think there is another way to build reports? I think Andreas uses a different way inside Base. Other people seem to start with the report builder and then hack it around. It might be worth search the archives to find how Andreas does reports!

Re: [libreoffice-users] Re: LibreOffice is listed as an educational software for math

2012-05-25 Thread Jay Lozier
On 05/25/2012 04:16 AM, Tom Davies wrote: Hi :) First time i went up to Manchester the university had just completed building a huge building that had been designed to fit the latest best machine of the day. Unfortunately by the time the building work was done a better machine was

Re: [libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Jay Lozier
Joep On 05/25/2012 06:48 AM, Joep L. Blom wrote: I have a simple question: I have a sheet with business cards (made with the correct template, etc.) but as I have a different printer I want to adjust the dimensions as to fit them perfectly. How is that done? I can not find a modify button

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Rich Shepard
On Fri, 25 May 2012, Andreas Säger wrote: Turn on menu:ViewHighlight Values [Ctrl+F8]. What is the font color of X99? A blue color proves that X99 is a number. Text appears black. Other than column A (site names), every other cell is blue. I'm going to write an awk script that will

Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file

2012-05-25 Thread Jonathan Ryshpan
I have been attempting to send this posting for a while, and have only recently noticed that the list does not accept attachments. This has (apparently) caused it to be silently rejected. I have appended what had been attached to the end of this posting. Sorry for the delay. On Mon,

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Mirosław Zalewski
On 25/05/2012 at 15:14, Rich Shepard rshep...@appl-ecosys.com wrote: I'm going to write an awk script that will change the zeros to the appropriate reporting limit. That'll be quicker than my trying to understand what's happening in Calc. It may be. Can you post your document somewhere on

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Rich Shepard
On Fri, 25 May 2012, Mirosław Zalewski wrote: Can you post your document somewhere on the web? I think that there are users who are just curious what's so special about your data that neither of tips have worked for you. Mirosław, It's client data so I cannot distribute it. Rich -- For

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Alexander Thurgood
Le 25/05/12 10:10, Tom Davies a écrit : Hi Tom, or is it something weird about fonts and choosing the 'wrong' symbol somehow? Is the ^ on the top of the 6 key or is it selected as a special character? Regards from On a Macbook, the circumflex character appears on a key to the right of the

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Mirosław Zalewski
On 25/05/2012 at 16:31, Rich Shepard rshep...@appl-ecosys.com wrote: It's client data so I cannot distribute it. I was afraid that's the case. Sorry we could not solve your problem, then. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Rich Shepard
On Fri, 25 May 2012, Mirosław Zalewski wrote: Sorry we could not solve your problem, then. That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-) Thanks to all for the suggesions, Rich -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread MiguelAngel
El 25/05/12 16:52, Rich Shepard escribió: On Fri, 25 May 2012, Mirosław Zalewski wrote: Sorry we could not solve your problem, then. That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-) Thanks to all for the suggesions, Rich Maybe the mistake is in search for 0.000, it

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-25 Thread Alexander Thurgood
Le 25/05/12 16:16, Jonathan Ryshpan a écrit : Hi Jon, If oobase has connected properly to the database, it is useless for my purpose and I will give up on it and do what needs done with a bunch of shell scripts. If oobase has not opened the database properly, I will persevere. I took

[libreoffice-users] Using LibreOffice with whitelisting applications in Windows

2012-05-25 Thread Matthew Ames
Hi, In our company, we use whitelisting software which compares SHA hashes of files with a database full of them. Any .dll or .exe file which does not have a whitelisted hash is not allowed to run on our windows systems. We are trying to roll out LibreOffice to update our current OpenOffice

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Tom Davies
Hi :) Sometimes it's possible to replace all the confidential info in a file with random jumbles but in this case i think it would be 1.  difficult to do 2.  almost impossible to work out how to help I think you solved this a gnulinux way already anyway so it's all good now :) Regards from Tom

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tinkerer
I have a Mac. System 10.7.4 Libre O, 3.5.4.2 The ^ is Shift 6 and it works perfectly. Enter 3^2 does not work. The correct syntax is =3^2. Tink. -- View this message in context: http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986029.html Sent from the Users mailing list

Re: [libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tom Davies
Hi :) Doesn't =3^2 just give the equation rather than the answer?  Weird!  It sounds like Mac is good fun to get used to.  Regards from Tom :)  --- On Fri, 25/5/12, Tinkerer j_taylo...@btinternet.com wrote: From: Tinkerer j_taylo...@btinternet.com Subject: [libreoffice-users] Re: Is ^

[libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-25 Thread Custfold
The loss of my access to a PC with Visio and Visio 2000 on it has left me with .vsd files that I cannot work on, and its beginning to get a bit of a problem. a) is there an open source program that can open these files, and b) can I use it to work with the files for future drawings. DH --

[libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Andreas Säger
Am 25.05.2012 10:04, Tom Davies wrote: Sadly most of the people that know a lot about the ins-and-outs of Base are unwilling to help write the Base guide so it's down to 1 person who is desperately busy with a lot of other projects. How would you write a guide for hammer, chisel, plow, saw

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-25 Thread Tom Davies
Hi :) Have you tried Draw in LibreOffice 3.5.3?  I know it can handle some Visio Files Regards from Tom :) --- On Fri, 25/5/12, Custfold custf...@aol.com wrote: From: Custfold custf...@aol.com Subject: [libreoffice-users] is there an Open office equivalent to Visio 2000 To:

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tinkerer
Doesn't =3^2 just give the equation rather than the answer? Weird! It sounds like Mac is good fun to get used to. Regards from Tom :) No Tom =3^2 gives the result, 9. -- View this message in context: http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986041.html Sent from

[libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Andreas Säger
Am 25.05.2012 16:31, Rich Shepard wrote: On Fri, 25 May 2012, Mirosław Zalewski wrote: Can you post your document somewhere on the web? I think that there are users who are just curious what's so special about your data that neither of tips have worked for you. Mirosław, It's client data so

[libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-25 Thread Andreas Säger
Am 25.05.2012 15:14, Rich Shepard wrote: On Fri, 25 May 2012, Andreas Säger wrote: Turn on menu:ViewHighlight Values [Ctrl+F8]. What is the font color of X99? A blue color proves that X99 is a number. Text appears black. Other than column A (site names), every other cell is blue. I'm going

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-25 Thread Jay Lozier
On 05/25/2012 12:06 PM, Custfold wrote: The loss of my access to a PC with Visio and Visio 2000 on it has left me with .vsd files that I cannot work on, and its beginning to get a bit of a problem. a) is there an open source program that can open these files, and b) can I use it to work

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread Larry Gusaas
On 2012-05-25 2:17 AM Tom Davies wrote: Who is TKinter? http://www.google.com/search?q=TKinterie=utf-8oe=utf-8 -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far

Re: [libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Mirosław Zalewski
On 25/05/2012 at 18:03, Tinkerer j_taylo...@btinternet.com wrote: Enter 3^2 does not work. The correct syntax is =3^2. You seem to be talking about LO Calc formula, while this thread is about ooBasic (macro language). Or I have missed something important here. -- Best regards Mirosław

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread SuneOskar
Visit wiki.python.org/moin/TkInter -- View this message in context: http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866p3986063.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread Andreas Säger
Am 24.05.2012 19:39, SuneOskar wrote: Is Tkinter supported ? -- View this message in context: http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html Sent from the Users mailing list archive at Nabble.com. help modules Tkinter Here is a list of matching modules. Enter any

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread Andreas Säger
Am 25.05.2012 21:00, Andreas Säger wrote: Am 24.05.2012 19:39, SuneOskar wrote: Is Tkinter supported ? -- View this message in context: http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html Sent from the Users mailing list archive at Nabble.com. help modules Tkinter Here

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tinkerer
Yes, but what is the difference? Macro basic or Calc formula. Either way, you still need to use the correct syntax. Tink. -- View this message in context: http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986075.html Sent from the Users mailing list archive at Nabble.com. --

[libreoffice-users] Documents do strange things

2012-05-25 Thread Wanda Moore
I write simple documents all the time, but my preferences don't seem to matter to LO. I choose a font, but it changes on me. I cut or copy and paste, and the font changes, even though I copy the exact same thing. Times New Roman seems to be the dictator here. And the size always changes. Lines

Re: [libreoffice-users] Documents do strange things

2012-05-25 Thread Jay Lozier
Wanda On 05/25/2012 04:36 PM, Wanda Moore wrote: I write simple documents all the time, but my preferences don't seem to matter to LO. I choose a font, but it changes on me. I cut or copy and paste, and the font changes, even though I copy the exact same thing. Times New Roman seems to be

Re: [libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Joep L. Blom
On 25-05-12 15:12, Jay Lozier wrote: Joep On 05/25/2012 06:48 AM, Joep L. Blom wrote: AFAIK your business cards form should print correctly on any printer that has a large enough printing area. I have found the typical tweaks I need are to adjust the margins of the text slightly so it does not

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-25 Thread webmaster-Kracked_P_P
On 05/25/2012 01:58 PM, Jay Lozier wrote: On 05/25/2012 12:06 PM, Custfold wrote: The loss of my access to a PC with Visio and Visio 2000 on it has left me with .vsd files that I cannot work on, and its beginning to get a bit of a problem. a) is there an open source program that can open these

Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file

2012-05-25 Thread Joep L. Blom
On 25-05-12 16:16, Jonathan Ryshpan wrote: I have been attempting to send this posting for a while, and have only recently noticed that the list does not accept attachments. This has (apparently) caused it to be silently rejected. I have appended what had been attached to the end of this

Re: [libreoffice-users] Documents do strange things

2012-05-25 Thread Wanda Moore
I use the right click menu or edit in the toolbar. I've never used styles or templates, as I don't really understand them, and just want to be able to take notes and write things down for myself and my kids. (I homeschool, so I'm always writing something and printing them out.) I have LO 3.4.4

Re: [libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread webmaster-Kracked_P_P
On 05/25/2012 03:15 PM, Andreas Säger wrote: Am 25.05.2012 21:00, Andreas Säger wrote: Am 24.05.2012 19:39, SuneOskar wrote: Is Tkinter supported ? -- View this message in context: http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html Sent from the Users mailing list archive

Re: [libreoffice-users] Documents do strange things

2012-05-25 Thread Jay Lozier
On 05/25/2012 05:55 PM, Wanda Moore wrote: I use the right click menu or edit in the toolbar. I've never used styles or templates, as I don't really understand them, and just want to be able to take notes and write things down for myself and my kids. (I homeschool, so I'm always writing

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr
Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not sure it's much help for you

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Dan Lewis
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote: Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not

[libreoffice-users] Re: is there an Open office equivalent to Visio 2000

2012-05-25 Thread Marc Paré
Le 2012-05-25 12:06, Custfold a écrit : The loss of my access to a PC with Visio and Visio 2000 on it has left me with .vsd files that I cannot work on, and its beginning to get a bit of a problem. a) is there an open source program that can open these files, and b) can I use it to work with

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote: Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not

[libreoffice-users] right-clicking Font list options not showing all my installed fonts

2012-05-25 Thread webmaster-Kracked_P_P
Font formatting issue You highlight your text, then right-click The you choose the Font option. For me, when I go down the list, I do not go out of the A's for the font names. How many fonts is that list designed to deal with? With all of the variations [bold, italic, bold italic, etc.]

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr
Dan Lewis wrote: Yes, you can link to a Base query with Calc. With Cal open, use the F4 key to open the Data Source window. (You will have to register the database before it will appear in this window.) The left side is the name of the registered databases. Click the arrow in front of

Re: [libreoffice-users] right-clicking Font list options not showing all my installed fonts

2012-05-25 Thread Steve Edmonds
On 2012-05-26 12:55, webmaster-Kracked_P_P wrote: Font formatting issue You highlight your text, then right-click The you choose the Font option. For me, when I go down the list, I do not go out of the A's for the font names. How many fonts is that list designed to deal with? With

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr
drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem - not saying it is impossible but sounds really odd. 1500 records in a tabular report, 49

Re: [libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Don Myers
Hi Joep, The standard label formats included with LibreOffice and OpenOffice are the same type as Microsoft uses with fixed blocks. These tend to not to be accurate if the card/label is relatively full as you get toward the bottom of the page, even in Microsoft. There are also table style

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen
On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote: drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem - not saying it is

Re: [libreoffice-users] right-clicking Font list options not showing all my installed fonts

2012-05-25 Thread Jay Lozier
On 05/25/2012 08:55 PM, webmaster-Kracked_P_P wrote: Font formatting issue You highlight your text, then right-click The you choose the Font option. For me, when I go down the list, I do not go out of the A's for the font names. How many fonts is that list designed to deal with?