I think the Google Spreadsheets forum is the best place for you to ask these questions, rather than here (where we focus on charting and data visualization): http://www.google.com/support/forum/p/Google+Docs/label?lid=4c7c98a970adf580&hl=en
Regarding vertical merge, I don't think it's supported: http://www.google.com/support/forum/p/Google+Docs/thread?tid=242b56bb7a80890a&hl=en Regarding the unit convert. You could use an Apps Script<http://code.google.com/googleapps/appsscript/>(little bits of code that extend Spreadsheet functionality). There used to be a sample one<https://docs.google.com/previewtemplate?id=0AjbZnjlHMPF0dHpEczJZbTVjZnkzYjBzUWEyTTBQdnc&mode=public>doing what you need, but it seems broken nowadays (it relied on scraping the results of Google search box converter<http://www.google.co.uk/help/features.html> and I guess it started failing because of the various changes the Google homepage went through in the past months ). Maybe you can copy / fix it. If so, you'll end up with an additional function you can use in your spreadsheet, like C1=convert(A1, 'celsius', 'Fahrenheit') . -- R. On 28 September 2011 02:11, Amelia <[email protected]> wrote: > Good morning, > > I'm using Google spreadsheet very frequently and I would really love > it if you can help making the following feasible: > > 1. Merging 2 or more vertical cells. Currently, google only allows > merging of 2 or more horizontal cells > > 2. Gadgets: it would also be great if you can help to develop a gadget > like unit converter. Starting can be some basic unit like temp > (between Celsius and Fahrenheit) , pressure (bar, pascal, psi, etc,) , > velocity (m/s, m/h, etc.) , flow rate (USGPM, GPD, m/h, l/min, etc), > etc. > > Thank you and really looking forward to those ideas come true. > > Cheers, > Amelia > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
