Error 1: An error occurs when attempting to import data via a spreadsheet into an existing series in which results have already been imported.
Error 2: The Bromcom Extract fails on supplying Bromcom login details.
Please visit https://www.4matrix.com/news/importfix for details on applying a fix.
This is a known behavior and it's due to the numbers in 4Matrix being stored as a string. This is because we would generally hide or remove pupils from calculations when filters are applied in order to prevent them from registering as a 0 value.
The workaround in MS Excel is to copy the exported sheet and paste into a new sheet or workbook using the Paste Special 'As Values' option. This will then allow you to select the numeric cells and use the small exclamation mark (which appears in the top left cell of the selection) and choose to 'Convert to Number'.
Article ID: 162
Category: Exporting Data
Date added: 13/02/2017 14:06:48
Views : 375
Rating (Votes): (15)