Hi Oliver, On Saturday, 2008-10-11 18:35:24 +0200, Oliver Brinzing wrote:
> =CELL("Width";A1) reports the cell width, for example 12
> now a user changes column width - but the formula still reports: 12
> pressing (F9) does not help ... only a save & reload cycle will display
> the new column witdh ...
Or including a "recalc always" function in the formula such as RAND(),
for example, =0*RAND()+CELL("width";A1)
> imho a column size listener is missing here ...
CELL should be a "recalc always" function too.
IMHO we should not had offered the CELL() function in UI at all ...
It is only there for Excel compatibility, which probably has it for
compatibility with console based applications, such as Multiplan or
Lotus. Especially the column "width" feature doesn't make sense because
according to the Excel help
http://office.microsoft.com/en-us/excel/HP100623921033.aspx it is
supposed to return
| Column width of the cell, rounded off to an integer. Each unit of column
| width is equal to the width of one character in the default font size.
So as long as your default font (what's that anyway?) is not monospaced
the result is even meaningless.
Eike
--
PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
pgps3l0whRYwj.pgp
Description: PGP signature
