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 [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
