Re: [libreoffice-users] Looking for input form example...

[Robert Großkopf]

Hi Michael,
> 
> What I'm convinced they want to do (I know, not right tool for the right
> job) is have a form doc that can be opened on demand, filled in by the
> operator then printed. I'm being led to believe that they don't even want
> to save it to disk.

So could be the XML-Formdocuments are better for it. Have made a
description in German for it:
http://robert.familiegrosskopf.de/index.php?=xml_formulare

English descriptions you could gind here:
https://wiki.openoffice.org/wiki/File:OpenOfficeXMLExampleForm.odt

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
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] Looking for input form example...

[Michael Tiernan]

Thanks for e everyone's response.

I'm going to look at the pointers you've provided.

What I'm convinced they want to do (I know, not right tool for the right
job) is have a form doc that can be opened on demand, filled in by the
operator then printed. I'm being led to believe that they don't even want
to save it to disk.

They're just looking (it seems) to provide a way of forcing the formatted
output of some fields. It's not even critical, it's an exercise for them
and, as much as it pains me I'm letting them run with it to let them learn
from it.

Thanks for everyone's time.

Best wishes to all for the new year!

-- 
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?

[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?

[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?

[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?

[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?

[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?

[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?

[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?

[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

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

[Johnny Rosenberg]

Hi!
Since the old find tool was replaced with the new extremely simplified one
I always have to use the Find & Replace dialogue to actually find what I'm
looking for.

So either the new (I know, it's not THAT new, but at least newer than the
old one…) find tool is useless or I don't understand how to use it,
probably the latter.

So let's do an example:
I have a sheet with a column (F in this case) with values formatted by just
clicking the % button, so it looks like this:
⁝
39,1%
38,8%
38,6%
⁝
(In my country we use a decimal comma, so if you use a decimal point, just
replace all commas with points in your mind…)
These are calculated values, for instance F100=IF(G100="";"";E100/G100)

Now I want to find a cell in the F column that contains the value 36,88. I
can easily do that with the Search & Replace dialogue:
Search: 36,88
Replace:
☐ Current selection only
☐ Regular expressions
☐ Similarity search
☐ Replace backwards
☐ Cell styles
☐ Wildcards
☐ Diacritic-sensitive
Direction: ⦿ Rows ⦾ Columns
Search in: Values

Hitting Find Next immediately finds and selects F109 in this specific case.

Using the overly simplified Find, this doesn't seem to be possible. It
seems like ”Search in formulas” is the default and unchangeable option
here, and how often do I want that? Only when I want to quickly edit
formulas in multiple cells at once, and then I would need the Search &
Replace dialogue anyway, wouldn't I?

So my question seems to end up being: What is the Find tool for? When is it
a better tool than the Search & Replace dialogue?


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