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
Comments
-
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,
Melissa0 -
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
0 -
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
0 -
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
0 -
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.
0 -
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:
0 -
Thank you for following up. That explains the behavior.
0 -
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
0
