[libreoffice-users] Re: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Owen Genat
M. Fioretti wrote Summarizing, it seems I need some efficient way to tell Calc, when it opens that file, that all the cells of a certain column, except the header, are NUMBERS, not text, in the -1234.12 format. What Mirosław Zalewski has suggested upthread is essentially correct. The data

[libreoffice-users] Date format resists conditional format

2014-04-20 Thread office76#xt
Hi, I have a column of dates in Calc that look like this: 01.07.1986 02.07.1986 03.07.1986 04.07.1986 This is a day, month, year format. Normally I could conditionally format the column to say detect all the days in the column that fall on the 4th day of the month, and turn the background

Re: [libreoffice-users] Any thoughts on Tutor.com's policy of MS Word only?

2014-04-20 Thread Tom Davies
Hi :) Yeh, going back to the original post i realised the question was about becoming a tutor rather than becoming a student. So, it's still a case of having to use all-MS systems but we all have to earn money somehow. At least if it's someone fairly honourably and aware of alternatives then it

Re: [libreoffice-users] Re: Heartbleed

2014-04-20 Thread Tom Davies
Hi :) http://www.theregister.co.uk/2014/04/18/netcraft_heartbleed_browser_extension/ Netcraft's updated browser extension is available as a free download for Firefox 1.0 and later; Chrome 26 and later on Windows, OS X, and Linux; and for Opera 15 and later on OS X and Windows. Versions for other

[libreoffice-users] Re: Date format resists conditional format

2014-04-20 Thread Owen Genat
office76#xt wrote Hi, I have a column of dates in Calc that look like this: 01.07.1986 ... Any way to reformat the Date column into some Date format that would allow conditional formatting as just described? Any ideas welcome. Given 01.07.1986 in cell A1 these entries in the

Re: [libreoffice-users] Re: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread M. Fioretti
On Sat, Apr 19, 2014 23:44:20 PM -0700, Owen Genat wrote: M. Fioretti wrote Summarizing, it seems I need some efficient way to tell Calc, when it opens that file, that all the cells of a certain column, except the header, are NUMBERS, not text, in the -1234.12 format. What Mirosław

Re: [libreoffice-users] Date format resists conditional format

2014-04-20 Thread Brian Barker
At 13:14 19/04/2014 -0700, Nobody Noname wrote: I have a column of dates in Calc that look like this: 01.07.1986 02.07.1986 03.07.1986 04.07.1986 This is a day, month, year format. You say they look like this, which is not entirely helpful! Are these genuine dates, i.e. numbers formatted as

Re: [libreoffice-users] cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Heikki Jussila
On Sunday, 20 April 2014, M. Fioretti mfiore...@nexaima.net wrote: On Sat, Apr 19, 2014 23:44:20 PM -0700, Owen Genat wrote: M. Fioretti wrote Summarizing, it seems I need some efficient way to tell Calc, when it opens that file, that all the cells of a certain column, except the

[libreoffice-users] SOLVED: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread M. Fioretti
On Sat, Apr 19, 2014 20:05:39 PM +0200, Marco Fioretti wrote: Greetings, I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: |||2013-02-15|Payment A|-100.25|008|fae|

[libreoffice-users] Native MySQL-Connector

2014-04-20 Thread Heinrich Stoellinger
Hello, Does anybody know whether the native MySQL-connector for Windows will ever be ported to Linux/Mac-Versions of LO? Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] SOLVED: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Paul
I just ran some tests on my system, and it seems like all I need to do is choose a Language that uses the correct decimal specifier, and the numbers are imported as numbers. Then I experimented a bit with the Column type for the number column. If I use a comma as decimal separator in the file,

[libreoffice-users] Empty fields in mail merge/labels.

2014-04-20 Thread Dave Barton
A client has asked me a question I am unable to answer, or find definite information about. I suspect the answer will be not possible, but wanted to check with you folks first. In mail merge and labels there is a work-around to skip empty lines, but is there a hack to skip empty fields within an

Re: [libreoffice-users] Re: Getting back to the Start screen

2014-04-20 Thread M Henri Day
2014-04-16 18:45 GMT+02:00 Tom Davies tomc...@gmail.com: Hi :) +1 I agree. It is more of an issue now the start screen is so much nicer looking and more useful. Posting a feature-request through the bug-report system would be fantastic. Ideally with someone who feels fairly strongly

Re: [libreoffice-users] Native MySQL-Connector

2014-04-20 Thread Tom Davies
Hi :) I thought a new one needed to be built for each different OS and each new version of MySql? Also that building one is not all that complicated but just takes ages once set to build? Regards from Tom :) On 20 April 2014 11:34, Heinrich Stoellinger hc.stoellin...@aon.at wrote: Hello,

Re: [libreoffice-users] SOLVED: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Tom Davies
Hi :) Feature requests are often a good plan. The QA team and then the devs can then work out how to move things forwards. https://wiki.documentfoundation.org/QA/BugReport CSV is notoriously non-standardised so differences between different people's experiences is not uncommon. It is an

Re: [libreoffice-users] Re: Getting back to the Start screen

2014-04-20 Thread Tom Davies
Hi :) Thanks :))) That initial bite of interest might have been just the QA team making sure the report is ready for the main devs. However it has been known to get a devs interest that quickly = it really depends a lot on luck (unless it's a security issue). Regards from Tom :) On 19 April

[libreoffice-users] Re: Native MySQL-Connector

2014-04-20 Thread Alexander Thurgood
Le 20/04/14 12:34, Heinrich Stoellinger a écrit : Hi Heinrich, Hello, Does anybody know whether the native MySQL-connector for Windows will ever be ported to Linux/Mac-Versions of LO? The Linux distros provide their own version of the connector - well actually, it depends on the distro -

[libreoffice-users] Re: Native MySQL-Connector

2014-04-20 Thread Alexander Thurgood
Le 20/04/14 12:34, Heinrich Stoellinger a écrit : BTW, don't the Apache OpenOffice native connector extensions work for you ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] Re: Getting back to the Start screen

2014-04-20 Thread V Stuart Foote
David, *, The enhancement of returning to the Start Center at any point is actually a reasonable idea. But, always helpful if we post the link to the bug or enhancement request entered in Bugzilla, that way all can follow along and comment there. So that is fdo#77590

[libreoffice-users] Calc Sum cells based on color

2014-04-20 Thread Franco
Hm, html stripped away. Let me retry adding a link to an image explaining what I mean: http://s30.postimg.org/616qwbcb5/calc_sum_colors.png -- Hi all, I'm looking for a solution to a problem with Calc similar to many requests I read googling around. Here the question: I have an

[libreoffice-users] Re: SOLVED: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Tinkerer
I import English web data. I installed the Extension CT2N, Convert Text To Numbers, and this puts an icon in the Tool Bar. A click on CT2N and it is done. I had a problem with currency prefixes as they did not convert, but Cor Nous sorted that for me. Tink. -- View this message in context:

[libreoffice-users] Why new page style after manual page break changes all pages?

2014-04-20 Thread Sean Darcy
With libreoffice-writer-4.2.3.3-4.fc20.x86_64, I'm trying to write a simple business letter: first page : header company logo footer contact info next pages : header addressee and date footer none appendix : no header no footer So I've modified the

Re: [libreoffice-users] Why new page style after manual page break changes all pages?

2014-04-20 Thread Brian Barker
At 18:44 20/04/2014 -0400, Sean Darcy wrote: I write the 3-4 page letter. Get to signatures, and insert a manual page break. On the new page I double click appendix page style. That changes the page style for ALL the pages to appendix. It will. A break between page styles occurs only

Re: [libreoffice-users] Re: Getting back to the Start screen

2014-04-20 Thread Tom Davies
Hi :) I agree with this too. I think it is probably a different issue from the subject of this thread though, at least as far as the devs probably see it. So it probably could do with a separate feature-request. Perhaps put a link from each report to the other to keep them close? Regards from

Re: [libreoffice-users] LO for Chrome OS - i.e. Samsung Chrome Book

2014-04-20 Thread Tom Davies
Hi :( Do!!! Yes, being for Windows-only is a bit of a blocker!! Sorry Tim@KrackedPress!! :(( I thought it was an easy answer and ended up being quite rude. Many apologies for those posts! Wine can be really annoying and their mailing-lists and help system tends to be extremely rude to