Re: [libreoffice-users] Frutiger Font Problem

2013-11-14 Thread Uli Geisler
On 13.11.2013 18:20, Kracked_P_P---webmaster wrote: On 11/12/2013 09:15 AM, Uli Geisler wrote: Hi I'm using the Frutiger Font (ttf, linotype) for several Years now for my work an have al lot of Documents and Templates. Since upgrading to ubuntu 13.10 (libreoffice upgraded to 4.1.2) the

Re: [libreoffice-users] random # in calc

2013-11-14 Thread Brian Barker
At 10:17 11/11/2013 -0500, Helen Etters wrote: A LO calc question. It's a bit trivial, but I'm sure it can be done. Names of about 20 people. Draw names for Christmas gifts. Have you wondered why you have got little in the way of replies? Er, perhaps Draw names for Christmas gifts is not

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-14 Thread e-letter
On 13/11/2013, Steve Gruspier s...@alfred.edu wrote: Hello: I was wondering if this was the place to request a feature. I was Perhaps as discussion, then submit via bugzilla. thinking the Special Character section is very cluttered. My feature request is a setting that would narrow

[libreoffice-users] Referencing automatically cell data from a dynamic list of files

2013-11-14 Thread Javier Garcia
Hi, I have a a list of invoices created with LibreOffice Calc inside a folder. Now I would like to retrieve the data inside of those invoices to create another spreadsheet called All that contains a row for each invoice. | Name Phone Street John 677 Main Mary 897 Niceday | Is there any

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Paul
On Thu, 14 Nov 2013 07:07:53 +0200 Ady ady...@hotmail.com wrote: Well, the procedure I mentioned involves copying one cell only, which means it is a faster method, as oppose to having to copy perhaps a lot of cells (e.g. a whole column; or having to add many new VALUE formulas; or having

[libreoffice-users] Instability problem in CALC

2013-11-14 Thread david_lynch
I have a fairly large and very complex spreadsheet: Number of sheets 12 Number of cells 123562 Number of pages 55 size 1.23 Mb much calculation (typically about 200 cells aren't formulas) and many array formulas. [4.0.5.2 on Windows] Usually, but not always, when I add a formula to this

Re: [libreoffice-website] Re: [libreoffice-users] Re: Engaging users: initial results of the survey

2013-11-14 Thread Philipp Weissenbacher
How do I just log into the bug reporting system and search it? Anyone? This is a list of all LibreOffice bugs https://bugs.freedesktop.org/buglist.cgi?query_format= specificorder=relevance+descbug_status=__open__product= LibreOfficecontent=. thanks, but I didn't ask for that... You

Re: [libreoffice-website] Re: [libreoffice-users] Re: Engaging users: initial results of the survey

2013-11-14 Thread Tanstaafl
On 2013-11-14 5:56 AM, Philipp Weissenbacher p.weissenbac...@gmail.com wrote: Freedesktop.org Bugzilla log-in page https://bugs.freedesktop.org/ (click Log in top right hand corner) - click Search - Select LibreOffice in the Product drop down and search you heart out. OR Use the Search field

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-14 Thread Paul
On Thu, 14 Nov 2013 10:12:46 + e-letter inp...@gmail.com wrote: On 13/11/2013, Steve Gruspier s...@alfred.edu wrote: thinking the Special Character section is very cluttered. My feature request is a setting that would narrow down special characters to ones that are used in specific

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Ady
Although the Tools - Text to Columns... method in Calc is nice, the procedure I am describing is more flexible. I'm not sure why you say it is more flexible. Text to columns would be the correct way of doing this, and I can't right now think of a case where you would need your way. Can you

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-14 Thread Kracked_P_P---webmaster
On 11/13/2013 04:28 PM, Steve Gruspier wrote: Hello: I was wondering if this was the place to request a feature. I was thinking the Special Character section is very cluttered. My feature request is a setting that would narrow down special characters to ones that are used in specific fields

Re: [libreoffice-users] Medical -- engineering dictionaries?

2013-11-14 Thread Kracked_P_P---webmaster
On 11/13/2013 11:45 PM, Joel Madero wrote: On 11/13/2013 04:51 PM, Thomas Taylor wrote: Could someone point me toward extension dictionaries related to medical or engineering terminology? I seem to remember there being several on the extensions page but can't find much now. Thanks, Tom

Re: [libreoffice-users] Frutiger Font Problem

2013-11-14 Thread Kracked_P_P---webmaster
On 11/14/2013 03:24 AM, Uli Geisler wrote: On 13.11.2013 18:20, Kracked_P_P---webmaster wrote: On 11/12/2013 09:15 AM, Uli Geisler wrote: Hi I'm using the Frutiger Font (ttf, linotype) for several Years now for my work an have al lot of Documents and Templates. Since upgrading to ubuntu

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread Jay Lozier
On Wed, 2013-11-13 at 22:16 -0800, Sunil Agrawal wrote: Hi, I am using Calc (actually soffice) in a headless manner (using —headless). I am running it on a server that doesn’t have X server and communicating with soffice using JOD converter. Generally it hasn’t been a problem, however when

Re: [libreoffice-users] Instability problem in CALC

2013-11-14 Thread Jay Lozier
On Thu, 2013-11-14 at 12:17 +, david_lynch wrote: I have a fairly large and very complex spreadsheet: Number of sheets 12 Number of cells 123562 Number of pages 55 size 1.23 Mb much calculation (typically about 200 cells aren't formulas) and many array formulas. [4.0.5.2

Re: [libreoffice-users] random # in calc

2013-11-14 Thread Helen
How very clever! Yes, this worked! I did get three each other responses and I will study the code and try to figure out how it works. Thank you so much! On Thu, Nov 14, 2013 at 4:05 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 10:17 11/11/2013 -0500, Helen Etters wrote: A LO calc

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-14 Thread Regina Henschel
Hi Steve, Steve Gruspier schrieb: Hello: I was wondering if this was the place to request a feature. I was thinking the Special Character section is very cluttered. My feature request is a setting that would narrow down special characters to ones that are used in specific fields such as

Re: [libreoffice-users] Referencing automatically cell data from a dynamic list of files

2013-11-14 Thread Tom Davies
Hi :) Have you tried using a specialist tool such as; GnuCash, runs on Windows too http://www.gnucash.org/ This one is reasonably famous. Competes with mainstream programs such as Sage, Quickbooks etc. Grisbi http://www.grisbi.org/ (website down for maintenance right now and i've no idea how

Re: [libreoffice-users] random # in calc

2013-11-14 Thread Tom Davies
Hi :) Computers don't usually do random very well. Prolly better to wait until everyone is together (or at least enough of you that no-one is going to feel the results were fixed) and then draw names from a hat. Print the names on slips of paper and then make a big show of pulling out a name at

Re: [libreoffice-users] Frutiger Font Problem

2013-11-14 Thread Uli Geisler
On 14.11.2013 16:12, Kracked_P_P---webmaster wrote: On 11/14/2013 03:24 AM, Uli Geisler wrote: On 13.11.2013 18:20, Kracked_P_P---webmaster wrote: On 11/12/2013 09:15 AM, Uli Geisler wrote: Hi I'm using the Frutiger Font (ttf, linotype) for several Years now for my work an have al lot of

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread Sunil Agrawal
Hi Jay, Thanks for the response. I am using Linux and tried LO 3.5 and 4.0 but same behavior. I want to share the doc and the recipient might not have LO hence the need to convert to PDF. Any insights will be appreciated. Sunil On Thu, Nov 14, 2013 at 7:31 AM, Jay Lozier jsloz...@gmail.com

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-14 Thread Doug
On 11/14/2013 10:55 AM, Regina Henschel wrote: Hi Steve, Steve Gruspier schrieb: Hello: I was wondering if this was the place to request a feature. I was thinking the Special Character section is very cluttered. My feature request is a setting that would narrow down special characters to ones

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread Jay Lozier
On Thu, 2013-11-14 at 08:49 -0800, Sunil Agrawal wrote: Hi Jay, Thanks for the response. I am using Linux and tried LO 3.5 and 4.0 but same behavior. I want to share the doc and the recipient might not have LO hence the need to convert to PDF. Any insights will be appreciated. Sunil

Re: [libreoffice-users] Medical -- engineering dictionaries?

2013-11-14 Thread Thomas Taylor
On Wed, 13 Nov 2013 16:51:25 -0800 Thomas Taylor li...@comcast.net wrote: Could someone point me toward extension dictionaries related to medical or engineering terminology? I seem to remember there being several on the extensions page but can't find much now. Thanks, Tom Thank all of

Re: [libreoffice-users] random # in calc

2013-11-14 Thread Helen
Actually Brian's idea worked very well. But as I said in my Q, it's a rather trivial need. Usually, at Thanksgiving, we toss handwritten names on paper scraps into a real hat, and everyone draws a name. Some people have said they don't like to wait that late to do their shopping, so the virtual

Re: [libreoffice-users] random # in calc

2013-11-14 Thread Brian Barker
At 15:49 14/11/2013 +, Tom Davies wrote: Computers don't usually do random very well. Computers actually do (pseudo-)random extremely well. Prolly better to wait until everyone is together (or at least enough of you that no-one is going to feel the results were fixed) and then draw

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread Paul D. Mirowsky
Even though you are running headless, it may require CUPS-PDF to be setup on the server. You may also have to set defaults for CUPS. See this article to get an idea of what may be needed. http://thismightbehelpful.blogspot.com/2008/09/remote-access-to-cups-web-interface.html Hope this helps,

[libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Tinkerer
These solutions are far too complex especially if you have very large sheets. Why not use the extension CT2N? It is simple, very straightforward and you can decide ,whole sheet, or just parts. The ' is just removed. I understand it is to be included as standard, in which case there will be no need

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread e-letter
On 14/11/2013, Sunil Agrawal su...@armor5.com wrote: Hi Jay, Thanks for the response. I am using Linux and tried LO 3.5 and 4.0 but same behavior. I want to share the doc and the recipient might not have LO hence the need to convert to PDF. On Thu, Nov 14, 2013 at 7:31 AM, Jay Lozier

Re: [libreoffice-users] Medical -- engineering dictionaries?

2013-11-14 Thread Kracked_P_P---webmaster
On 11/14/2013 12:20 PM, Thomas Taylor wrote: On Wed, 13 Nov 2013 16:51:25 -0800 Thomas Taylor li...@comcast.net wrote: Could someone point me toward extension dictionaries related to medical or engineering terminology? I seem to remember there being several on the extensions page but can't

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread Kracked_P_P---webmaster
On 11/14/2013 10:31 AM, Jay Lozier wrote: On Wed, 2013-11-13 at 22:16 -0800, Sunil Agrawal wrote: Hi, I am using Calc (actually soffice) in a headless manner (using —headless). I am running it on a server that doesn’t have X server and communicating with soffice using JOD converter.

Re: [libreoffice-users] Export as PDF using Calc

2013-11-14 Thread Paul
The OP may want his spreadsheets available on machines that don't have *any* spreadsheet software, hence the need for pdf. I think we should try and solve that issue, not suggest alternative formats. On Thu, 14 Nov 2013 20:34:01 + e-letter inp...@gmail.com wrote: On 14/11/2013, Sunil

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Paul
Hi Ady, On Thu, 14 Nov 2013 15:45:33 +0200 Ady ady...@hotmail.com wrote: On one hand, this method is effective, efficient and well-known in several other spreadsheet programs, and for users that already know it, it seems at least strange that LO Calc doesn't support it. I'm still not sure

[libreoffice-users] Calc paste funnies

2013-11-14 Thread Paul
Hi All, In experimenting with an issue on another thread (convert text to number by multiplying by 1), I created a new spreadsheet to test the issue. I had a spreadsheet open, and clicked the icon at the top to create a new spreadsheet for testing. I had already done this a couple of times,

Re: [libreoffice-users] Calc paste funnies

2013-11-14 Thread Stefan Weigel
Hi Paul, Am 14.11.2013 22:12, schrieb Paul: When I select copy, everything works as expected, the cell gets a dashed border. If I ctrl-v, it pastes. But if I right-click, there is no Paste or Paste Special, only Paste Only, with nothing in that submenu. On the main menu at the top, under

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Brian Barker
At 12:30 14/11/2013 -0800, J Taylor wrote: Why not use the extension CT2N? The ' is just removed. It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. The apostrophe indicates (in the Input Line) that what may appear to

[libreoffice-users] Templates with pop up variables in Writer

2013-11-14 Thread John Meyer
I'd like to create a template that would pop up a couple of fill in fields (name, date) and automatically populate them in the new document. Is that possible? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Templates with pop up variables in Writer

2013-11-14 Thread Paul
As far as I understand it, yes, but you need to do some macro coding. That might be a bit daunting if you've never done any before. Let us know some more details (both of what you need and what you know) and I'm sure someone can give you a few tips. Paul On Thu, 14 Nov 2013 15:02:36 -0700 John

Re: [libreoffice-users] Templates with pop up variables in Writer

2013-11-14 Thread John Meyer
On 11/14/2013 3:29 PM, Paul wrote: As far as I understand it, yes, but you need to do some macro coding. That might be a bit daunting if you've never done any before. Let us know some more details (both of what you need and what you know) and I'm sure someone can give you a few tips. Paul On

[libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread mariosv
I have forgot in my previous post, another option: First copying the text to convert [Ctrl+c]. From the right-arrow in the icon. selecting unformatted text, we get the same option as importing csv files. http://nabble.documentfoundation.org/file/n4083240/Captura.png Miguel Ángel. -- View

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Ady
These solutions are far too complex especially if you have very large sheets. Why not use the extension CT2N? It is simple, very straightforward and you can decide ,whole sheet, or just parts. The ' is just removed. I understand it is to be included as standard, in which case there will be

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Ady
Hi Ady, On Thu, 14 Nov 2013 15:45:33 +0200 Ady ady...@hotmail.com wrote: On one hand, this method is effective, efficient and well-known in several other spreadsheet programs, and for users that already know it, it seems at least strange that LO Calc doesn't support it. I'm still

Re: [libreoffice-users] paste special problem

2013-11-14 Thread Tom Davies
Hi :) Congrats on solving this yourself! :) Many apols that you didn't get any better answers from the rest of us! Congrats and regards from Tom :) On 13 November 2013 22:24, yahoo-pier_andreit pier_andr...@yahoo.it wrote: On 11/11/2013 08:58 PM, yahoo-pier_andreit wrote: On 11/11/2013 04:27

Re: [libreoffice-users] cooldown mode

2013-11-14 Thread Tom Davies
Hi :) When you first start triaging you might find that there is only 1 or 2 admin/secretarial type tasks that you can do. So you might be able race through tons of bug-reports doing just that 1 thing. As you gain confidence or experience (hopefully both) then you might find you have to slow

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Stefan Weigel
Hi, Am 14.11.2013 22:39, schrieb Brian Barker: It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. Yes there is! It's because these cell contents are very different that the apostrophe is necessary as a warning. It´s