https://bugs.freedesktop.org/show_bug.cgi?id=44817
Robinson Tryon (qubit) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Summary|FILEOPEN .xls, SUM() with |FILESAVE: when saving as |more than 30 comma |XLS, add explicit warning |separated summands cell |when file cannot be |should show formula + value |correctly represented by |instead of error message |the file format (# of | |function args) Ever confirmed|0 |1 --- Comment #20 from Robinson Tryon (qubit) <[email protected]> --- TESTING with 4.4.0.0.alpha2 + Ubuntu 14.05 (In reply to Jean-Baptiste Faure from comment #19) > If I understand right, the problem occur when saving a spreadsheet in xls > file format in Calc. As showed by the Kohei's screencopies MS-Excel does not > allow to create a SUM formula with more than 30 arguments. (if anyone wants to test a sum of 1..31 (or more) entries, generate it w/this: for i in `seq 1 31`; do echo -n A$i, ; done ) > When saving in > foreign formats the user is notified that it is possible that not all > features of Calc are supported by the foreign format. True, but we only give them the same generic "This document *may* contain formatting or content.." message we give every time we save in a non-ODF format. This is a great example of a specific case in which we *know* that the file format can't handle what we're trying to shove into it. IMHO, ideally the dialog should read This document contains formatting that *cannot* be saved...Microsoft Excel.. with a bullet point below the paragraph that states something like: * Cell B31: More arguments have been specified for this function than are allowed...(etc.) I'd also suggest we add a (default to unchecked) box that must be checked before the user can click the save button. It should be labeled thusly: [ ] I understand that this is a dangerous operation that loses data! > I think that users who use LibreOffice to save documents in MS-Office should > be aware of what is allowed by the file format they choose. I agree that they should be aware, but unless *we* spell it out for them, they will almost certainly never figure it out on their own. > I suggest to close this bug report as NotABug. > I agree that we can't engineer a fix for Excel, but I think this bug is valid as an enhancement request for a better warning. Summary -> (updated) Status -> NEW -- 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
