Re: [libreoffice-users] Excel file in LibreOffice Calc

Hi :)
The ' marks defines the cell as being text.  It is so that zip codes, telephone numbers and such 
can be displayed with leading zeros and other things that wouldn't display properly if imported as 
number.
Regards from
Tom :)

--- On Thu, 22/9/11, planas <jslozier@gmail.com> wrote:

From: planas <jslozier@gmail.com>
Subject: Re: [libreoffice-users] Excel file in LibreOffice Calc
To: users@global.libreoffice.org
Date: Thursday, 22 September, 2011, 5:26

Hi,

On Wed, 2011-09-21 at 13:25 -0300, Luciano R. Moreira - Desenvolvimento
wrote: 

> Hi,
>
> I am a software developer Folhamatic Systems Company in Brazil
>
> I'm having problem saving the report generated by my system developed in Delphi 7 to Excel (XLS) 
> using the component with component QuickReport 5.2 Gnostice eDocEngine company.
>
>    The problem is:
>
>    - The date fields and values ??are being displayed in the program "Open Office / BR Office / 
> LibreOffice" with the character (apostrophe) and cause error in the calculation of the value field 
> because they are as text. Take the example of incorrect visualization in OpenOffice / BROffice / 
> LibreOffice: '$ 100.00
>
> Is there any solution or configuration LibreOffice to view the date fields and value to its 
> corresponding type in the program "Open Office or BROffice or LibreOffice"? Is there a solution 
> to correctly view this way: $ 100.00?
>
> Remember that Microsoft's Excel has no problems.

I am trying to remember why the ' is used, I think it has something to
do with controlling the formatting. When I tried using the ' with a
number I was able to add it to another number. And when I used it with a
date what I noticed that 'date displayed as it was entered but the date
alone used the system default.

Are you having any problems with formulas or calculations giving
incorrect results? 

> Thanks
>
> Luciano Ricardo Moreira 
> Desenvolvimento 
> Tel.:+55 (19)3471-3909 
> www.folhamatic.com.br 
>
>        
>       



-- 
Jay Lozier
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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