Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Johnny Rosenberg 
Thank you all for trying to find the solution to this issue. I also think
”Formatted Display” is a bit cryptic and I couldn't find out what it
actually does either.



Kind regards

Johnny Rosenberg

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Drew Jensen 
Thanks for finding those issues - I guess lots of folks thinking the same
thing. I tried searching the expert configuration looking for any option
that might change the behavior also.

Also searched the on-line help and the last version of the Calc guide and
found zero entries for "Formatted Display". HMM, but given I'm supposed to
be helping update that guide I suppose I know who can change that, and I
will as soon as I can figure out what it is supposed to actually do ;-)

For whatever it is worth I would happy if the following could be coded:
Allow the setting of the option on the "Find & Replace" dialog under
search[ Formulas, Values, Notes] to stick and to influence the way the
"Find" toolbar searches.


Off to see about adding a comment to the first issue on that, if that
hasn't been suggested yet.

Best wishes,

Drew
Drew

On Sun, Dec 30, 2018 at 12:35 PM V Stuart Foote 
wrote:

> Knew this had come up, with open BZ issues to correct:
>
> tdf#102506 
> ... add Expert configuration option to set search for cell Values in stead
> of Formulas
>
> tdf#102615 
> ... Have Find Bar (Ctrl+F) and Find & Replace (Ctrl+H) search Values by
> default
>
> Think issue was to not change defaults until they could be recorded to user
> profile--UI or Expert Configuration
>
> At the moment with the OpenGrok git reindex running for CORE I'm unable to
> figure out what "Formatted Display" checkbox does.
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread V Stuart Foote 
Knew this had come up, with open BZ issues to correct:

tdf#102506   
... add Expert configuration option to set search for cell Values in stead
of Formulas

tdf#102615   
... Have Find Bar (Ctrl+F) and Find & Replace (Ctrl+H) search Values by
default

Think issue was to not change defaults until they could be recorded to user
profile--UI or Expert Configuration

At the moment with the OpenGrok git reindex running for CORE I'm unable to
figure out what "Formatted Display" checkbox does.



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread V Stuart Foote 
V Stuart Foote wrote
> Hmm, that's weird because it works  on Windows builds (6.1.4.2 and current
> 6.3.0 master)--finding against values, not formulas--when "Formatted
> Display" is checked enabled.
> 
> OS dependent somehow?

Bah, never-mind. Once I plugged in some formulas that calculate a
result--those results are *not* found on search from the Find toolbar. And
if the search string is a part of the formula it is found.

E.g.  cell value entry of 31.5, a fomula entry of =31.5*2 and a formula
entry of =63/2

The first two are found on search, the third is not.  The "Formatted
Display" checkbox has no affect.

Windows 6.1.4.2 and master 6.3.0



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread V Stuart Foote 
drew-gmail wrote
> Well, just to be clear - tried this with the example spreadsheet here with
> version 6.0.7 and 5.4.7 and using FIND does not do what the original
> poster
> is looking for. It seems the only way to find all of those values is by
> using FIND & REPLACE.
> 
> Now I'm not sure what 'FORMATTED DISPLAY' actually does.

Hmm, that's weird because it works  on Windows builds (6.1.4.2 and current
6.3.0 master)--finding against values, not formulas--when "Formatted
Display" is checked enabled.

OS dependent somehow?



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Drew Jensen 
Well, just to be clear - tried this with the example spreadsheet here with
version 6.0.7 and 5.4.7 and using FIND does not do what the original poster
is looking for. It seems the only way to find all of those values is by
using FIND & REPLACE.

Now I'm not sure what 'FORMATTED DISPLAY' actually does.

On Sun, Dec 30, 2018 at 10:58 AM Drew Jensen 
wrote:

> @V Stuart
> I thought that also - but that isn't working, as I just proved to myself,
> with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least.
>
> On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote 
> wrote:
>
>> @Johnny,
>>
>> Unless I am really misunderstanding, the "Formatted Display" check box
>> will
>> shift search results to match against the *values* as formatted to cell.
>>  A
>> generalized implementation of the Find & Replace dialog's "Search in"
>> listbox selection.
>>
>> Should give you your find results via the Find toolbar.
>>
>>
>>
>>
>>
>> --
>> Sent from:
>> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Drew Jensen 
@V Stuart
I thought that also - but that isn't working, as I just proved to myself,
with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least.

On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote 
wrote:

> @Johnny,
>
> Unless I am really misunderstanding, the "Formatted Display" check box will
> shift search results to match against the *values* as formatted to cell.
>  A
> generalized implementation of the Find & Replace dialog's "Search in"
> listbox selection.
>
> Should give you your find results via the Find toolbar.
>
>
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread V Stuart Foote 
@Johnny,

Unless I am really misunderstanding, the "Formatted Display" check box will
shift search results to match against the *values* as formatted to cell.   A
generalized implementation of the Find & Replace dialog's "Search in"
listbox selection.

Should give you your find results via the Find toolbar.





--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy