aiter Posted May 21, 2018 Share Posted May 21, 2018 (edited) I noticed that _DebugArrayDisplay has a bug when copying data and headings I copied the The column alignment is out - copying just the data seems to have no issues Edited May 21, 2018 by aiter add Link to comment Share on other sites More sharing options...
aiter Posted May 21, 2018 Author Share Posted May 21, 2018 (edited) I figured out what the bug is:- The row heading (first column) does not a tab delimiter so it offsets everything off by 1 The data does have the tab delimter If I make argument 4 (I had the value as 64 to omit row heading) zero, the bug is gone. Edited May 21, 2018 by aiter additional Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted May 21, 2018 Moderators Share Posted May 21, 2018 aiter, Your explanation is as clear as mud. Please provide 2 small reproducer scripts, one of which shows the problem and the other which shows the solution you found. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
aiter Posted May 22, 2018 Author Share Posted May 22, 2018 (edited) Apologies Melba for my confused explanation. Here is my test script #include <Debug.au3> dim $aArr[5][100] for $x = 0 to 4 for $y = 0 to 99 $aArr[$x][$y] = $x & $y Next next $head = "" for $x = 1 to 99 $head &= "h" & $x & chr(9) next $head &= "h100" Opt("GUIDataSeparatorChar", chr(9)) _DebugArrayDisplay($aArr,"test",Default,64,Default,$head,Default) ; no row heading displayed - Mark 1 _DebugArrayDisplay($aArr,"test",Default,0,Default,$head,Default) ; row heading displayed - Mark 2 When the array display pops up I click 'Copy data & hdr row" and paste it into excel. From the paste from the first array popup, row is displayed on the excel spread sheet - it should not be. It displays like this Row|h1 Row 0 Row 1 Row 2 Row 3 Row 4 It should not be showing 'Row' in the first column, but match what is shown in the popup. PS - Big thumbs up for array allowing sorting by clicking on the column header Edited May 22, 2018 by aiter Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted May 22, 2018 Moderators Share Posted May 22, 2018 (edited) aiter, I now see what you mean and I am investigating. M23 Edit: Got it - the "|" in the header line is hardcoded when we should be using the $sCurr_Separator variable. It will be fixed in the next release. And you get the header/row data because you select the "Copy Data & Hdr/Row" button - so the header and row information is added automatically regardless of whether it is displayed in the dialog. If all you want is the data, then use the "Copy Data Only" button. If you want the data and the header with no row numbers than you will have to write a custom function and use the "Run User Func" button - we cannot cater for every possibility! Edit 2: All done. If you want to fix it in your current installation then amend line #517 in ArrayDisplayInternals.au3 to read: $sItem = "Row" & $sCurr_Separator & $sItem Edited May 22, 2018 by Melba23 mLipok and aiter 2 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now