Results 1 to 5 of 5

Thread: Formating an Excelcell with LibXL without writing in it

Threaded 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.

Posting Permissions

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