Dear Team:
for some Chart Reports we import data to spreadsheets, but Numeric Figures are not Recognized and unable to have SUM and also can not Filter them.
this is a function of your spreadsheet program. change the format to numbers for the column.
then you will need to explain in detail the exact reports you are having trouble with.
also, post screenshots to understand better.
like i already said this is an issue with your spreadsheet program.
i checked the same report and i do not find any such issues in my MS Excel program.
make sure your system uses the same number format you have set in Manager.
also, the Sales Invoice Totals by Customer report already displays the total at the bottom in Manager. so why are you copying it to a spreadsheet to calculate the total?
The numbers are being imported into the spreadsheet as text not numbers.
If you try and do local calculation or format the cells as a number, the numbers will probably show with a proceeding quote mark indicating they are stored as text not as a number.
Note also the numbers are not aligning right.
When the quote mark is showing you can delete it to convert the cell to a number.
Or more efficiently you can use a spreadsheet function to convert the text to a number. See Copy and paste - #4 by Patch
To get more precise help, you should say
- What version of Manager you are using
- What language you are using
- What number format you are using in Manager
- Operating systems you are using
- What your region number format is
- What spreadsheet program you are using
- What number format is the default in the spreadsheet program
I am using Manager 21.9.23 Desktop
Windows 10
When I use the Copy to Clipboard and Paste into Excel I get
So it works perfectly for me. Must be something in you spreadsheet setup ?
because that is what your excel is configured to show. right click the status bar and enable Sum to display totals of selected cells.
as another user also has confirmed they are not experiencing any issues, it is now clear that the issue is not with Manager but with how you have configured your OS and spreadsheet program. google various resources available on the internet related to your OS and spreadsheet program for help on configuring them.
This thread may also be of assistance, especially the posts about system regional settings.
1 Like