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

            Bug ID: 98308
           Summary: #VALUE if I use only one $ character to fix cell.
           Product: LibreOffice
           Version: 5.1.0.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Hello,
#VALUE appear if I use only one $ character to fix cell. For example
=SUM(C$2:C63) doesn't work on 5.1.0.3 release. I tried and checked help from
forums, solutions and setting options as much as I can but nothing helped. I
try to report this because its a new release and I have never seen this before.
I must have to install the previously 5.0.5 version and that works perfectly.
Only a similar problem was when #VALUE appeared for an empty cell and I mean it
 that was empty. When I pressed delete on this empty cell then #VALUE
disappeared.
It's weird and really frustrating situations when I need my "values" urgently.
Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to