I have Following Query for EasyXLS for VB 6

Query 1

Dim varValue As Double
varValue = 0.487281089615732

xlsFirstTable.easy_getCell(2, 2).setValue varValue
xlsFirstTable.easy_getCell(2, 2).setFormat ("0.00%")
xlsFirstTable.easy_getCell(2, 2).setDataType ("numeric")

This Shows the Value as "48.73%" but inside the Cell it Shows 48.7281089615732%

How can I shoes inside the Cell as "48.73%"

Query 2

xlsFirstTable.easy_getCell(2, 2).setValue varValue
xlsFirstTable.easy_getCell(2, 2).setFormat ("#0.00")
xlsFirstTable.easy_getCell(2, 2).setDataType ("numeric")

Current Output
varValue = 5.01. This Gives the Output 5.01
varValue = 5.1 This Gives the Output 5.10
varValue = 5 This Gives the Output 5.00
varValue = 0 This Gives the Output 0.00

Output Required
varValue = 5.01. Output 5.01
varValue = 5.1 Output 5.1
varValue = 5 Output 5
varValue = 0 Output 0

I have tried various combination like "#.##" or "#.#0" etc... but it is not working

How this can be done ?


Query 3

I have Cell Range as B2 to E6
I want to give the Border as Outline of Entire Range

How can I give the same in the Range Cell Option ?


Query 4

How can I give AutoFit Entire Column ?

I want to have a Width of 8.43 for Column 1 and Rest all I want to AutoFit.


Thanking You

Bhavesh

Query 1
This is the normal behavior in MS Excel. You may try to create a similar cell in MS Excel interface (without using EasyXLS) and you will get the same behavior.

Query 2
This is also the normal result that you get for "#0.00" number format. If you will not set any number format (default "General"), you will see the numbers that you want.

Query 3
You need to define the border for the cells that defines the range:



and similar for the top right cell, left cells, bottom left cell, bottom cells, bottom right cell and right cells.
You may find here the available borders:
https://www.easyxls.com/manual/API_Documentation/EasyXLS/Constants/Border.html

Query 4
Autofit is the default option. You can find more details about autofit and custom column width at the following link:
https://www.easyxls.com/manual/basics/excel-column-width-row-height.html