nico18n Posted June 30, 2017 Share Posted June 30, 2017 Hello, I use the send command to send text to a table in a openoffice writer document. Whenever "." (fullstop) Appears in the text this is changed to "," comma. How can I prevent this from happening? Thank you. es.: send("Mr. Smith") ---> Mr, Smith Link to comment Share on other sites More sharing options...
SkysLastChance Posted June 30, 2017 Share Posted June 30, 2017 Have you tried Send ("Mr.Smith",1) However, I would reccomned the ControlSend Function. You miss 100% of the shots you don't take. -Wayne Gretzky -Michael Scott Link to comment Share on other sites More sharing options...
nico18n Posted June 30, 2017 Author Share Posted June 30, 2017 Thanks, but unfortunately it does not work. There are no objects in the text file where I just fill in some tables for to use ControlSend() Link to comment Share on other sites More sharing options...
SkysLastChance Posted June 30, 2017 Share Posted June 30, 2017 I don't have OpenOffice Writer so I am unable to test but give this a try. Send ("Mr{.}Smith") You miss 100% of the shots you don't take. -Wayne Gretzky -Michael Scott Link to comment Share on other sites More sharing options...
nico18n Posted June 30, 2017 Author Share Posted June 30, 2017 (edited) That's no good. The result is this Mr {,} :-( I'm afraid the error is OpenOffice at this point that translates the character "." to "," I use OpenOffice 4.1.3 Edited June 30, 2017 by nico18n Link to comment Share on other sites More sharing options...
SkysLastChance Posted June 30, 2017 Share Posted June 30, 2017 I just saw that as well, https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Formatting/How_can_I_use_a_dot_(.)_as_decimal_sign_instead_of_a_comma%3F You miss 100% of the shots you don't take. -Wayne Gretzky -Michael Scott Link to comment Share on other sites More sharing options...
nico18n Posted June 30, 2017 Author Share Posted June 30, 2017 Okay Sky, thanks. I solved by removing the decimal separator selection (,) Thank you for your much appreciated help. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now