[nSLUG] How to sort data within a cell in Calc?

Joel Maxuel j.maxuel at gmail.com
Tue Jul 29 16:41:34 ADT 2014


Sorry for the late post, but the discussion only verified what you are
trying to do.

What you need is some Basic code (or the OpenOffice/LibreOffice equivalent
of VBA) to be able to sort the contents of an individual cell.

Unfortunately I cannot think of any code that will easily do this (VBA or
Basic).  One could probably be whipped up, as you would create an array
that would take the values separated by the comma, sort, and then reinsert
(best you can get is probably in a different cell as it would be a formula,
and the came cell would only cause a circular reference) separated by that
comma.

I've played with VBA before, but unfortunately only looked at Basic.  So
really I don't know where to start.
​
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nslug.ns.ca/pipermail/nslug/attachments/20140729/e0b8a02b/attachment.html>


More information about the nSLUG mailing list