[Libreoffice-bugs] [Bug 51917] New: CONCATENATE of RAND generated characters recalculating at each cell entry

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 51917
           Summary: CONCATENATE of RAND generated characters recalculating
                    at each cell entry
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.0 release
          Platform: Other
        OS/Version: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: bountonw at gmail.com


Created attachment 64025
  --> https://bugs.freedesktop.org/attachment.cgi?id=64025
Example of concatenating issue

While concatenating cells with randomly generated characters 

=CHAR(65+RAND()*26)

all cells with random characters recalculate simultaneously at each new event.
It is kind of pretty, but does remove the functionality of this function :)

Some of the events that cause the regeneration of all random characters in the
sheet are as follows:

Adding text to a cell.
Deleting text from a cell.
Deleting a column.
Pasting.

I have attached the example file.

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