Re: [libreoffice-users] Re: 64 bit

2013-11-11 Thread Marcello Romani
Il 08/11/2013 21:35, Gabriel Risterucci ha scritto: 2013/11/8 Pedro pedl...@gmail.com jmadero wrote No offense at all, I encourage open conversation but I tend to see a one side conversation THERE SHOULD BE A 64 BIT FLYING LIBREOFFICE THAT CAN BAKE ME A CAKE AND CALCULATE A QUADRILLION

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

2013-11-11 Thread William Drago
I just tried this extension. It's easy to use and seems to work very well. Is there a way to move its icon to a different place on the tool bar? Thanks, -Bill On 11/10/2013 5:08 PM, Joel Madero wrote: http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates

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

2013-11-11 Thread Charles-H. Schulz
Hello Ady, Le Mon, 11 Nov 2013 06:11:10 +0200, Ady ady...@hotmail.com a écrit : Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis:

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

2013-11-11 Thread Charles-H. Schulz
Hello Alex, Le Mon, 11 Nov 2013 09:05:46 +0100, Alex Thurgood alex.thurg...@gmail.com a écrit : Le 10/11/2013 19:46, Charles-H. Schulz a écrit : Hi Charles, Whilst I appreciate the effort in designing such a survey and the objective behind it, I too, must admit that the survey was not

[libreoffice-users] Re: 64 bit

2013-11-11 Thread Pedro
Marcello Romani wrote And all that just to have a 64bit binary that would only give more work and no immediate benefit... After this reply I hope anyone whining about Windows users being let down because there's no 64 bit version of OpenOffice/LibreOffice shut the hell up and start

Re: [libreoffice-users] Re: 64 bit

2013-11-11 Thread Tanstaafl
On 2013-11-11 7:40 AM, Pedro pedl...@gmail.com wrote: Marcello Romani wrote And all that just to have a 64bit binary that would only give more work and no immediate benefit... After this reply I hope anyone whining about Windows users being let down because there's no 64 bit version of

Re: [libreoffice-users] Re: 64 bit

2013-11-11 Thread Gabriel Risterucci
2013/11/11 Pedro pedl...@gmail.com Marcello Romani wrote And all that just to have a 64bit binary that would only give more work and no immediate benefit... After this reply I hope anyone whining about Windows users being let down because there's no 64 bit version of

[libreoffice-users] Postgres and Calc

2013-11-11 Thread Duncan Adams
Hi All Hope you are all well. I have a postgres database with a table called item_table that has the following columns: location_id, item_id, owner_id, quantity I am attempting to connect a query such as select quantity from item_table where location_id = 1 and item_id = 1 and owner_id = 1

Re: [libreoffice-users] Re: Improvement i Last used documents

2013-11-11 Thread Paul D. Mirowsky
Might I suggest Last used document from... listing Writer, Calc, Base etc... Why restrict it to the program you using only? On 11/9/2013 4:27 PM, Kolbjørn Stuestøl wrote: Den 09.11.2013 21:27, skreiv Urmas: Leif Burstroem: It would be nice if the listing of last used document was split up

[libreoffice-users] random # in calc

2013-11-11 Thread Helen
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. We can wait until we're all together in a couple of weeks, and that will work, but can we do this by running a random number generator in calc? Type 20 names into

Re: [libreoffice-users] Bibliography issues

2013-11-11 Thread Gabriel Risterucci
2013/11/11 Nic Marchesini marchesin...@gmail.com In my document, I've created the bibliography and the table of contents (it displays all the chapters, subchapters I've wrote), but I can't understand why the ToC doesn't display, as last row, the entry 'References' and its page number. I've

Re: [libreoffice-users] Bibliography issues

2013-11-11 Thread Nic Marchesini
Thanks a lot to all of you for your hints! Cheers, Nic --- Nic Marchesini +39.320.4370806 +44.785.6857250 marchesin...@gmail.com skype: nmarchesiniparma Nic is on G+ On 11 November 2013 15:22, Gabriel Risterucci cleyf...@gmail.com wrote: 2013/11/11 Nic Marchesini marchesin...@gmail.com In

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

2013-11-11 Thread Oogie McGuire
I ended up using this option for this time, create a column using the VALUE function, then copy and paste special numbers only. For future I will look at other options. This is something that will be done a lot for the next year or so. I am in the process of converting my sheep records from a

[libreoffice-users] Re: Shall we waste twelve more years promoting Free office suites instead of...

2013-11-11 Thread Ken Springer
On 11/9/13 12:25 PM, Paul wrote: Interesting article, and indeed it is true that the file format is the most important aspect of the office suite debate, but I think you are a little naive in your assumption that LO should stop doing any other type of marketing. From a programmer's

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

2013-11-11 Thread Oogie McGuire
For me dealing with an extension, installing it, making sure it doesn't conflict with something else was more effort than creating a column, using Value() and then pasting special. What's a problem is that in Excel even though it also uses the leading ' to format text as numbers, if you

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

2013-11-11 Thread Denis Navas Vega
El 2013-11-10 07:40 p.m., Paul escribió: On Mon, 11 Nov 2013 02:56:51 +0200 Ady ady...@hotmail.com wrote: As a simple user, I see this hidden addition of the initial single quotation mark as a _BUG_, and as one of those basic features that work poorly in LibreOffice Calc than in several other

[libreoffice-users] Re: Shall we waste twelve more years promoting Free office suites instead of...

2013-11-11 Thread Ken Springer
On 11/9/13 5:37 PM, M. Fioretti wrote: On Sat, Nov 09, 2013 14:06:44 PM -0800, Pedro wrote: Two points: 1) LibreOffice only started embedding fonts in ODF files in version 4.1 (released in July 2013); MS Office files have had this ability for YEARS. In my opinion ODF files are NOW starting to

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

2013-11-11 Thread Stefan Weigel
Hi, Am 11.11.2013 18:17, schrieb Oogie McGuire: What's a problem is that in Excel even though it also uses the leading ' to format text as numbers, if you change the format of a cell the conversions happen without any problems. That´s not true. I just tried in Excel. The leading ' stays,

Re: [libreoffice-users] paste special problem

2013-11-11 Thread Tom Davies
Hi :) tbh i was hoping that closing LO and maybe rebooting the computer would fix it. It might also be that you need to run updates/upgrades on your system. If that doesn't fix it then maybe reinstall a more recent version of LibreOffice and hope that pulls in something to fix it! Not very

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

2013-11-11 Thread Michael Meeks
Hi Urmas, So - I don't really understand your mail, which is a shame. On Mon, 2013-11-11 at 07:23 +0700, Urmas wrote: The only way users can contribute is when they are paying. Surely you're a user - and you contribute with bug filing, triage, and other QA things which are much

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

2013-11-11 Thread Steve Gruspier
Could this possibly be a 'feature' associated with a certain version of office\excel? Steve Gruspier Electrical Engineering On 11/11/2013 12:34 PM, Stefan Weigel wrote: Hi, Am 11.11.2013 18:17, schrieb Oogie McGuire: What's a problem is that in Excel even though it also uses the leading '

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

2013-11-11 Thread Joel Madero
On 11/11/2013 09:30 AM, Denis Navas Vega wrote: El 2013-11-10 07:40 p.m., Paul escribió: On Mon, 11 Nov 2013 02:56:51 +0200 Ady ady...@hotmail.com wrote: As a simple user, I see this hidden addition of the initial single quotation mark as a _BUG_, and as one of those basic features that work

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

2013-11-11 Thread Ken Springer
On 11/11/13 2:30 AM, Michael Seeks wrote: Hi Urmas, So - I don't really understand your mail, which is a shame. On Mon, 2013-11-11 at 07:23 +0700, Urmas wrote: The only way users can contribute is when they are paying. Surely you're a user - and you contribute with bug

Re: [libreoffice-users] random # in calc

2013-11-11 Thread Steve Edmonds
On 2013-11-12 04:17, Helen 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. We can wait until we're all together in a couple of weeks, and that will work, but can we do this by running a random number

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

2013-11-11 Thread Paul
On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega denis.na...@gmail.com wrote: The problem is with the symbol ' It can't be searched and replaced. That's why Ady consider it a bug. That's because it isn't actually there. It's just an indicator of the fact that the number is not a number, but

Re: [libreoffice-users] paste special problem

2013-11-11 Thread yahoo-pier_andreit
On 11/11/2013 04:27 PM, Tom Davies wrote: Hi :) tbh i was hoping that closing LO and maybe rebooting the computer would fix it. ...already done doesn't works... It might also be that you need to run updates/upgrades on your system. ...already done doesn't works..., I also installed the

Re: [libreoffice-users] Re: Shall we waste twelve more years promoting Free office suites instead of...

2013-11-11 Thread Paul
On Mon, 11 Nov 2013 10:13:49 -0700 Ken Springer snowsh...@q.com wrote: On 11/9/13 12:25 PM, Paul wrote: Interesting article, and indeed it is true that the file format is the most important aspect of the office suite debate, but I think you are a little naive in your assumption that LO

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

2013-11-11 Thread Ken Springer
Overall, a +2, Ady. Comments interspersed below. On 11/10/13 9:11 PM, Ady wrote: Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis:

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

2013-11-11 Thread Oogie McGuire
Not in my version I just verified it. Had to go install Excel again to see but it works as I expect Macintosh Snow Leopard running MS Excel X for mac. On Nov 11, 2013, at 10:34 AM, Stefan Weigel wrote: That´s not true. I just tried in Excel. The leading ' stays, no matter what format you

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

2013-11-11 Thread Paul
On Mon, 11 Nov 2013 11:33:43 -0700 Ken Springer snowsh...@q.com wrote: What I didn't like was being told my issues were not important. BS! It's important to me. If it's important to you, you can fund a developer to work on it for you, or work on it yourself. If not, then unfortunately the

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

2013-11-11 Thread Paul
On Mon, 11 Nov 2013 10:12:55 -0700 Oogie McGuire oog...@desertweyr.com wrote: What I would consider a bug is that changing the format of a cell doesn't change the data. And it shouldn't, it changes only the *format* of the data, not the data itself. I often get confused by this, expecting that

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

2013-11-11 Thread Ken Springer
Hi, Charles, On 11/11/13 4:19 AM, Charles-H. Schulz wrote: Hello Alex, Le Mon, 11 Nov 2013 09:05:46 +0100, Alex Thurgood alex.thurg...@gmail.com a écrit : Le 10/11/2013 19:46, Charles-H. Schulz a écrit : Hi Charles, Whilst I appreciate the effort in designing such a survey and the

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

2013-11-11 Thread Charles-H. Schulz
Hello Ken, Ken Springer snowsh...@q.com a écrit : Hi, Charles, On 11/11/13 4:19 AM, Charles-H. Schulz wrote: Hello Alex, Le Mon, 11 Nov 2013 09:05:46 +0100, Alex Thurgood alex.thurg...@gmail.com a écrit : Le 10/11/2013 19:46, Charles-H. Schulz a écrit : Hi Charles, Whilst I appreciate

[libreoffice-users] OT - changing email address for mailing lists

2013-11-11 Thread Gordon Burgess-Parker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi - I read (mainly) and sometimes post to, several of the TDF mailing lists. I'm wanting to change my subscribed and authorised email address. Can I do that all in one place, or do I have to unsubscribe and re-subscribe for each list? Thanks

Re: [libreoffice-users] OT - changing email address for mailing lists

2013-11-11 Thread Charles-H. Schulz
Hello Gordon, You would have to do that for each mailing list you're subscribed to. Best, Charles. Le 2013-11-11 22:22, Gordon Burgess-Parker a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi - I read (mainly) and sometimes post to, several of the TDF mailing lists. I'm wanting to

Re: [libreoffice-users] OT - changing email address for mailing lists

2013-11-11 Thread Gordon Burgess-Parker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/11/2013 21:27, Charles-H. Schulz wrote: Hello Gordon, You would have to do that for each mailing list you're subscribed to. Best, Charles. OK thanks. Gordon -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (MingW32) Comment: Using

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

2013-11-11 Thread Charles-H. Schulz
Paul, everyone, Le 2013-11-11 21:18, Paul a écrit : On Mon, 11 Nov 2013 11:33:43 -0700 Ken Springer snowsh...@q.com wrote: What I didn't like was being told my issues were not important. BS! It's important to me. If it's important to you, you can fund a developer to work on it for you, or

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

2013-11-11 Thread Ken Springer
On 11/11/13 1:18 PM, Paul wrote: On Mon, 11 Nov 2013 11:33:43 -0700 Ken Springer snowsh...@q.com wrote: What I didn't like was being told my issues were not important. BS! It's important to me. If it's important to you, you can fund a developer to work on it for you, or work on it yourself.

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

2013-11-11 Thread Ken Springer
Hi, Charles, On 11/11/13 2:09 PM, Charles-H. Schulz wrote: Hello Ken, Ken Springer snowsh...@q.com a écrit : Hi, Charles, On 11/11/13 4:19 AM, Charles-H. Schulz wrote: Hello Alex, Le Mon, 11 Nov 2013 09:05:46 +0100, Alex Thurgood alex.thurg...@gmail.com a écrit : Le 10/11/2013 19:46,

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

2013-11-11 Thread Dan Hall
For what it's worth... I'm just a casual user of LO. It was installed on my new computer when I bought it a year and a half ago. I got on this list because the spell checker wouldn't work. I've remained here because a) I sometimes learn stuff and b) I like it when you guys disagree with one an

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

2013-11-11 Thread Urmas
Charles-H. Schulz: Also, it might be useful to remember that developers tend to contribute because they only want to and find a particular interest in doing so. Maybe it's for a plain old business interest, but when you're a volunteer developer, which is the case of the largest majority of

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

2013-11-11 Thread James E Lang
Ken Springer snowsh...@q.com wrote:. On 11/10/13 9:11 PM, Ady wrote: There are many ways for users to communicate: LibreOffice forum, Ask LibreOffice, several LibreOffice mailing lists, Nabble, wiki, Bugzilla, and several irc channels. The problem is, IMHO, they are sometimes too many and

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

2013-11-11 Thread Paul
Please can somebody ban him for bad language? On Tue, 12 Nov 2013 05:35:01 +0700 Urmas davian...@gmail.com wrote: Charles-H. Schulz: Also, it might be useful to remember that developers tend to contribute because they only want to and find a particular interest in doing so. Maybe it's for

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

2013-11-11 Thread Oogie McGuire
Try it, or I can send you a spreadsheet that fails to change the fonts and you can sew what I mean. On Nov 11, 2013, at 1:25 PM, Paul wrote: This doesn't work for you? I'm surprised. I haven't checked, but I'm fairly sure it works as expected for me. Eugenie (Oogie) McGuire Desert Weyr

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

2013-11-11 Thread mariosv
1) When data is in the spreadsheet, is simple to do it in one column. Select the cell(s) to convert from text to number in one column. Menu/Data/Text to columns - Separating by (nothing selected) 2) With Search Replace Search for:.* Replace with: With regular expression selected in

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

2013-11-11 Thread Denis Navas Vega
El 2013-11-11 01:46 p.m., Paul escribió: On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega denis.na...@gmail.com wrote: The problem is with the symbol ' It can't be searched and replaced. That's why Ady consider it a bug. The only solution, which I used yesterday, is multiply by one. I

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

2013-11-11 Thread David Gast
Spreadsheets use the MVC (model view controller) paradigm. That means that the model (how the data are actually stored) and how you view the data are separated. You can take a number like 4.5 and view it as a date, a date and time, a real number, etc. You can easily compare dates because

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

2013-11-11 Thread Denis Navas Vega
El 2013-11-11 04:00 p.m., David Gast escribió: Spreadsheets use the MVC (model view controller) paradigm. That means that the model (how the data are actually stored) and how you view the data are separated. You can take a number like 4.5 and view it as a date, a date and time, a real

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

2013-11-11 Thread Brian Barker
At 05:51 11/11/2013 -0500, William Drago wrote: I just tried this extension. It's easy to use and seems to work very well. Is there a way to move its icon to a different place on the tool bar? Yes. o Click the down-arrow at the right end of the relevant toolbar and select Customize