https://bugs.freedesktop.org/show_bug.cgi?id=66985
--- Comment #4 from Parameshwara Bhat <[email protected]> --- (In reply to comment #2) > We are not able to move forward if we do not understand the problem. Please, > attach a test file so we could continue. > > The problem is not easy to understand and reporoduce => can't block the > release => lowering the severity ab it. Thank you for the promptness with which you responded to the reported issue. By any standards it is great, by OO standards - where a reported issue did not elicit response for years and which had me totally put-off - this promptness is unthinkable. Coming to the issue, my office, personal systems are all on Linux / LO. My only dual boot Windows installation did not work. So, this had to wait. You are right. I created an xls file in Excel and opened it in LO. One column containing numbers explicitly formatted as numbers and another column with numbers, but with default formatting. Both had no apostrophe in LO. So, this is not a general problem. But I have attached an excel sheet which I downloaded from my bank. This file when opened in LO treats all numbers and dates as text. I cannot say whether the apostrophe before the numbers / dates was introduced by LO while first reading it or was in the original excel file produced by the Bank.But this file, when opened in MSO, does not show the apostrophe in cell editing or formula bar and the data are also treated as DATE / NUMBER as relevant. Only clue to them being text is the data are all left aligned. The ditto behaviour in calligra sheets as well. I have also observed any excel file produced by Java Jasper Library behaves exactly same way in LO. Though the datta in jasper report is treated as number, when exported to execl, all dates and numbers have apostrophe before them.I do not know if the bank also used Jasper to produce Excel. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
