Search found 2 matches

by bad_nerd
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,...
by bad_nerd
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 ...

Go to advanced search