Hello Michael,
The BOM and spreadsheet view show a few different things just because they are meant for different ends.
The BOM will show information of components relevant to the selection process while the spreadsheet view will give you data relevant to design and simulation. The type is not relevant in any way to simulation, so it is not included in the spreadsheet view.
If you believe it should be included, maybe you can provide some feedback about it here and here. Both channels are monitored by R&D, hence are good ways to transmit your message.
Regards,
Camilo V.
National Instruments