[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread V Stuart Foote
@Sophie, Happy to do what I can to move this along with both Design (I'm a member) and the Marketing teams. After last weeks Design meeting, Kendy was going to approach Marketing--specifically regards status of the LibreOffice Tango based icons as branding ---

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread Italo Vignoli
On 13/04/15 20:01, V Stuart Foote wrote: But, I did poke Italo in his LibreOffice 5.0 Visual Identity task on the LibreOffice Marketing Redmine site. I have just looked at Redmine, and I will reply ASAP. I do not have a quick answer to the question, so I am trying to elaborate a bit before

[libreoffice-users] LO 4.4.2 seamonkey address book data source

2015-04-13 Thread ktc
I just upgraded to the latest LO 4.4.2 from 4.2.6. I use Seamonkey (latest release) for my address book source. Today was the first time I needed addresses in a Writer doc since the upgrade and it was a no-go, getting a cannot load type of error. I deleted the previous data source and tried

[libreoffice-users] Re: LO 4.4.2 seamonkey address book data source

2015-04-13 Thread V Stuart Foote
@ktc, Please open a BZ issue for this and provide full OS and system details--https://bugs.documentfoundation.org/ Are you on Windows? We did recently dump a the 32-bit Seamonkey library linkage in favor of mork, may be the issue for you. Stuart =-ref-=

[libreoffice-users] Re: [tdf-announce] The Document Liberation, one year after

2015-04-13 Thread Tom Davies
Hi :) I really like the sound of this. If other Office Suites and programs join in then we might have even better libraries for all the programs and suites to use. Is anyone here on the mailing lists or similar for other programs and suites such as Abiword, Gnumeric, Calligra or any others and

[libreoffice-users] Re: LO 4.4.2 seamonkey address book data source

2015-04-13 Thread ktc
V Stuart Foote wrote Are you on Windows? We did recently dump a the 32-bit Seamonkey library linkage in favor of mork, may be the issue for you. That is probably it - 32-bit Win7 here. Bummer. I'm not prepared for a PC upgrade yet so I guess I'll stick with 4.2 for a while longer. -- View

Re: [libreoffice-users] Re: LO 4.4.2 seamonkey address book data source

2015-04-13 Thread Tom Davies
Hi :) Mork? I'm guessing nothing to do with Mindy but is it some sort of generic connector or something cleverer? (i suspect cleverer) If so does it need to be activated in some way? Regards from Mystified :) On 13 April 2015 at 22:06, V Stuart Foote vstuart.fo...@utsa.edu wrote: @ktc,

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread Mark Phillips
I don't understand the references to a conditional statement and the reference to 0. But, to create a running balance, you just use a sum with the first cell anchored. For example, assume entries are in the first column, A starting at A1, and you want the running total in column B starting at B1.

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread James E Lang
-Original Message- From: Barry Premeaux bpreme...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the question

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread James E Lang
-- Jim -Original Message- From: Barry Premeaux bpreme...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the

[libreoffice-users] Basic Calc Question

2015-04-13 Thread Barry Premeaux
I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the question properly. I am trying to build a general ledger. I have my running balance in the F column and transactions in the E column. I am trying to construct a conditional statement that

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread Dave Liesse
Speaking as an accountant, I'm not sure why you would want the balance to show 0. Nevertheless, what you need is: =IF(E5=0,0,F4+E5) And, of course, you want to copy that to each cell in the F column. Dave Liesse Skingco Services, LLC On 4/13/2015 16:16, Barry Premeaux wrote: I'm a

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread jorge
Hi Tom: Thank you Regards, Jorge Rodríguez El lun, 13-04-2015 a las 17:33 +0100, Tom Davies escribió: Hi :) +1 Also hoping we get some other new great themes developing as a side-effect but i think the focus needs to be on the opportunity at hand. Thanks Jorge, for setting the

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread Barry Premeaux
Thank you. I will give this a try. I guess a better description might have been a basic check book. The balance cell is empty until an associated transaction is entered. Then it updates the balance to reflect the transaction just made. If F4 is current balance, a transaction entered in E5

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread jorge
Hi all: Thank you, excuse me but I haven't match that word with that perfomance. It is clear now. Regards, Jorge Rodríguez El dom, 12-04-2015 a las 20:29 -0700, V Stuart Foote escribió: The thumbnail views are iconic representations of the documents that have recently been opened

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread jorge
Hi Bill: Thank you for the information Regards, Jorge Rodríguez El lun, 13-04-2015 a las 05:26 -0400, William Drago escribió: The thumbnail view of recently used docs is one of the things that I LOVE about LibreOffice. To hear that it is a critical design element that can not be

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread bhaumikdave
What ever the wordings are, conveying idea is important. I am not The Expert but just want to solve the issue using more simpler method rather than formulating some creepy scripts. -- View this message in context:

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Tom Davies
Hi :) I think you meant Writer rather than Word! Also Calc rather than Excel. However those sorts of tricks often work in all sorts of different Office suites. I would probably have used a text-editor rather than W* to avoid any weird formatting creeping in but you did the same by paste-special

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread bhaumikdave
Hi, I got a simple solution to this. My date format in excel sheet was like 12-04-2015. Excel was not recognizing it as date or Formatting cell to Date was helping me. So I selected and Copied entire column of date to New Blank Word document. Then I Again copied the date column from word

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread William Drago
The thumbnail view of recently used docs is one of the things that I LOVE about LibreOffice. To hear that it is a critical design element that can not be removed is wonderful news to me. Thanks, -Bill On 4/12/2015 1:42 PM, V Stuart Foote wrote: Jorge Rodríguez Thank you for submitting.

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread Tom Davies
Hi :) I think, but i could easily be wrong, that there is not much point in taking the mock-up much further. I think people can see enough of the concept from what is there already and i'm sure a lot of people would have input tweaking this-or-that detail. Also i suspect that TDF probably

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Andreas Säger
Am 13.04.2015 um 15:54 schrieb James Knott: On 04/13/2015 09:38 AM, Andreas Säger wrote: This __happens__ to work for you. What does 12-04-2015 actually mean? On my system this will be interpreted as 12th of April. People with US locale will get a date value referring to the 4th of December.

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Andreas Säger
Am 13.04.2015 um 08:58 schrieb bhaumikdave: Hi, I got a simple solution to this. My date format in excel sheet was like 12-04-2015. Excel was not recognizing it as date or Formatting cell to Date was helping me. So I selected and Copied entire column of date to New Blank Word document.

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Andreas Säger
Am 13.04.2015 um 08:58 schrieb bhaumikdave: Hi, I got a simple solution to this. My date format in excel sheet was like 12-04-2015. Excel was not recognizing it as date or Formatting cell to Date was helping me. So I selected and Copied entire column of date to New Blank Word document.

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Andreas Säger
Am 13.04.2015 um 15:54 schrieb James Knott: On 04/13/2015 09:38 AM, Andreas Säger wrote: This __happens__ to work for you. What does 12-04-2015 actually mean? On my system this will be interpreted as 12th of April. People with US locale will get a date value referring to the 4th of December.

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread James Knott
On 04/13/2015 10:16 AM, Andreas Säger wrote: But nobody does. Not my bank from where I import account statements, yahoo finance, amazon, ebay, you name it. Well, I often see it, particularly on government forms. On the other hand, I have often seen dates and wondered what format it was, as

[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread V Stuart Foote
jonathon-4 wrote For some of us, those thumbnails are a security flaw. And all cleared with a single menu button click. So, it never has been a flaw--rather as designed ;-) Otherwise, hoping to see some great artwork and visual design suggestions from the user community. Stuart -- View

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread toki kantoor
William wrote: To hear that it is a critical design element that can nit be removed is wonderful news to me. For some of us, those thumbnails are a security flaw. Jonathon -- Sent from my Android device with K-9 Mail. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Andreas Säger
Am 13.04.2015 um 10:56 schrieb bhaumikdave: What ever the wordings are, conveying idea is important. I am not The Expert but just want to solve the issue using more simpler method rather than formulating some creepy scripts. Which script? You mean the ordinary, simple spreadsheet

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread James Knott
On 04/13/2015 09:38 AM, Andreas Säger wrote: This __happens__ to work for you. What does 12-04-2015 actually mean? On my system this will be interpreted as 12th of April. People with US locale will get a date value referring to the 4th of December. That is why people should be using only the

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread James Knott
On 04/13/2015 12:30 PM, Tom Davies wrote: They prefer to have everything from August waaay before anything from March. Another thing that adds to the fun is the 12 hour clock, so that 12:59 AM is before 1:00 AM. Of course, another bit of nonsense is 12 AM or PM. The precise moment of 12:00 is

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Piet van Oostrum
James Knott wrote: For example, I am posting this at 2005 04 13 12:37. There is absolutely no doubt as to when that is. Except for the time zone :) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to:

Re: [libreoffice-users] Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread Sophie
Hi Stuart, Le 11/04/2015 04:07, V Stuart Foote a écrit : If folks have not been paying attention, there has been sufficient movement in the project to warrant a 5.0 branding of the next major release. From the Release plan https://wiki.documentfoundation.org/ReleasePlan 5.0.0 (freeze:

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread James Knott
On 04/13/2015 12:37 PM, James Knott wrote: For example, I am posting this at 2005 04 13 12:37. There is absolutely no doubt as to when that is. Ooops!!! Typo. That should be 2015, not 2005. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread James Knott
On 04/13/2015 12:46 PM, Piet van Oostrum wrote: For example, I am posting this at 2005 04 13 12:37. There is absolutely no doubt as to when that is. Except for the time zone :) If relevant, then specify. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Tom Davies
Hi :) I use it quite a lot. It makes sorting files a lot easier. If all files were created or modified on the date that is most relevant to the contents of the file then it would be quite simple but life is seldom that simple ime. Of course no-one in my office understands. They prefer to have

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-13 Thread Tom Davies
Hi :) +1 Also hoping we get some other new great themes developing as a side-effect but i think the focus needs to be on the opportunity at hand. Thanks Jorge, for setting the bar so high! :) Regards from Tom :) On 13 April 2015 at 15:31, V Stuart Foote vstuart.fo...@utsa.edu wrote:

[libreoffice-users] Re: converting txt to dates

2015-04-13 Thread Andreas Säger
Am 13.04.2015 um 16:22 schrieb Andreas Säger: Am 13.04.2015 um 08:58 schrieb bhaumikdave: Hi, I got a simple solution to this. My date format in excel sheet was like 12-04-2015. Excel was not recognizing it as date or Formatting cell to Date was helping me. So I selected and Copied entire