Ask Your Question

homefire's profile - activity

2019-06-01 15:25:26 +0200 received badge  Enthusiast
2019-05-29 16:28:38 +0200 asked a question How can I get comment boxes over the buttons?

How can I get comment boxes over the buttons? My comment boxes in Calc are popping up under my buttons even when I arran

2019-05-17 22:19:08 +0200 received badge  Notable Question (source)
2019-05-14 18:12:50 +0200 commented answer Print Unicode to a file

By printing the file I mean that I am using the Print command to send one long string to an open file. It could be descr

2019-05-14 10:37:48 +0200 received badge  Notable Question (source)
2019-05-13 17:18:44 +0200 answered a question Print Unicode to a file

It seems that the situation is both simpler and more complicated that I expected. Opening my file with NotePad shows the

2019-05-12 13:46:47 +0200 received badge  Popular Question (source)
2019-05-11 20:34:40 +0200 marked best answer Scan string for unicode character

LO Calc is entering a Unicode apostrophe in manual text entries, rather than an ASCII apostrophe which I need for exporting in a GPX file going to Garmin Basecamp. I can change this using the menu item Tools>Autocorrect options, but this is not reliable for someone else using the spreadsheet. Using a macro, I need to scan for the Unicode character U+2019, and replace it with the ASCII apostrophe. What is a good approach for this?

2019-05-11 20:34:40 +0200 received badge  Scholar (source)
2019-05-11 19:33:52 +0200 commented answer Print Unicode to a file

Although some of the data items are numeric, such as latitude/longitude, all are printed as string text.

2019-05-11 19:29:57 +0200 commented answer Print Unicode to a file

A .GPX file uses an XML format with each data item surrounded by opening and closing tags. I manually (macro) take each

2019-05-11 18:31:06 +0200 commented answer Print Unicode to a file

Thank you for responding. I guess I was too brief. My Calc spreadsheet is written to run on both Windows and Mac using m

2019-05-11 14:48:54 +0200 asked a question Print Unicode to a file

Print Unicode to a file I’m using the simple code below to print a string to a file. It is working fine except when the

2019-05-10 10:23:48 +0200 received badge  Popular Question (source)
2019-05-09 18:27:47 +0200 answered a question Scan string for unicode character

Simple Regular Expression. Thank you.

2019-05-09 17:04:20 +0200 asked a question Scan string for unicode character

Scan string for unicode character LO Calc is entering a Unicode apostrophe in manual text entries, rather than an ASCII