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: [email protected]
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
