Eric Abrahamsen writes: > Michael Brand writes: > >> Hi Eric >> >> On Wed, Dec 17, 2014 at 2:09 AM, Eric Abrahamsen >> wrote: >>> Lastly, is there a way to both use output formatting, and retain the >>> unit name (if desired)? Right now I get this: >>> >>> | km | units | conversion | >>> |-------+-------+------------| >>> | 2.5km | ft | 8202.10 | >>> #+TBLFM: $3=uconvert($1, $2); %.2f >>> >>> Ie, the "ft" falls off the results when I add the "%.2f". Is it possible >>> to retain that and have formatting? >> >> Yes, see >> "org-spreadsheet: formatting chops off units" >> http://thread.gmane.org/gmane.emacs.orgmode/59928 > > I'm certainly late to this party! My only excuse is that it's far from > obvious, given the current manual, that all this is available (even > after your documentation patch in the referenced thread). > > Just to note, the second of the two formatting solutions you mentioned > (manually adding the units as a string) seems to no longer work. The > first does, however. > > I'll work up a slightly longer documentation patch in the next couple of > days -- I really think people should be alerted to what's possible with > units. The "uconvert" defmath could even just be an example in the > manual, rather than code that ships with Org. Here's the doc patch, hope all is in order. Eric