#7 CSV export

Released in 1.4x
closed-fixed
General (8)
5
2005-01-11
2004-12-16
No

Problem:
Excel ignores leading zeros for text columns

Solution:
c1,c2,c3
="paul",="00235",="red"
="jim",="00187",="yellow"
="sue",="00133",="green"

Discussion

  • Ken Clubok

    Ken Clubok - 2004-12-16

    Logged In: YES
    user_id=1171380

    This should be an option, in case users want to use the CSV
    output in other applications, such as Access.

     
  • Aleksey Kochetov

    Logged In: YES
    user_id=423922

    Ok, I'll add to it to setting and GUI

     
  • Ken Clubok

    Ken Clubok - 2004-12-16

    Logged In: YES
    user_id=1171380

    Unless you prefer to make such changes yourself, I'd like to
    try doing that part, too. I think I know what needs to be
    done.

    One more complication: this formatting will need to be
    sensitive to the column type. Otherwise, number fields will
    not behave properly in Excel.

     
  • Aleksey Kochetov

    Logged In: YES
    user_id=423922

    you can do it. Please check all steps from settings reading
    to gui.
    There is a method to check data-grid column type - probaly
    IsNumber.

     
  • Ken Clubok

    Ken Clubok - 2004-12-19

    Logged In: YES
    user_id=1171380

    Just committed the fix for this one.

     
  • Ken Clubok

    Ken Clubok - 2004-12-19
    • status: open --> open-fixed
     
  • Ken Clubok

    Ken Clubok - 2004-12-22

    Logged In: YES
    user_id=1171380

    Updated logic so that LOBs are treated as strings.

     
  • Ken Clubok

    Ken Clubok - 2005-01-03

    Logged In: YES
    user_id=1171380

    Updated logic so that empty prefix character doesn't give
    garbled output.

    Also fixed string recognition logic - broken by merge of 58X
    branch and 59X branch.

     
  • Aleksey Kochetov

    • status: open-fixed --> closed-fixed
     
  • Aleksey Kochetov

    Logged In: YES
    user_id=423922

    fixed in 141b62

     
  • Drzewiecki T.

    Drzewiecki T. - 2005-01-11
    • milestone: 455736 --> Released in 1.4x
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks