DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: CHS not copying text from column of cells  (Read 7,224 times)

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,970
    • Gathering Badge
    • Participated in NANY Challenge Once
CHS not copying text from column of cells
« on: February 22, 2017, 01:24 PM »
Scenario:
  • select a column in a spreadsheet file by clicking on the header
  • Copy
  • The text *is* being copied to the clipboard, but it does not show anywhere in CHS

I thought this may be to do with volume of text I was copying (thousands of entries) in the spreadsheet,
but see I have the same problem copying a few entries (~20) from my IM (InfoQube)

I cant image it might be the case, but is there a setting somehow related to this?
Or is it a bug?

EDIT//
CHS version 2.3.9, installed version
Windows 7 x64
Tom
« Last Edit: February 22, 2017, 01:31 PM by tomos »

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
Re: CHS not copying text from column of cells
« Reply #1 on: February 22, 2017, 01:33 PM »
Just guessing: The list of columns is an object, not text or rtf?
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,970
    • Gathering Badge
    • Participated in NANY Challenge Once
Re: CHS not copying text from column of cells
« Reply #2 on: February 22, 2017, 02:17 PM »
Just guessing: The list of columns is an object, not text or rtf?

not sure what you mean by 'list of columns' Ath, do you mean the selected column I copied?

Also lost by the object reference: can a column be an object? (note I'm a fairly basic spreadsheet user)
FWIW, in my example,
the selected column in each case contained text, often with cell shading/highlighting though [edit] when I think about it, there may have been conditional formatting, must check [/edit]

In the IM, it was similar situation, but not a complete column, but about 20 cells within one column. All plain text, (but not sure how it gets copied to clipboard).
Tom

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: CHS not copying text from column of cells
« Reply #3 on: February 22, 2017, 03:41 PM »
One thing you could test to see if the copy is resulting in TEXT on the clipboard is do the copy as you are doing it and then try to PASTE it into notepad or another text editor.  See what shows up when you try to paste into a text editor.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,970
    • Gathering Badge
    • Participated in NANY Challenge Once
Re: CHS not copying text from column of cells
« Reply #4 on: February 22, 2017, 04:20 PM »
One thing you could test to see if the copy is resulting in TEXT on the clipboard is do the copy as you are doing it and then try to PASTE it into notepad or another text editor.  See what shows up when you try to paste into a text editor.

here's one example:
this column just had text, well numbers, with no formatting -- but with a little over 3,000 entries

Code: (text)
2016-11-00 snpsht
268
269
270
271
272
273
274
44
275
276
277
278
279
280
281
282
283
182
183
184
284
285
286
287
288
289

it copies and pastes fine, just doesnt show up in CHS --
but in fairness, do we want lists with 3,000+ entries clogging up CHS?

So that wasnt the problem for me:
I posted because of the problem with the list of 20 entries, which I thought was related -- let me look at that in a bit more detail next post.
Tom

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: CHS not copying text from column of cells
« Reply #5 on: February 22, 2017, 04:24 PM »
CHS has settings where you can tell it to ignore clips that are larger than a certain size -- they are on the Capture Options tab.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,970
    • Gathering Badge
    • Participated in NANY Challenge Once
Re: CHS not copying text from column of cells
« Reply #6 on: February 22, 2017, 04:43 PM »
^ yes, capture was set to 9999 bytes

So,
it seems the two examples I gave are completely unrelated.

In InfoQube (IQ) sometime it works and sometimes not.
Here's an example that repeatedly wont work (i.e. goes to clipboard, but not to CHS)

Code: (text)
	I’m torn between making these lists totally separate from the book -- or having them related to the book (i.e. with page numbers).
Maybe initially I will make them completely separate (?)
List Elevations
EDIT// the initial tab character gets stripped out there //EDIT

Here's how the text looks in IQ:

Screenshot - 2017-02-22 , 17_32_54.png

here's how it looks in Evernote (old 2.2.1.xxx version) and
in text editor

Screenshot - 2017-02-22 , 17_38_42.png

# what is interesting is that CHS doesnt recognise the text either when I try to copy it from Evernote !
# I thought it might be something to do with the first entry being indented more than the second -- so tried other examples like that directly from IQ, but they worked.
Tom

Original address: https://www.donationcoder.com/forum/index.php?topic=43538.0