https://bugs.documentfoundation.org/show_bug.cgi?id=95513
--- Comment #4 from Elmar <[email protected]> --- Thank you, @m.a.riosv, this is very helpful. You are right, setting tools/options/calc/formula/formula syntax to "Excel A1" now means that <!> is also interpreted correctly in Calc. I confirm that that A:A vs. A1:A9999 issue also works correctly. As a matter of version control, I like to work on a base document in ods, odt, etc format, then save it to xls, doc, format with verion number and date for sharing with colleagues. Since they tend to be inconsistent with naming of files, it helps me to keep track of my own original work. I still ahve the problem that if I save the file to xlsx (MSOffice format from 2007), it loses the styles, when I reopen it in Calc. When opening in Excel, the cells display the right format, but the style definitions are missing. -- 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
