Results 1 to 5 of 5

Thread: Formating an Excelcell with LibXL without writing in it

  1. #1
    Join Date
    Feb 2009
    Posts
    1,039

    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
    10,869

    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
    1,039

    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
    Stuart, FL
    Posts
    5,322

    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

    IT Director at Balloons Everywhere

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

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

  5. #5
    Join Date
    Feb 2009
    Location
    St Louis MO
    Posts
    201

    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
  •