|
| Spreadsheet column width by programming |
| Iniciado por Frankdarwin, 20,abr. 2016 04:47 - 3 respuestas |
| |
| | | |
|
| |
Miembro registrado
17 mensajes |
|
| Publicado el 20,abril 2016 - 04:47 |
Hi,
when I create a new spreadsheet, all colums have the same width but I want to use smaller columns.
How can I change the width of all colums at a once ny editor or by programming?
--
Thank's
Frank |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
102 mensajes |
|
| Publicado el 22,abril 2016 - 15:49 |
Frank,
not exactly what you are looking for, but you could load an excel file with SpreadSheetLoad() where you set the width of your columns to the size you want.
I haven't seen any function in WinDev for manipulating the column width in a SpreadSheet control. Even worse, depending on the data you put into your cells the column width will change (get wider).
HTH
Sebastian
--
http://arnoldconsult.de
WinDev 20 with Oracle, WinDevMobile Android Apps and Motorola Windows CE Mobile Barcode Scanners, Python 3 with Oracle and MySQL |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
88 mensajes |
|
| Publicado el 02,mayo 2020 - 12:08 |
The problem, Sebastian, is that (still today with WD 25!!!) the columns change "automatically" their width if you insert programatically a label longer than the width
The spreadsheet control is a VERY interesting object, but for great experienced Excel users it has very important limitations
PC Soft waste the time adding "cell notes" when there are MORE important details to improve |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
102 mensajes |
|
| Publicado el 02,mayo 2020 - 18:22 |
VEGEboss, I absulutely second this. It's a pitty and very sad, so much potential for the spreadsheet control.
I'm still missing a search function for content of cells. Is this available in WD25?
--
WD23 with Oracle, WDM23 Apps for Android, iOS and Windows CE.
Python 3 with Oracle and MySQL. PHP with MySQL and JSON. |
| |
| |
| | | |
|
| | | | |
| | |
|