[New: openFATE 308476] Make text cell interpretation configurable
![](https://seccdn.libravatar.org/avatar/0295f9d5d76379b5da73427b67acd395.jpg?s=120&d=mm&r=g)
Feature added by: Kohei Yoshida (kohei_yoshida) Feature #308476, revision 1 Title: Make text cell interpretation configurable Requested by: Kohei Yoshida (kohei_yoshida) Description: For xls compatibility reasons, we modify the formula calculation so that * text cells in an addition throw an error e.g. =A1+B1 where B1 is a text cell. * text cells in SUM are interpreted as 0 e.g. =SUM(A1:B1) where B1 is a text ell. But some users don't like these behaviors since they are "inconsistent" with each other. We probably therefore make these configurable, perhaps in the 'Formula' option page. -- openSUSE Feature: https://features.opensuse.org/308476
![](https://seccdn.libravatar.org/avatar/0295f9d5d76379b5da73427b67acd395.jpg?s=120&d=mm&r=g)
Feature changed by: Kohei Yoshida (kohei_yoshida) Feature #308476, revision 2 Title: Make text cell interpretation configurable Requested by: Kohei Yoshida (kohei_yoshida) Description: For xls compatibility reasons, we modify the formula calculation so that * text cells in an addition throw an error e.g. =A1+B1 where B1 is a text cell. * text cells in SUM are interpreted as 0 e.g. =SUM(A1:B1) where B1 is a - text - ell. + text cell. But some users don't like these behaviors since they are "inconsistent" with each other. We probably therefore make these configurable, perhaps in the 'Formula' option page. -- openSUSE Feature: https://features.opensuse.org/308476
participants (1)
-
fate_noreply@suse.de