[Libreoffice-bugs] [Bug 119509] FILEOPEN wrong column format in ODS but not XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119509

--- Comment #11 from Dan Arnfield <dan at arnfield.com> ---
I'm still not understanding why there is a difference in behavior, or perhaps
why there *should* be a difference. If recalculating General format cells on
fileopen to determine result type is the right thing to do, why shouldn't it be
the right thing to do when the format is explicitly applied? Or put another
way, if General is supposed to represent the "auto" format for a particular
formula (i.e. the result type), why should it not figure that out immediately
rather than do the equivalent of "clear direct formatting" except without
persistence?

I guess what I'm trying to say is that General represents two different things
depending on when it's applied (explicitly applied vs fileopen). From a user
perspective this breaks the principle of least surprise. But I know how to work
around my particular issue now, so if you don't agree this can be closed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180830/4e503fa8/attachment.html>