1st of all, you CAN'T sort the output FILE using LR. table can be sorted only in preview (by clicking on column header), and this sorting is intended only for easy filtering results by some condition (e.g. write only those strings to file which has some field equal to/greater than/etc. some value). to sort the OUTPUT FILE (this sorting will be also default sorting of preview table), you need to sort MB VIEW you are using, when you generate the report.
I didn't try to sort directly from the LR table. I set the results into a MusicBee custom tag using the 'Save Field (...) to tag (...) option like this:
2nd. what do you mean by "custom tag"? how do you set it? or do you mean "virtual tag" actually?
I used the 'Save field to tag' option from LR to save the table results into one of these custom tags, I didn't use the Virtual tags. I tried to follow a very old tutorial on Album size sorting and they said there was a bug with virtual tags.
3d. from your 1st screenshot, LR, obviously, treats the <size> field as floating point numbers, and this is correct (because LR treats ANY number as floating point number). the problem is that the actual numbers are too big (all these E+19, E+20 ,... mean *10^19, *10^20 - multiply by 10 to the power of 19, etc.).
i suspect this is happening due to your windows regional settings. open mb menu> edit> prefs> plugins> tag tools> configure, check the measurement units.
if this doesn't solve the problem, create a static playlist containing 1 track, generate a report for it, and post screenshots of mb playlist view (containing <size> field) and of report.
EDIT:
you are using old plugin version. i've recently rewritten LR almost from scratch (and consolidated ALR/LR into one LR command). update plugin:
https://www.mediafire.com/file/h2t08o9562efboi/mb_TagTools_latest.zip/file
I tried to update the plugin but now when I preview the table, I get this error:
MusicBee v3.5.8447.35843Store (Win10.0), 11 Jun 2023 23:31:
System.ArgumentException: An entry with the same key already exists.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.TreeSet`1.AddIfNotPresent(T item)
at System.Collections.Generic.SortedDictionary`2.Add(TKey key, TValue value)
at MusicBeePlugin.LibraryReportsCommand.executePreset(String[] queriedFiles, Boolean interactive, Boolean saveResultsToTags, String functionId)
at MusicBeePlugin.LibraryReportsCommand.previewTrackList()
at MusicBeePlugin.PluginWindowTemplate.serializedOperation()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Maybe I installed it incorrectly, I extracted the zip and used the add plugin to add the .dll file. I'm using the MusicBee from MS Store.