Re: [libreoffice-users] Opening a CSV file with Calc

2012-09-28 Thread nvrk
On Fri, Sep 28, 2012 at 6:41 PM, Jeff Hahn hahn...@outlook.com wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I

Re: [libreoffice-users] Specialty Dictionaries

2012-07-05 Thread nvrk
On Thu, Jul 5, 2012 at 3:06 AM, Simon Cropper simoncrop...@fossworkflowguides.com wrote: Yeah, I have thought of both these things. Have hacked a standard file before, particularly in MS Word. Easily done assuming it is a text file and not a binary file. The problem is the binomial. I also

Re: [libreoffice-users] The way SUM works

2011-12-20 Thread nvrk
The number displayed in a Calc cell is limited in decimal places by the formatting preference. Set the number format for the cells to show more decimal places and see the results. In your case the sum calculation is based on the actual multiplication result in the individual cells to a large

Re: [libreoffice-users] Unable to use LibreOffice 3

2011-12-15 Thread nvrk
On Wed, Dec 14, 2011 at 9:06 PM, Sharon L Knoblock slknobl...@gmail.comwrote: I downloaded LibreOffice 3, selected text document to write a letter. I get a flashing cursor but cannot view what I have typed. I am able to import documents from other programs and work with them from LibreOffice

Re: [libreoffice-users] Re: Can Libre Office be installed on an external drive. ?

2011-09-05 Thread nvrk
On Mon, Sep 5, 2011 at 8:07 AM, Twayne twa...@twaynesdomain.com wrote: In news:loom.20110905t023739-...@post.gmane.org, Charles E. LaMonte n3...@arrl.net typed: Greetings Ladies and Gentlemen, Is it possible to install Libre Office on an external hard drive ? The computer will have either

Re: [libreoffice-users] Linked Cell says True instead of Showing the value

2011-08-29 Thread nvrk
Do you think that this could be a cell format problem? nvsoar On Aug 28, 2011 5:34 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/8/28 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Even just copypasting the equation into a reply to this thread might help ;) Regards from Tom :) Might

Re: [libreoffice-users] Date Format in Writer

2011-08-11 Thread nvrk
FWIW - I prefer mmmdd or ddmmm where the 'm' is alphabetic; - unambiguous! nvsoar On Thu, Aug 11, 2011 at 1:46 PM, Stan Goodman stan.good...@hashkedim.comwrote: On Thursday 11 August 2011 22:40:04 planas wrote: Johnny On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote:

Re: [libreoffice-users] HELP WITH CODE excel

2011-08-06 Thread nvrk
On Sat, Aug 6, 2011 at 8:13 PM, Joseph Da Silva joseph_da_si...@hotmail.com wrote: Hi I was wondering if someone could help me with this code it works in excel but not with libra office. =INDIRECT(CELL(ADDRESS,INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011-06-06 Thread nvrk
messages sent to this list will be publicly archived and cannot be deleted From nvrk - Here's a crude attempt at efficiently finding non numerical entries in a long column of numbers. For each entry =if(isnumber(A1)1;Row();) conditionally formatted in a bright color if desired. Single cell of =min

Re: [libreoffice-users] Calc Question

2011-04-11 Thread nvrk
I suggest going to the help section and entering data validity in the search box. This worked for me in OpenOffice.org. nvsoar On Mon, Apr 11, 2011 at 12:18 PM, Chris Gummo ch...@reclamere.com wrote: This formula =COUNTIF($F$4:$K$380;F4)=1 is actually used in the Data Validation section in

Re: [libreoffice-users] Re: Calc: Problem pasting listboxes

2011-03-20 Thread nvrk
/special is used? FWIW - I could easily be barking up a wrong tree here since I am a far cry from an experienced user. nvrk -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly