Are there cell standing 'sort' and 'unique' functions?

[ArnimJenett]

Hi Audrey, we are planning to move a google-spreadsheet-project into ethercalc. In this project we are using the google-functions=proper(...), =sort(...) and =unique(...) a lot for generating clean lists for the data validation ( which corresponds with ethercalc's =select() ) of the input fields. proper we found in ethercalc, but not the other two. Are there also equivalent functions for sort and unique already implemented in ethercalc, which we just didn't find or do we need to build these? If so, could you guide us, where to insert these into the code, please? Best, aRnim

Addendum: An example for the use of these functions (in google spreadsheets) can be accessed here: https://docs.google.com/spreadsheets/d/1d2uUxMaeg6z0j7vq5QRTIIxlWtsIGG0zEmVy2h3lSxA/edit#gid=0

• where B2 is the input cell (free-form or select) and
• column E constitutes the dynamically generated list for the select in B2.
• The button on B4 normally toggles the copy to the end of column C. However, in the publicly shared version the underlying script is prevented from running (maybe a good idea anyhow). Therefore, for now and for testing content can be added manually to the end of C.

[eddyparkinson]

All fomulas

All the formulas are in this file: https://github.com/marcelklehr/socialcalc/blob/master/js/formula1.js#L2570

To list all formulas - use the browser javascript console and type SocialCalc.Formula.FunctionList But, I think all of them are in the help. (Fx button on ethercalc)

I don't think sort or unique exist as formulas. But sort is on the menu.

add a formula

To add a formula, from memory, you need to add 3 things:

• add to SocialCalc.Formula.FunctionList https://github.com/marcelklehr/socialcalc/blob/master/js/formula1.js#L2570
• create the function: https://github.com/marcelklehr/socialcalc/blob/master/js/formula1.js#L2359
• help text: https://github.com/marcelklehr/socialcalc/blob/master/js/socialcalcconstants.js#L653