https://bugs.documentfoundation.org/show_bug.cgi?id=96755
Jacques Guilleron <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO CC| |[email protected] Ever confirmed|0 |1 --- Comment #1 from Jacques Guilleron <[email protected]> --- Hi Guy, Opening your file in Excel, all Date or time datas appear as text datas (all datas aligned to left). That's why you have this apostrophe when they are imported into Calc. To see your datas as date and time datas, select the range M3:AM54, Open "Find & Replace" in Edit menu. Into "Search For": write .* into "Replace With": write & At bottom, open Options: select "Regular expressions" Into "Replace With", select "Replace All". All selected datas will be replaced by themselves, without apostrophe, and recognized as date and time datas (aligned to right). Tried with LO 5.0.3.2 Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75 and Windows 7 Home. With Calc, formated as date or time datas, then exported to .xlsx format, the datas keep the date and time format, and add no apostrophe when you import it into Calc. Can you verify that? -- 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
