Ask Your Question
1

Finding entries in Calc with apostrophes

asked 2018-10-09 21:26:28 +0100

lajoes gravatar image

updated 2020-08-24 02:30:35 +0100

LeroyG gravatar image

I use Calc to store my DVD/BD collection.

My problem: If there is an apostrophe in the title, i.e., "at sword's point" it will not locate any of the words in that entry.

But if I enter it as, "at swords point" it will find it.

Edit 2018-10-09: Thanks for bringing that to my attention Mike. I am using 6.0.6.2 and I just noticed that the latest version available is 6.1.2. I was just so frustrated, I overlooked the obvious.

I'll download it and give an update tomorrow.

Edit 2018-10-10: After posting my problem, I have updated to LO 6.1.2.1 (x64) and I am still experiencing the same bug.

I am using LO Calc as a database for my DVD/BD collection. Whenever a title has a word with an apostrophe in the title, i.e., "at sword's point", Calc's response is, "search key not found.

However, if I change the title to, "at swords point", Calc will find it.

edit retag flag offensive close merge delete

Comments

Works for me with 6.1.2.1... what LO version are you using?

Mike Kaganski gravatar imageMike Kaganski ( 2018-10-09 21:33:13 +0100 )edit

what is "it"? (in "it will not locate .."

EasyTrieve gravatar imageEasyTrieve ( 2018-10-10 22:21:50 +0100 )edit

Since I posted this problem, I have now upgraded to version 7.0.0.3

I am still experiencing the same problem.

If i forget to change "sword's point" to "swords point" I can search for all the words after the word with the apostrophe, i.e., I'd search for "point". This will only work if there is at least 1 word after the word with the apostrophe.

If the last word in the title has the apostrophe, I'm out of luck. Calc will not find anything.

lajoes gravatar imagelajoes ( 2020-08-24 15:28:02 +0100 )edit

Here's how I get around this problem: I double list the title. The first entry doesn't have the apostrophe, and the type point is set a 5 (to make it tiny compared to the main entry listed below it):

Running Wild (1927)
67 Mins Rtg NR BD BW FF

At swords point
At Sword’s Point (1952)
81 Mins Rtg NR DVD-R C FF

Phantom Tollbooth, The (1969)
89 Mins Rtg G DVD C WS

lajoes gravatar imagelajoes ( 2020-08-24 15:38:57 +0100 )edit

and here's another example, same as above:

And so it goes (2014)
93 Mins Rtg PG-13 BD C WS

Ill see you in my dreams
I’ll see you in my dreams (2015)
92 Mins Rtg PG-13 BD C WS

Gods not dead a light in darkness
God’s not dead A light in darkness (2018)
105 Mins Rtg PG BD C WS

Book Club (2018)
103 Mins Rtg PG-13 BD C WS

lajoes gravatar imagelajoes ( 2020-08-24 15:41:25 +0100 )edit

Oh, and there are over 9177 entries in my DB = 9177 cells/rows.

lajoes gravatar imagelajoes ( 2020-08-24 15:43:56 +0100 )edit

1 Answer

Sort by » oldest newest most voted
3

answered 2020-08-25 06:13:05 +0100

Earnest Al gravatar image

You know that you are using a typographical apostrophe, U+2019, in your content not a keyboard apostrophe (U+0027)? I guess if you copy the bolded word Sword’s and paste it into the search, you will find it in your list. (If you click directly after an apostrophe and press the keys Alt+X, it will convert it to a U-number, Alt+X again to turn it back.)

You can stop LO turning your apostrophes into typographical ones by clicking on Tools > AutoCorrect Options..., in the window that opens click on the Localised Options tab and untick the Single Quotes Replace box (and the Double Quotes Replace box if wanted).

Also check that your Grammar checker if you have one doesn't put them back again Tools > Options > Language Settings > English Sentence Checking and untick Quotation Marks. If you don't have English Sentence Checking then don't worry, probably.

KeyboardToTypographicalQuotes

You can find and replace all your apostrophes by copying the typographical quote into Find and entering a keyboard quote into Replace. You might want to do it field by field if you want to also delete your workaround text. Cheers, Al

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-09 21:26:28 +0100

Seen: 122 times

Last updated: Aug 25 '20