# Data is neither text nor number **URL:** \ **Category:** Uncategorized\ **Created:** [August 30, 2021, 12:34pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769 "2021-08-30T12:34:59Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 12:34pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/1 "2021-08-30T12:34:59Z")
In the latest version 2.18.61, to see the SUM of total quantity and other data we paste the data in Libreoffice Calc. When We copy the data to spreadsheet, sum function is unable to perform the function. The data in All the TABS is nether NUMBER NOR TEXT. We have tried to convert it no number and its not happening. Even Formatting is not working… ![Screenshot from 2021-08-30 18-04-27](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/a/5a22b31d4135b50f04d681cdac46ae2941516c02.png) ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [August 30, 2021, 12:44pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/2 "2021-08-30T12:44:50Z")
More info is needed: 1. How did you copy the data? Did you select it manually or used Copy to clipboard button? 2. Did you make any manual changes after pasting in spreadsheet, like replacing the currency symbol? ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [August 30, 2021, 12:49pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/3 "2021-08-30T12:49:21Z")
> [@gauravnbs](#): > > other data we paste How are you getting the data to paste? - Copy to clipboard button in Manager or - Selecting then copying a Manager page or - Using a table copy extension in your web browser used to view Manager How are you pasting into LibreOffice calc - Paste special text or - Paste html ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 1:20pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/4 "2021-08-30T13:20:35Z")
To copy data from invoice we use copy and paste in calc or any other spreadsheet application. ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 1:21pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/5 "2021-08-30T13:21:31Z")
We have also tried special paste function, convert text to column, format text to number… But no help ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 1:30pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/6 "2021-08-30T13:30:13Z")
I think there is some bug, prior to this version, copy paste was working fine to sum total the qty sold to customer to cross check with physical qty ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 1:31pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/7 "2021-08-30T13:31:57Z")
We used the second option ie selecting and copying. For pasting we tried both the methods… ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [August 30, 2021, 2:28pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/8 "2021-08-30T14:28:27Z")
If you are copying data from a Sales Invoice (which is what it looks like), then Tut’s answer here is of relevance [Copy To Excel not working in Sales Invoice View Section - Manager Forum](https://forum.manager.io/t/copy-to-excel-not-working-in-sales-invoice-view-section/36733) ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 2:59pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/9 "2021-08-30T14:59:47Z")
Now Whats The Solution ? ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [August 30, 2021, 3:00pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/10 "2021-08-30T15:00:12Z")
There isn’t one ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 3:08pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/11 "2021-08-30T15:08:41Z")
With Every New Update, A New BUG is Arriving… Should We Stop Updating Manager ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [August 30, 2021, 3:11pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/12 "2021-08-30T15:11:13Z")
if you are using the desktop or Server version, then yes you could stop applying updates. This will stop you getting corrections for any bugs and new features. The problem you face is not a bug - it was never a supported feature of Manager, so can not now be classed as a bug. A bug is a supported feature that no longer works ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 3:14pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/13 "2021-08-30T15:14:41Z")
But Now We Just Got Stuck In Middle. Also there is no option for SUM total of Qty Sold In An invoice to cross check with physical. In My Case, Sum Function is Working On Serial No. ( see attachment) but not any other field Due to this Function Error We can even analyses the date within an invoice ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [August 30, 2021, 3:47pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/14 "2021-08-30T15:47:53Z")
> [@gauravnbs](#): > > To copy data from invoice we use copy and paste in calc or any other spreadsheet application. Manually selecting and copying directly from the webpage has nothing to do with how manager is coded. It’s how websites work in general. What probably happened is that you might have selected additional invisible characters along with your numbers. To test this you can use this spreadsheet function to test the length of cell values. For example: `=Len(d22)` should yield 3 for number or greater than 6 if you have copied some text with it. Anyway, I think your best solution is to make a custom report so you can copy and paste invoice lines using Copy to clipboard and avoid copying mistakes. ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 4:10pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/15 "2021-08-30T16:10:43Z")
Can you please guide me how to copy from invoice to excel ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [August 30, 2021, 4:24pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/16 "2021-08-30T16:24:43Z")
> [@gauravnbs](#): > > Can you please guide me how to copy from invoice to excel You cannot. > [@gauravnbs](#): > > Also there is no option for SUM total of Qty Sold In An invoice to cross check with physical. You are complaining here about a feature in a different program. > [@gauravnbs](#): > > to see the SUM of total quantity and other data we paste the data in Libreoffice Calc. Why are you doing this instead of using the various reporting and drill-down features in Manager? ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 4:40pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/17 "2021-08-30T16:40:17Z")
The answer is simple To Sum Up the qty sold in an invoice to cross check with physical qty as sum total of qty feature is missing. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [August 30, 2021, 4:47pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/18 "2021-08-30T16:47:01Z")
It is not possible to have the sum of the quantities on a sales invoice because the quantities may all be in different units eg how you you sum this invoice Sugar 10 Kgs €3/kg € 30 Milk 25 L €1/L € 25 Total € 55 Adding together 10 Kgs and 25 L would be a complete nonsense ---
**Author:** ![gauravnbs](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/gauravnbs/32/33971_2.png) [@gauravnbs](https://forum.manager.io/u/gauravnbs)\ **Post date:** [August 30, 2021, 4:50pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/19 "2021-08-30T16:50:34Z")
=len(XX) is yielding 3 and its a number as per info provided by you, but still no function is applicable ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [August 30, 2021, 5:33pm UTC](https://forum.manager.io/t/data-is-neither-text-nor-number/36769/20 "2021-08-30T17:33:49Z")
Then maybe this should help [https://ask.libreoffice.org/t/how-convert-from-text-to-numbers-after-importing/23623](https://ask.libreoffice.org/t/how-convert-from-text-to-numbers-after-importing/23623) [Next page](https://forum.manager.io/t/data-is-neither-text-nor-number/36769.md?page=2)