GUIListViewEx Integration

[Melba23]

error471,

I think I have fixed the redrawing problem - try this version:

<snip>

That works nicely for me whether dragging in the same or between ListViews.

M23

Edited January 21, 2016 by Melba23
Beta code removed

[mLipok]

I confirm: Repaint is fixed.

Just as note :
ADD button fires such error:
 

Quote

"C:\Users\user\Downloads\GUIListViewEx_Colour_Max.au3" (2035) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:
If StringInStr(($aGLVEx_Data[0][13])[$iItem + 1][$iSubItem], ";") Then
If StringInStr(($aGLVEx_Data[0][13]^ ERROR
 

 

Edited January 20, 2016 by mLipok

[Melba23]

mLipok,

Very interesting, it errors in the LH ListView, but not in the RH one - Sherlock Holmes mode now activated!

M23

Edit: Found it - I was not forcing the correct colour array to be reloaded before redrawing.  Files re-uploaded in post #21.

Edited January 20, 2016 by Melba23

[mLipok]

UP DOWN not allways correctly repaint Colors.

Edited January 20, 2016 by mLipok
typo

[Melba23]

mLipok,

That might well be the same problem - standby.....

M23

[Melba23]

mLipok,

It was the same problem - re-uploaded the files in #21 for a second time.

M23

[mLipok]

I confirm as fixed.
 

[error471]

Melba23:

I had no chance to check the neweset files, since I am at work. I can't wait to test your script this evening.

[error471]

@Melba23:

No errors. Works awesome.

Do you intend a save to file/load to file function? I think it would be complete then.

[Melba23]

error471,

Glad you like it - I am now polishing it before release.

As to the "save to/load from file" functions, the UDF returns content/checkbox/colour arrays from existing ListViews and also allows you to load these arrays into new ones. AutoIt provides excellent _FileWriteFromArray/_FileReadToArray functions - so write your own wrappers if you really feel the need, I am certainly not going to!

M23

[error471]

Thanks for you efforts. You helped me a lot.

I have a question concerning the  _FileWriteFromArray/_FileReadToArray functions. If I use _FileWriteFromArray I will have two files: content and colours. What I do not know at the moment is, how to load the colours, after loading the content. Is _GUIListViewEx_ReadToArray the right function? 

[Melba23]

error471,

Looking at the example script I posted:

; Create colour array - must be 0-based - RGB hex "text;back"
Global $aColArray_1[5][6] = [[";", ";0xFF0000", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";0x000000"]]
; Load colour array
_GUIListViewEx_LoadColour($iLVIndex_1, $aColArray_1)

What function do you think loads the colours into the ListView?

M23

[kaisies]

Just to add something to the pile, I found this UDF for tables / colors display to be exceptionally simple to use (moreso than a listview)... Could be something you might want to look at, or maybe not

 

 

Table.au3

Edited January 20, 2016 by kaisies

[error471]

2 hours ago, Melba23 said:

error471,

Looking at the example script I posted:

; Create colour array - must be 0-based - RGB hex "text;back"
Global $aColArray_1[5][6] = [[";", ";0xFF0000", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";"], _
               [";", ";", ";", ";", ";", ";0x000000"]]
; Load colour array
_GUIListViewEx_LoadColour($iLVIndex_1, $aColArray_1)

What function do you think loads the colours into the ListView?

M23

I understand now. I think it will be difficult with my skills, but I think I can handle it.

 

@Melba23, I see big potential in GUIListViewEx.au3 with the colour integration. With the save and load to file function It could become a serious alternative to Excel, since Excel can't handle autosum according to colours without VBA. I am not sure if you are aware of that...

[Melba23]

error471,

Quote

With the save and load to file function It could become a serious alternative to Excel

You are joking, I trust - there is absolutely no comparison between the two.

Quote

 I think it will be difficult with my skills

If you get and save the colour array once you have set the required colours, you just read it back and reload it - what is hard about that?

I am away for the next few days, if you have any problems with the UDF over this period then just post them here and I will try to resolve with them when I return.

M23

[error471]

2 minutes ago, Melba23 said:

You are joking, I trust - there is absolutely no comparison between the two.

No, I am serious. I need only a few functions for my purpose. If I can script the saving/loading - maybe autosaving and backuping, I want to create a printable list, depending on the colour (=status) of the data. 

 

8 minutes ago, Melba23 said:

I am away for the next few days, if you have any problems with the UDF over this period then just post them here and I will try to resolve with them when I return.

Thank you.

[Melba23]

error471,

I will have a think about how you might do that over the weekend - see what you can come up with in the meantime.

Here is the latest version to play with while I am away:

<snip>

M23

Edited January 24, 2016 by Melba23
Removed Beta code

[mLipok]

What exactly button "Colour 1-3,3" should do ?

 

[error471]

@Melba23:

I am integrating your script into my bakery project. I managed to save&load the content from&to a file, which was pretty easy, but the colour loading and saving does not to work with the standard _FileWriteFromArray and _FileReadToArray Functions. I haven't found a solution yet.

 

Edited January 24, 2016 by error471

[error471]

Here is the the load problem:

 

Global $aColArray_1[20][20]
_FileReadToArray("C:\Users\H23\OneDrive\Scripts\0.2\database\2016_24_01_16_50_09_colors.db",$aColArray_1, 0, "|")
_ArrayDisplay($aColArray_1, "Colour", Default, 8) ;shows correctly
_GUIListViewEx_LoadColour($iLVIndex_1, $aColArray_1) ;<------does not work!

Array is displayed as it should. But _GUIListViewEx_LoadColour Function does not work.

 

Here is the save problem:

Case $cColour
    $aRet = _GUIListViewEx_ReturnArray(_GUIListViewEx_GetActive(), 2)
    _ArrayDisplay($aRet, "Colour", Default, 8) ;show correctly
    _FileWriteFromArray(@ScriptDir & "\database\" & @YEAR &"_" & @MDAY &"_" & @MON & "_" & @HOUR &"_"  & @MIN &"_"  & @SEC & "_colors" & ".db", $aRet, 1) ;does not save properly

Again, array is displayed as it should. But _FileWriteFromArray only saves ;|;|;|;|;|;|;|;|;| without colour codes.

Edited January 24, 2016 by error471