Search found 2 matches
- 08 Feb 2021
- Forum: MultiCharts
- Topic: Copied optimization report data cannot be pasted into Google Sheets (extra commas in numbers)
- Replies: 2
- Views: 468
Re: Copied optimization report data cannot be pasted into Google Sheets (extra commas in numbers)
Thanks for the response. The problem is actually that the data exported by Multicharts is not separated by semicolons, but commas. This means the commas in large numbers are indistinguishable from commas used to separate columns. Here's some example data I just pulled from an optimization report: 2,...
- 25 Jan 2021
- Forum: MultiCharts
- Topic: Copied optimization report data cannot be pasted into Google Sheets (extra commas in numbers)
- Replies: 2
- Views: 468
Copied optimization report data cannot be pasted into Google Sheets (extra commas in numbers)
Copied data from the Optimization Report contains comma separators in large number, e.g. 1,500 or 2,000,000. This causes issues when trying to paste the data into Google Sheets because Sheets uses commas to delimit columns. I have not tested with Excel. To reproduce: 1) From the Optimization Report ...