[Libreoffice-bugs] [Bug 52416] New: COUNTIF() result is not recalculated when cells are updated

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52416

             Bug #: 52416
           Summary: COUNTIF() result is not recalculated when cells are
                    updated
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.3 release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: freedesktop at multiwebinc.com


Created attachment 64569
  --> https://bugs.freedesktop.org/attachment.cgi?id=64569
file that produces this error

Note: regular expressions in formulas needs to be enabled first.

In one cell I have the text "test". In another I entered =COUNTIF(A1 , "test").
The result should be 1. Then I changed the text in the first cell to something
else. The result should be changed to 0 for the regular expression, however it
isn't.

The odd thing is that this is working correctly for a new document, but not
another one I have open, so I am not sure what exactly reproduces this. However
I have attached the document with the error to this bug report as well as a
screenshot in case it shows up differently in other versions.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.