Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #20960

    gordy
    Participant

    In CSV mode it would be nice to be able to specify a text qualifier, say for example double-quote char (“) – so that data like this:
    “column 1”, “column 2”
    “row 1 value 1”, “row 1 value 2”
    etc.
    ..could be displayed without all of the leading and trailing quotes.

    #20961

    Yutaka Emura
    Keymaster

    You can’t specify a text qualifier, it is always double-quotes.
    The new cell toolbar will show you the content of the selected cell without double-quotes.

    Thanks!

    #20963

    gordy
    Participant

    sounds good! being able to copy whole columns without the text qualifier would be very helpful as well

    #20964

    Yutaka Emura
    Keymaster

    Hello,

    I wrote a macro that just that for you:

    iColumn = document.selection.GetActivePointX( eePosCell );
    nLines = document.GetLines();
    if( document.GetLine( nLines ) == "" )  nLines--;
    sText = "";
    for( y = 1; y <= nLines; y++ ) {
    	sText += document.GetCell( y, iColumn, eeCellIncludeNone ) + "\r\n";
    }
    clipboardData.setData("Text", sText );
Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

Share with friends... Tweet about this on TwitterShare on FacebookShare on Google+Email this to someone