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

2018-12-30 Thread 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

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

2018-12-30 Thread 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

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?

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

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

[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

[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

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

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

[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

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

2018-12-30 Thread 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