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 <[email protected]> wrote: From: planas <[email protected]> Subject: Re: [libreoffice-users] Excel file in LibreOffice Calc To: [email protected] 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 [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 -- 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
