Bug: Copying Text into excel leads to the text being formatted as "superscript"

Description

When copying Bible text into excel, the text will sometimes be changed to "superscript"

Repro

Open Logos 4
Open Na27
Use Copy Bible Text tool
Choose "1 verse per line" format
Choose "Other" destination
Select Copy
Paste in Excel spreadsheet
Select part of text segement from a cell
Paste text segment into new cell

Actual Result

The pasted text will be formatted as a superscript and have to have the formatting changed in excel. This seems to stem from the fact that the verse number at the start of the line is superscripted.

Expected Result

The text should appear normally.

System Specs (if using multiple computers or not in your signature)

Windows Vista desktop, Intel Core 2, 2GB RAM, GeForce 7300 LE

Find more posts tagged with

Features

Comments

Melissa Snyder

When copying Bible text into excel, the text will sometimes be changed to "superscript"

Hi Dave,

I'm not able to reproduce this yet following your repro steps. You say above that it will "sometimes" change to superscript. Have you been able to determine what is being done differently (if anything) when it pastes that way?

Thanks,
Melissa

Chris Elford

Description

When copying Bible text into excel, the text will sometimes be changed to "superscript"

David,

I can't repro either.

In fact, I get a couple of different things I think may be bugs.

When I use the copy verse tool, it defaults to my preferred Bible as opposed to copying my current Bible - so my first copy was not from N27
When I forced (selected is a nicer word) N27 and copied over it went fine, and I selected portions (not including the beginning of a verse) and it copied fine to a new cell, but when I copied the beginning, it didn't superscript anything, including the verse number.

Screen shot:

Chris

Melissa Snyder

https://community.logos.com/discussion/comment/13921#Comment_13921

Description

When copying Bible text into excel, the text will sometimes be changed to "superscript"

David,

I can't repro either.

In fact, I get a couple of different things I think may be bugs.

When I use the copy verse tool, it defaults to my preferred Bible as opposed to copying my current Bible - so my first copy was not from N27

When I forced (selected is a nicer word) N27 and copied over it went fine, and I selected portions (not including the beginning of a verse) and it copied fine to a new cell, but when I copied the beginning, it didn't superscript anything, including the verse number.

Chris

Chris ~ Thanks for giving this a try.

The CBV tool remembers the last Bible used. That is how LDLS 3 worked as well. I've asked whether it could use the open Bible instead, since it puts the current passage into the reference box. Then if there is no Bible open, it would use the previous one. I don't know if that's doable or preferrable, though.
I would think that copying from one cell and pasting into another would be limited by Excel not Logos, so it may not be something we cannot fix on our end.

Melissa

Chris Elford

https://community.logos.com/discussion/comment/14141#Comment_14141

Melissa,

Thanks for looking into this. I hope they'll be able to make that change in the CBV as it would intuitively be the way to go.

I agree that the other issue is probably an Excel issue.

Not sure why it does things differently with David. I use Excel 2003 do you, David or 2007? That might explain different responses.

Chris

davidphillips

https://community.logos.com/discussion/comment/14152#Comment_14152

I am using 2007. Melissa, what version of Excel are you using? I agree that it is almost certainly an excel issue, however I never had the problem with 3.0. I'll put together a step-by-step account with pictures to make clear what I'm doing, but I won't be able to do so until tomorrow. Thanks for looking into this Melissa!

EDIT- Melissa, when I said sometimes I should have been more clear. This always happens for me when I copy the verses with "other" selected as a source. If I try pasting into Excel after choosing MS word, or powerpoint, or Publisher, or a text document as the source, things work a little differently. For example, with some of the options, the text imports into excel already superscripted. I don't remember which ones offhand, but I'll post screen shots of that tomorrow as well.

davidphillips

I found the problem! Or rather, I found out what step I was leaving out to reproduce my problem

Here is the new list of steps, which should, in Excel 2007, reproduce the problem.

Repro

Open Logos 4
Open Na27
Use Copy Bible Text tool
Choose "1 verse per line" format
Choose "Other" destination
Select Copy
Paste in Excel spreadsheet
Select and cut part of text segement from a cell
Insert new rows between verses (alt+i+r)
Paste text segment into new cell

It seems that inserting new rows carries over the superscript format, since the row started with a superscripted character. Pasting the cut text anywhere else causes no problems. Here are my screen shots to demonstrate the steps:

Melissa Snyder

https://community.logos.com/discussion/comment/14395#Comment_14395

Thank you for following up. That explains the behavior.

Chris Elford

https://community.logos.com/discussion/comment/14395#Comment_14395

David,

Yes, that is an Excel issue. I've seen it before where inserting a row replicates the format (fill color, bold, superscript, font, borders, row height, etc.). I'm sure MS would call it a feature (saves you having to copy the format) and not a bug.

Chris