I already posted in the forum, but don't get response there; therefore, I give it another try here:

Something is wrong with images in the wiki. I just replaced the "DefaultPalette.png" of http://wiki.lazarus.freepascal.org/FPSpreadsheet by a new screenshot. But the wiki page still displays the old version. Double-clicking the image brings up page
http://wiki.lazarus.freepascal.org/File:DefaultPalette.png which shows the correct version - hence I am sure that the new version is definitely uploaded. Moreover, this page contains a hyperlink "full resolution" - this shows the wrong image again. Strange...

Is there some caching issue?

Thanks - I see the new image after clearing the browser cache.

FWIW: i just looked and they seem to be fine... how could i tell if i was seeing the old one? in this one i see that we're on row 9 (orangish tint on the row number) and all three show this... the colors and words look the same...

if there is a caching issue, it may be on a system between you and the wiki (ISP using transparent proxy?) or it may be in your browser cache...

Werner Pamler wrote

Something is wrong with images in the wiki.

Glad to see you got it sorted out.

I have another question with that page:

http://wiki.lazarus.freepascal.org/FPSpreadsheet#Colors

I've never used FPSpreadsheet, but the color constants seem wrong to me? Looking at the values I'm assuming the color format is ABGR. All colors have a $00 Alpha channel value, so that would be fully (100%) transparent by default. I have to then assume that FPSpreadsheet doesn't actually take the Alpha channel of a color in consideration - it must simply ignore Alpha values? Otherwise all the colors in the screenshot should be fully transparent (you wouldn't see any defined colors). Surely the correct color definition (to match the screenshot) should mean the default Alpha value must be $FF (fully opaque).

Regards,
- Graeme -

In fact, fpspreadsheet does not take transparency into account, like LibreOffice Calc or Excel xls. Excel xlsx has a $FF in the A byte, though, but I've never seen where they take advantage of the alpha channel.

In fpspreadsheet, the A byte is zero by default in order to be in agreement with the colors as defined by the graphics unit: clRed = TColor($0000FF); scRed = $000000FF. I refined these colors in order to keep the main spreadsheet functionality independent of the LCL.

There are a few "colors" which set bits in A to indicate "not defined" or "no color"; and there may be more to refer to an index in color themes as Excel does (but this is future which maybe will never come).