Skip to main content

Timeline for Reorder columns in Array

Current License: CC BY-SA 3.0

15 events
when toggle format what by license comment
Feb 14, 2018 at 18:34 history edited paul bica CC BY-SA 3.0
Added performance tests for different (un-optimized) versions of For loops
Feb 14, 2018 at 15:07 comment added paul bica fc = fc - 1 will not make a big difference, but the idea is to move all unnecessary operations outside the loop - repetition will amplify all extra operations. I’ll measure it and post the results by the end of today
Feb 14, 2018 at 14:12 comment added QHarr What was this line for fc = fc - 1 'Optimized for the loop please?
Feb 14, 2018 at 14:08 comment added QHarr Very quick solution. Much obliged.
Feb 14, 2018 at 10:19 vote accept QHarr
Feb 12, 2018 at 22:44 comment added QHarr @PaulBica I will been running these tomorrow and feedback. Many thanks for your time.
Feb 12, 2018 at 22:42 comment added Raystafarian @ThomasInzina this type of question is about the only good argument I have for Option Base 1, which I still can't bring myself to use.
Feb 12, 2018 at 17:45 history edited paul bica CC BY-SA 3.0
Removed comment about the minor fix
Feb 12, 2018 at 15:03 history edited paul bica CC BY-SA 3.0
Added 2 comments
Feb 12, 2018 at 14:14 history edited paul bica CC BY-SA 3.0
Added 2 images: test results with OP code compared to test results with code in the answer
Feb 12, 2018 at 8:59 comment added user109261 The OP's code works because he is using two complete arrays. By swapping columns individually, you are not putting the data in the right order. When i = 0 Column 9 is swapped with Column 1. Then when i = 5 Column 1 (which is the data from Column 9) is swapped with Column 6.
Feb 12, 2018 at 3:28 history edited Jamal CC BY-SA 3.0
deleted 14 characters in body
Feb 12, 2018 at 3:24 history edited paul bica CC BY-SA 3.0
Determine first row and column dynamically
Feb 10, 2018 at 20:33 history edited paul bica CC BY-SA 3.0
Added "white" spaces, and renamed var "fr" to "frx"
Feb 10, 2018 at 20:26 history answered paul bica CC BY-SA 3.0