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

[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 bar so high! :)
> Regards from
> Tom :)
> 
> 
> 
> 
> On 13 April 2015 at 15:31, V Stuart Foote  wrote:
> 
> > 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 this message in context:
> > http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146130.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 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.
> >
> > I've uploaded your proposed StartCenter mockup to the Wiki--please log-in
> > there (create an account if you do not already have one) and adjust the
> > licensing and description for your artwork.
> >
> > https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding
> >
> > Also, please consider that in your mockup, you appear to have eliminated the
> > thumbnail view of recently used documents. That is a critical design element
> > that can not be removed.  So, your design needs additional work.
> >
> > You'll need to rework  your mockup to show where thumbnail views and
> > templates would be presented.
> >
> > Stuart
> >
> >
> >
> > --
> > View this message in context: 
> > http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146064.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> 
> 
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 and are listed on the File -> Recent Documents listing.
> 
> As circled in red in this screen clip...
> 
>  
> 
> 
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146081.html
> Sent from the Users mailing list archive at Nabble.com.
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[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 updates F5 to reflect the new balance.  F6, 7, 8..  are still
blank.

On Mon, Apr 13, 2015 at 6:24 PM, Dave Liesse 
wrote:

> 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 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 takes the running balance in F4 and adds it to the -/+
>> transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
>> I want F5 to remain $0.00 as well until a new transaction is entered.
>>
>> Barry
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[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 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 takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.

Barry




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[James E Lang]

-Original Message-
From: Barry Premeaux 
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 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 takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.

Revised reply:

Try this in F5
  =IF(E5=0,0,SUM(F4,E5))
or probably better
  =IF(E5="","",SUM(F4,E5))

-- 
Jim

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[James E Lang]

-- 
Jim

-Original Message-
From: Barry Premeaux 
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 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 takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.



Try this in F5
  =IF(E5=0,0,F4+E5)

Translated, that says

Barry

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[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. B1 would have the formula =sum($a$1:a1). Then copy this
formula into the cells below B1, and you will have a running total of the
numbers in column A. Try it and you will see how it works.

b1 has =sum($a$1:a1)
b2 has =sum($a$1:a2)
b3 has =sum($a$1:a3)

and so on.

Mark

On Mon, Apr 13, 2015 at 4:16 PM, Barry Premeaux  wrote:

> 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 takes the running balance in F4 and adds it to the -/+
> transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
> I want F5 to remain $0.00 as well until a new transaction is entered.
>
> Barry
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Basic Calc Question

[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 takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.

Barry

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 this message in context: 
http://nabble.documentfoundation.org/LO-4-4-2-seamonkey-address-book-data-source-tp4146166p4146176.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 able to
pass it on?
Regards from
Tom :)

On 10 April 2015 at 15:17, Italo Vignoli  wrote:

> Berlin, April 9, 2015 - The Document Liberation is a project of The
> Document Foundation, announced in early April 2014 to host the different
> libraries handling proprietary and legacy document formats within
> LibreOffice. The idea was to provide a single repository for other
> software projects willing to deploy the same libraries, in order to
> simplify the integration. The project is led by Fridrich Strba and David
> Tardon, two long time LibreOffice contributors.
>
> During 2014, members of the project released a new framework library,
> called librevenge, which contains all the document interfaces and helper
> types, in order to simplify the dependency chain. In addition, they
> started a new library for importing Adobe PageMaker documents,
> libpagemaker, written as part of Google Summer of Code 2014 by Anurag
> Kanungo.
>
> Existing libraries have also been extended with the addition of more
> formats, like libwps with the addition of Microsoft Works Spreadsheet
> and Database by Laurent Alonso. He is now working on adding support for
> Lotus 1-2-3, which is one of the most famous legacy applications for
> personal computers. Laurent has also added support for more than twenty
> legacy Mac formats to libmwaw.
>
> Developers have created two export libraries - libepubgen for ePub and
> librvngabw for Abiword - and are currently working at improving import
> filters for Adobe Freehand - libfreehand - and Apple Pages - libetonyek.
> Document Liberation libraries are available for Corel WordPerfect
> (including Graphics) and Corel Draw, Microsoft Works, AbiWord, Microsoft
> Publisher and Microsoft Visio, Apple Keynote, Adobe FreeHand, Aldus
> PageMaker, plus many legacy Mac document formats and many e-book formats.
>
> Each library under the Document Liberation umbrella exists as an
> independent project, with its own maintainer, release schedule and
> license, according to the Ethos of Free Software which is championed by
> The Document Foundation.
>
> For more information: http://www.documentliberation.org.
>
> --
> Italo Vignoli - The Document Foundation
> mobile +39.348.5653829 - skype italovignoli
> email / jabber it...@libreoffice.org
> hangout / jabber italo.vign...@gmail.com
> GPG Key ID - 0xAAB8D5C0
> DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0
>
> --
> To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> List archive: http://listarchives.documentfoundation.org/www/announce/
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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  wrote:

> @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-=
> https://bugs.documentfoundation.org/show_bug.cgi?id=57873
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/LO-4-4-2-seamonkey-address-book-data-source-tp4146166p4146169.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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-=
https://bugs.documentfoundation.org/show_bug.cgi?id=57873




--
View this message in context: 
http://nabble.documentfoundation.org/LO-4-4-2-seamonkey-address-book-data-source-tp4146166p4146169.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 adding it again using the
wizard. Choosing "other source" then "Seamonkey" throws a "cannot find data
source" type of error.  I had to back down to 4.2.6 to get my work done.

Did I miss something, is Seamonkey no longer supported, or is this a bug?



--
View this message in context: 
http://nabble.documentfoundation.org/LO-4-4-2-seamonkey-address-book-data-source-tp4146166.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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
providing my opinion.

-- 
Italo Vignoli - The Document Foundation
mobile +39.348.5653829 - skype italovignoli
email / jabber it...@libreoffice.org
hangout / jabber italo.vign...@gmail.com
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 ---
https://wiki.documentfoundation.org/images/d/d4/LibreOffice_Initial_Icons-pre_final.svg
   
And, as well to propose "contest" for Visual design and Branding for
5.0--don't know where that stands.

Opening the stub on the Design Wiki  just gets it all moving--I hope ;-)

But, I did poke Italo in his "LibreOffice 5.0 Visual Identity" task on the
LibreOffice Marketing Redmine site.

Stuart








--
View this message in context: 
http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146156.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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   
> 
> 5.0.0 (freeze: week 21)   Week 16 , Apr 13, 2015 - Apr 19, 2015   Week 31 
> ,
> Jul 27, 2015 - Aug 2, 2015
> 
> The development master will be branched to a 5.0.0alpha0 effective next
> week.
> 
> New to 5.0 will be a true 64-bit Windows build (for Windows >= Vista),
> follow other tidbits in the evolving  LibreOffice 5.0 release notes
>   .
> 
> What is needed from the community now, are your artistic talents. It is time
> for a new motif for 5.0, here is a progression of our StartCenter from 3.3
> to current builds of master (pre-5.0).  As can be seen, the color scheme is
> a bit stale.
> 
> So, break out your graphics packages and draw.  There is a stub for any
> proposals in the Design Wiki Whiteboards at:
> https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding

Thanks a lot for pushing things here, will you coordinate with the
design team and the marketing team? or do you want me to do so? Italo
will come back to the Design list soon, and I'm sure K-J will submit his
great design too.
Cheers
Sophie

-- 
Sophie Gautier sophie.gaut...@documentfoundation.org
GSM: +33683901545
IRC: sophi
Co-founder - Release coordinator
The Document Foundation

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 neither AM nor PM.  It is the
boundary between the two.  So, the correct terms are 12 noon or 12
midnight, if you insist on sticking with the 12 hour clock.  The better
method is to use the 24 hour clock.  This also brings the benefit of,
when used with the ISO date format, the digits are listed in order of
descending value, going from left to right.  This makes sorting on date
& time much easier and allows for no ambiguity.

For example, I am posting this at 2005 04 13 12:37.  There is absolutely
no doubt as to when that is.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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  wrote:

> 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 this message in context:
> http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146130.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 everything
from August waaay before anything from March.
Regards from
Tom :)




On 13 April 2015 at 15:26, James Knott  wrote:

> 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 there
> is nothing to indicate it or the date it actually represents.  Some
> times I can guess, based on context or by looking for other dates to
> determine which format makes sense. i.e. a number greater than 12 is
> likely not a month.  ;-)
>
> Given the amount of international interchange, even ignoring the fact
> that local custom is often not followed, the only way to be sure is to
> use the ISO spec and nothing else.  Isn't it also part of that ISO
> certification that companies follow for business practices?
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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 column of date to New Blank Word document.
>>
>>   Then I Again copied the date column from word document and came back to my
>> original excel sheet.
>>
>> Then right click and press Pest Special -->Paste as TEXT.
>>
>> Done. Now Excel will recognize it as date and will allow you to format cells
>> any date format as you wish. 
>>
>>
>>
> 
> What is particularly irritating about your oversimplified approach with
> WinWord and Excel is that it is not reproducible with LibreOffice.
> It may work with Calc and a plain text editor (or not, depending on the
> outlined details).
> 
> 
> 

How does your Excel handle the following data set?

04/12/2015
04/13/2015
04/14/2015
04/10/2015
04/14/2015



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 this message in context: 
http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146130.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 there
is nothing to indicate it or the date it actually represents.  Some
times I can guess, based on context or by looking for other dates to
determine which format makes sense. i.e. a number greater than 12 is
likely not a month.  ;-)

Given the amount of international interchange, even ignoring the fact
that local custom is often not followed, the only way to be sure is to
use the ISO spec and nothing else.  Isn't it also part of that ISO
certification that companies follow for business practices?


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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.
> 
>   Then I Again copied the date column from word document and came back to my
> original excel sheet.
> 
> Then right click and press Pest Special -->Paste as TEXT.
> 
> Done. Now Excel will recognize it as date and will allow you to format cells
> any date format as you wish. 
> 
> 
> 

What is particularly irritating about your oversimplified approach with
WinWord and Excel is that it is not reproducible with LibreOffice.
It may work with Calc and a plain text editor (or not, depending on the
outlined details).



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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.
> 
> That is why people should be using only the ISO format.
> 
> https://en.wikipedia.org/wiki/ISO_8601
> 

Oh, and 90% of related questions is not about how to correctly import
text data. People want to know how to fix wrongly imported data which is
slightly more difficult than doing it right in the first place.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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.
> 
> That is why people should be using only the ISO format.
> 
> https://en.wikipedia.org/wiki/ISO_8601
> 

But nobody does. Not my bank from where I import account statements,
yahoo finance, amazon, ebay, you name it.
Calc can handle crazy date formats, even those with written month names
in dozends of languages. But you need to specify your special
requirements. Importing 13-04-2015 works out of the box once you have
checked the "special numbers" option. In case of a US locale you need to
specify that this is meant to be a non-US date, "English (UK)" will
handle this correctly.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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 formula?

Can you accept that a general solution to the problem of wrongly
imported text data may be slightly more difficult than you think?
The original poster did not provide any technical information to his
particular problem and he did not respond to anybody. Therefore I
suggested a one-method-fits-all solution which involves a maximum of 6
simple steps:

1. adjust the locale setting if necessary
2. paste and adjust my spreadsheet formula into a cell
3. copy the formula down the column (double-click the cell handle)
4. paste-special resulting numbers over the wrong data
5. If 1. then switch back to your preferred locale
6. format to your liking

This will convert text dates as well as wrong dates (switched month and
day) in one go and won't take more than 30 seconds.




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 ISO format.

https://en.wikipedia.org/wiki/ISO_8601

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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.
> 
>   Then I Again copied the date column from word document and came back to my
> original excel sheet.
> 
> Then right click and press Pest Special -->Paste as TEXT.
> 
> Done. Now Excel will recognize it as date and will allow you to format cells
> any date format as you wish. 
> 
> 
> 


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.

> Then right click and press Pest Special -->Paste as TEXT.

When you paste-special unformatted text into LibreOffie Calc you will
get the text import dialog. There you need to choose the right locale
(any non-USA in this particular case) and you need to check the "special
numbers" option. Otherwise you will get text values again.

Your MS Office may be "easier" BUT if the origin of the text data
differs from the office locale it may import wrong data again and again.




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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.

I've uploaded your proposed StartCenter mockup to the Wiki--please log-in
there (create an account if you do not already have one) and adjust the
licensing and description for your artwork.

https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding

Also, please consider that in your mockup, you appear to have eliminated the
thumbnail view of recently used documents. That is a critical design element
that can not be removed.  So, your design needs additional work.

You'll need to rework  your mockup to show where thumbnail views and
templates would be presented.

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146064.html
Sent from the Users mailing list archive at Nabble.com.





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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: 
http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146104.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 wouldn't want to go in this direction for
the main theming of LO - although i suspect that it would make an extremely
popular theme to add to LO.
Regards from
Tom :)





On 13 April 2015 at 04:29, V Stuart Foote  wrote:

> The thumbnail views are iconic representations of the documents that have
> recently been opened and are listed on the File -> Recent Documents
> listing.
>
> As circled in red in this screen clip...
> <
> http://nabble.documentfoundation.org/file/n4146081/StartCenter_master_with_recentDocumentThumbnailViews.jpg
> >
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146081.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 - "as unformattted text"

Nicely done and a good answer imo :)
Regards from
Tom :)

On 13 April 2015 at 07:58, bhaumikdave  wrote:

>
> 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 document and came back to
> my
> original excel sheet.
>
> Then right click and press Pest Special -->Paste as TEXT.
>
> Done. Now Excel will recognize it as date and will allow you to format
> cells
> any date format as you wish.
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146086.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: converting txt to dates

[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 document and came back to my
original excel sheet.

Then right click and press Pest Special -->Paste as TEXT.

Done. Now Excel will recognize it as date and will allow you to format cells
any date format as you wish. 



--
View this message in context: 
http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146086.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted