Results 1 to 5 of 5

Thread: Formating an Excelcell with LibXL without writing in it

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Posts
    717

    Default Formating an Excelcell with LibXL without writing in it

    Has anyone found out how to formate an Excel cell without writing a value in it?

    I want to create a column where suppliers shall enter their prices. The column shall be empty from the beginning, but the cells should be currency formatted so two decimals show up when sombody enter a price.

    Send WriteNum of hoSheet iRow iCol '' hoAmountFormat - gives zeros in the cells.

    Set DefaultColumnFormat of hoLagerSheet iRow iCol to hoMoneyFormat - doesn't seem to have any exffect

    There ought at least to be a way to delete the value in a cell. When working normally with Excel, you just press Delete.

    Bengt
    Last edited by Bengt; 23-Apr-2019 at 09:20 AM.

  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    8,556

    Default Re: Formating an Excelcell with LibXL without writing in it

    Bengt,

    Please create a HDE ticket and possibly with code that we can run to see the problem, discuss with the developer.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  3. #3
    Join Date
    Feb 2009
    Posts
    717

    Default Re: Formating an Excelcell with LibXL without writing in it

    It is the szLibXL implementation I use so I hoped Mike or somebody who works with his classes would know.

  4. #4
    Join Date
    Feb 2009
    Location
    South Florida
    Posts
    3,406

    Default Re: Formating an Excelcell with LibXL without writing in it

    Bengt

    have you tried to contact XLware via email or their forum

    and just an idea
    have you tried writing the amount with format and then overwrite the value with an empty string? maybe it will keep the format
    Michael Salzlechner
    StarZen Technologies, Inc
    http.://www.starzen.com

    Development Blog
    http://www.salzlechner.com/dev

    DataFlex Package Manager (aka Nuget for DataFlex)
    http://windowsdeveloper.com/dfPackage

  5. #5

    Default Re: Formating an Excelcell with LibXL without writing in it

    haven't tried it, but there is a WriteBlank method (ComWriteBlank) - check out the LibXL doc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •