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: [email protected]
ReportedBy: [email protected]
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
