Survey about LibreOffice

users
#1

Hi all:

  I make a form to get a survey about the organizations that you or
others know that use LibreOffice.

  It is becouse I think it is important and interesting to know how many organizations
use LibreOffice in the world not only how many download it!

  The link of the survey is this and you can share with more people
from others e-mail lists or sites:

https://es.surveymonkey.com/r/L7QT923

  The survey will end the next 7/05/2017 (included)

Regards,

#2

Hi all:

  I want to remember you the survey ... would you please answer it to
this link if you haven't done ?

https://es.surveymonkey.com/r/L7QT923

Regards,

#3

I tried:
1) What is googleapis, a script that was attempted to be run? Sounds rather googleish to me.
2) In your categories of types of organizations, "Small Businesse" was not included. (knowing who the users are will help in improving the product to meet the need of the users).
3) On the following screen, the language changed from American English (Ubuntu's default in my case) to Spanish. Although I took a couple of years of French in high school 50 years ago, it didn't help.

John

#4

Hi John:

  I'm sorry ... I can't understand your problem with googleish because
when I did the survey and when I filled it I haven't this kind of
problem. I don't know why google is into the process's survey.

  About "Small Business", you are right ... it's better to know that, but
I didn't think on that when I made the survey. It was my fault.

  I can't understand why the surveymonkey site changed the language.

  Thanks for your feedback. I try to do better the next time,

Regards,

#5

I run Noscript which displays all of the sites that want to send a script to my computer for execution. Not allowing that might have had something to do with the language issue.

John

#6

I'm having a problem, once again, for copy and paste from US Bank downloads into my spreadsheet which was initially created in Excel 5 or so. It's running on Ubuntu which I was just told needs a newer version than the dot 10 that I'm running. Interoffice stuff was reloaded a few weeks ago and I don't know how to read that modification date on the screen.

  ’20170428153706454600 and ‘20170425154724510819 are two "numbers" that the bank uses as unique flags that need to be saved for proof in case of a later problem. They do contain date-like information and I think, random, extra digits. Note the apostrophe-like character that I have added at the beginning. Precision of 64 bit floating point forbids allowing Calc to convert the sequence to a floating point number when I copy and paste.

I have been opening the destination cell and typing in a character which I learned in Excel and elsewhere was the proper thing to do and that the character would advise the software that it's not to be messed with. I have tried several other characters as a first item with the same results.

The number gets placed in the cell in a way that cannot be seen because it is drawn in space that is above the top of the cell. Increasing the height of the row makes it appear. Selecting the cell always allows the number, with it's prefix, to be read and edited in the space to the right of a big = sign at the top of the screen.

Sometimes Calc will insist that I must want a space character after the first character I typed before performing the paste operation. But just deliberately starting with a space is not a solution to the "unreadable above the cell border" problem. Looking back I see the apostrophe sometimes appears and sometimes doesn't. It's as if the presence of the apostrophe is sometimes just a character and other times is treated as "don't mess with my decimal digits".

The second number always works even when I re-try on another cell. It was loaded days earlier. The first number continues to fail no matter what I use as a starting character. (Yes, I have have tried altering the last zeros in the first number.)

Can anyone provide a procedure that will always work?

Off-topic, but perhaps germane: I still have problems with mm/dd/yyyy dates which sometimes get apostrophes added to them by the Calc software. My schemes for handling copy and paste typically have to use the VALUE() function into a temporary cell. But not always. Sigh. Does Calc save dates as floating point 64 bit words?

#7

I'm having a problem, once again, for copy and paste from US Bank downloads into my spreadsheet ...
20170428153706454600 and 20170425154724510819 are two "numbers" that the bank uses as unique flags that need to be saved ...

Your scare quotes betray that you are getting the point that these are not numbers at all, but merely text strings that happens to be composed only of digits. The way to tell that they are not numbers is to ask yourself what would be the point or effect of adding them together or subtracting one from the other - the very sort of things that you do with numbers. (Answer: None at all.)

Note the apostrophe-like character that I have added at the beginning.

That is necessary only if you are *typing* numeric strings into your spreadsheet. (And it should be an apostrophe, not an "apostrophe-like character" - whatever that is.)

Precision of 64 bit floating point forbids allowing Calc to convert the sequence to a floating point number when I copy and paste.

Well, you don't want these strings to become numbers anyway.

The number gets placed in the cell in a way that cannot be seen because it is drawn in space that is above the top of the cell. Increasing the height of the row makes it appear.

I'm guessing that you are somehow copying not just the numeric string but some trailing character representing a line or paragraph break. What happens if you
o double-click the cell to allow editing within the cell,
o move the cursor to the end of the cell contents - on the space under the text itself, that is, and
o press Backspace?

Can anyone provide a procedure that will always work?

Yup.

o First, format the cells to receive this data as Text. You want text, not numbers. Choosing the appropriate format is one of the first things you should do in a spreadsheet. Surely all these tokens will go into a single column that contains nothing else? So you need merely to select the column header and set the format to Text.

o When you paste in the data, use Edit | Paste Special... (or Ctrl+Shift+V) instead of ordinary Paste and choose "Unformatted text". In the unlikely event you see the Text Import dialogue, click the column header under Fields and change "Column type" from Standard to Text.

I still have problems with mm/dd/yyyy dates which sometimes get apostrophes added to them by the Calc software.

This behaviour varies with your locale and other settings. Remember to set cell (or column) format appropriately first. Are you again pasting in extraneous characters?

Does Calc save dates as floating point 64 bit words?

Spreadsheets save dates as numbers - the number of days from a date origin - but displays them according to your chosen format.

I trust this helps.

Brian Barker