[OpenTRV-dev] google spreadsheet

[Stuart Poulton]

Not quite sure what you’re doing but works fine here.



Stuart

On 6 Sep 2014, at 11:27, Bo Herrmannsen <EMAIL ADDRESS HIDDEN> wrote:

> seems it does not simply split but also adds the delimiter to the result
> 
> 102:47:00.000
> 
> my initial thought is simple rude: WTF.... cant you just do as told.... )(/&%¤#¤
> 
> 
> 2014-09-06 11:54 GMT+02:00 Bo Herrmannsen <EMAIL ADDRESS HIDDEN>:
> So i got the serial output in to a spreadsheet...
> 
> want to split it up right so its more usefull
> 
> raw data: Energy: 102.47 
> 
> 
> formula: =split(A1; ":"; False)
> 
> result: 102.47.00
> 
> have tried to set the format of the result cell to automatic, text, numbers....
> 
> no matter what it added .00 
> 
> what  am i doing wrong?
> 
> -- 
>                  |||||
>                @(~Ô^Ô~)@
> -------------oOo---U---oOo-------------                                                            
> |                                     |
> |  Bo Herrmannsen                     |
> |                                     |
> |                                     |
> | "blessed are the "cracked",         |
> |  for its they who let in the light" |
> |                         Ooo         |
> |_________________ooO____(   )________|
>                  (   )    ) /
>                   \ (    (_/
>                    \_)
> 
> 
> 
> 
> 
> -- 
>                  |||||
>                @(~Ô^Ô~)@
> -------------oOo---U---oOo-------------                                                            
> |                                     |
> |  Bo Herrmannsen                     |
> |                                     |
> |                                     |
> | "blessed are the "cracked",         |
> |  for its they who let in the light" |
> |                         Ooo         |
> |_________________ooO____(   )________|
>                  (   )    ) /
>                   \ (    (_/
>                    \_)
> 
> 
> _______________________________________________
> OpenTRV-dev mailing list
> EMAIL ADDRESS HIDDEN
> http://lists.opentrv.org.uk/listinfo/opentrv-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/789e343a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2014-09-06 at 12.10.05.png
Type: image/png
Size: 27481 bytes
Desc: not available
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/789e343a/attachment-0001.png>