https://bugs.documentfoundation.org/show_bug.cgi?id=172799
--- Comment #19 from Ben Urban <[email protected]> --- (In reply to ady from comment #18) > OTOH, saying to someone that you are happy to see him go away, is not kind. > I do not have the language knowledge in order to potentially interpret that > phrase as meant with kindness, unless my life is being threatened by a mob > (or by one individual) and you are worried that if I stay I would get hurt. My apologies. It seems I was unclear. That suggestion was about you, not about Eyal. > As for Ben having the required knowledge, I do not know. Assuming that he > does have it (which is not limited to having the coding skills, FWIW), I do > have my doubts regarding the required experienced. Compatibility with other > spreadsheet tools regarding spreadsheet Functions is not a mere optional; it > is a very important factor, a goal. Even when a Function returns "the wrong" > result, it matters, because after decades of using those functions users > already take advantage of those specific "wrong" results in order to obtain > the actual result they are seeking. I think you may be confused about which bug report you are commenting on, here. This one is not about compatibility for LAMBDA. > In the past I would had suggested to look for a mentor, with knowledge and > experience in Calc's development. Within TDF, or within current associated > organizations, there is no longer such developer available. Indeed, I have had a hard time getting answers from developers more experienced with Calc than I, which is why I've filed bug reports such as this. > As for this tdf 172799, there is no one-to-one correlation between error > codes and specific Functions. The error code being displayed is not always > the actual problem with the specific formula. Someone with enough knowledge > and experience building workbooks with complex formulas would know that. Where it is not impossible to determine what the actual error is, this is a bug and needs to be fixed. There is a reason that Calc doesn't just claim "Your formula has an error; fix it!", and it's not for the sake of compatibility. That sort of UX is absolutely terrible, and users shouldn't stand for it. Claiming that error codes should have no more meaning than that suggests to me that you do not have any experience teaching new spreadsheet users (which I do have, by the way), nor debugging complex formulas (which I also have). Either of those tasks requires that errors be reported specifically and accurately, and with as much relevant information as possible. -- You are receiving this mail because: You are the assignee for the bug.
