Hi On Thu, 2011-08-11 at 06:11 -0700, msaum@smi wrote:
> We have main frame reports that are generated using "xhtml" and saved as > extension "xls". When the user gets the report they would typically just > open them with excel, no problem... Calc does not open them properly. When > I ope CALC and manually open the spreadsheet, it eventually opens in > Writer/Web and does not look like the same result as Excel does.... This is > a major stumbling block for us to move over to Libre Office.. We are engaged > with application vendor to change the report, but we all know how that can > be....SLOWWW.. > > -- > View this message in context: > http://nabble.documentfoundation.org/Opening-xls-file-with-xhtml-embedded-tp3245877p3245877.html > Sent from the Users mailing list archive at Nabble.com. > Instead of opening the file try importing the file into Calc using INSERT >> SHEET FROM FILE. You will be presented with an import wizard. If that does not work you link to data, also under INSERT. I think the problem is when the encoding is read by LO it sees as an XHTML page for Writer. Excel is a stand alone product, as all the MSO suite members while LO is an integrated suite (you get everything at once). So LO opens a file it tries to open it with what is normally the best option based on the actual encoding. Changing the file extension does not change the file encoding. This can cause problems because the opening program may incorrectly interpret the file format present gibberish. The best way for the main frame to output is with the correct extension or as a CSV file which any spreadsheet can handle. -- 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
