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

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