handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3

users
#1

Hi,

It looks as if I've missed something.

In LibreOffice 3.3.x, when I type a single quote before a string, that quote is not displayed.
In 3.4 and 3.5 it is displayed.
Not when you enter a quote before numbers, thus changing those to a string.

Have I missed an announcement or feature change that explains this ?

Thanks,

#2

Hi all,

Anyone an idea?

Cor Nouws wrote (08-03-12 18:33)

#3

Am 16.03.2012 10:30, Cor Nouws wrote:

Hi all,

Anyone an idea?

Cor Nouws wrote (08-03-12 18:33)

This is a petty because the leading apostrophe could be used to supress auto-correction and auto-completion of text values just like it supresses evaluation of numeric and formula expressions.

#4

Cor

Showing the apostrophe in front of a number is a great help.
If I total a column it immediately tells me which numbers are included in
the total and, more important, which numbers are not.
Real text does not need the apostrophe.

Tink.

#5

Hi Tink,

Tinkerer wrote (16-03-12 16:31)

Showing the apostrophe in front of a number is a great help.
If I total a column it immediately tells me which numbers are included in
the total and, more important, which numbers are not.
Real text does not need the apostrophe.

Ah yes, and so what is your conclusion :slight_smile:

#6

Am 16.03.2012 16:31, Tinkerer wrote:

Cor

Showing the apostrophe in front of a number is a great help.
If I total a column it immediately tells me which numbers are included in
the total and, more important, which numbers are not.
Real text does not need the apostrophe.

Tink.

And it still does the same with numbers and formulas.
menu:View>Highlight Values [Ctrl+F8] gives a more clear indication since you see all text in black and numbers in blue.
In addition, all text is left bound unless you format your sheet to death (by centered orientation for instance),

The problem is that you could use the apostrophe with any type of input. With text it supressed auto-completion and auto-correction.

#7

Hi Cor

The way it is now is ideal for what I do, but needs vary.
Your question implies that I might need something extra, I cannot think what
though.
So..... If it ain't broke, don't fix it.

Best, Tink.

#8

Tinkerer wrote

Hi Cor

The way it is now is ideal for what I do, but needs vary.
Your question implies that I might need something extra, I cannot think
what though.
So..... If it ain't broke, don't fix it.

Best, Tink.

It used to work as usual. It has been broken in 3.5. It needs fixing.

#9

My _guess_ is that these _may_ be related:
<http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html>
<https://bugs.freedesktop.org/show_bug.cgi?id=38133>
[FILEOPEN tsv import: single-quote at beginning of cell deleted]
<https://bugs.freedesktop.org/show_bug.cgi?id=32703>
[CSV import could ignore leading spaces if the field content without
them is quoted.]

#10

Hi,

on LibreOffice 3.5.1.2 aren't showing and running any macro write in java.

The step to reproduce is:

Tools -> Macros -> Run Macro
LibreOffice Macros -> MemoryUsage

Don't show the macro "/Applications/LibreOffice.app/Contents/share/Scripts/java/MemoryUsage"

Know somebody how to fix it?

thanks

#11

The same problem with Windows XP SP3 + Oracle Java 1.7

#12

Don't know. What has this to do with the original subject ( handling of
quotes before text in Calc 3.4 and 3.5 changed compare) of the thread
that you hijacked? Please start a new thread/email rather than simply
changing the subject of some other thread. Thanks.