Re: [libreoffice-users] Re: PaletteMaker v.1.0 is out

Hi!

Le 12/09/2019 à 17:38, V Stuart Foote a écrit :
> Hmm, you may have made a wrong turn here, likely my fault for not responding
> sooner--sorry!

no problem. I was busy elsewhere myself :)

> I just  opened the Macro in palettemaker_v1_1_0_0_en-2.ods and noticed
> you're attempting a conversion of RGB2HSL ('L' luminance), we don't use
> those values in the LibreOffice "Color Picker".
>
>   We do use HSL values, but  just in a few places when we are adjusting
> colors for the UI, or in image editing.
>
> For palette work the values are HSV -- 'V' value  (also known as HSB -- 'B'
> brightness )  a much simpler algorithm to implement which LibO does in
> bcolortools [1], as used by the "Color Picker" to during color space
> conversions in the GUI [2].

Mmmm. Thanks for the insight. I'll have another look at this HSV thing.

> The other thing I noticed--after enabling macros, if I import a large color
> palette for editing the sheet holding the palette gives the count of colors
> in the palette then truncates the sheet at 1100 colors.  Some folks like
> really large palettes--is there a hard limit preventing the sheet from going
> larger?

No, this is not a hard limit, just a subjective one. It is mentioned in 
the Manual sheet, last paragraph of the What is PaletteMaker section.

I guessed this value of 1100 would fit most users need. Seems it wouldn't :(

Now, changing it is just the matter of going to the code, 
Standard.Spreadsheet module, line 64. Change the ROW_COUNT_MAX constant 
value to whatever you see fit.
Then adjust the four named ranges accordingly: colors, definitions, 
names and samples.
Finally, expand accordingly the colored range at sheet Palette.


Best,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy