Issue #4 new

Addin not picking up format problems

Aaron McGlinchy avatarAaron McGlinchy created an issue

Hi, I have been testing the addin and the webapp on the same file which I know has some issues. The strange thing is that the webapp picks up 5 issues, but the addin only picks up 4 issues. The issue the addin is missing is mixed data types, so if i have a column of numbers, and say if there is missing data I enter X to signify that. The webapp detects it, the addin does not. If I delete the X and leave the cell blank the addin then picks up blank cells.

After I deleted the X, the addin also started picking up special characters, even though their were none in the spreadsheet and on first check it had not detected any, but once the X was deleted leaving a blank cell it reported both blank cell and special character. Inserting a valid number in the blank removes the missing, but special character remained.

I then worked out the special character it was reporting was the decimal point in my numeric data - obviously it should not report a decimal place as a problem.


Comments (1)

  1. Aaron McGlinchy
    • edited description

    UPDATE - have noticed that even though the webapp is picking up 'mixed data types', it too is actually in error - its picking up cells that are correct (not mixed data), but missing other cells that are mixed data. I can send you the spreadsheet if you wish to check yourselves.

  2. Log in to comment
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.