Given SheetOne that looks like this:
A B C
1 05/01/1950 This is the first comment line =char(10)
2 10/15/2005 This is the 2nd comment line =char(10)
And on SheetTwo
A
1 =concatenate( query( SheetOne!$A1:$C5, "select A, B, C format A
'yyyy-mm-dd'",0) )
What displays on SheetTwo in cell A1 is
18384This is the 1st comment line.
38671This is the 2nd comment line.
Apparently the query formatting is applied after the results are entered in
cells, and not before the results are passed to the concatenate() function.
What I would like is formatting applied before the results are returned. A
scalar formatting function would be nice, and so would adding the char()
scalar function, so the results returned to concatenate() are already
formatted. Also, allowing a literal to appear more than once in the select
field list would make it more like SQL and much more flexible.
Then I could make the formula for SheetTwo A1 something like:
A
1 =concatenate( query( SheetOne!$A1:$C5, "select format(A,'yyyy-mm-dd'), '
', B, char(10)'",0) )
And have the display on SheetTwo A1 look like this
1950-05-01 This is the 1st comment line.
2005-10-15 This is the 2nd comment line.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-visualization-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/794290ca-7b03-4d81-8498-e1a77a05bc59n%40googlegroups.com.
