https://bugs.documentfoundation.org/show_bug.cgi?id=95808
Bug ID: 95808 Summary: Feature enhancement: Formula sequence check - warn on interruption Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: reg...@versanet.de Created attachment 120528 --> https://bugs.documentfoundation.org/attachment.cgi?id=120528&action=edit sample 4 interrupted forrmula sequence I'm working in an enterprise with about 600 users. Calc is heavily used with row or column based formulas like: A 1 =a1*1,19 2 =a2*1,19 3 =a3*1,19 4 =a4*1,19 5 =a5*1,19 ... 1024 =a1024*1,19 1025 =a1025*1,19 ... and so on I often see formula mistakes by users, who accidently interrupt those formula sequences: A 1 =a1*1,19 2 =a2*1,19 3 =a3*1,19 4 =a3*1,19 ooops, a3 reference comes accidently twice! 5 =a4*1,19 ... 1024 =a1023*1,19 1025 =a1024*1,19 ... and so on Currently, there is no warning, tool tip or highligting for formula sequence interruptions. A warning - eg. by a little danger sign with tool tip help next to the affected cell - would be a nice to have feature for future releases. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs