Re: [libreoffice-users] Help - how to get rid of 'administrator'

[Alan B]

Emily,

The following presumes you use Windows.

This is a test to attempt to isolate the problem...
* Use a thumb drive (USB drive) ,
* create and save a file to the thumb drive (use Write, Calc, or whichever
program you use most)
* close the program used to create the file
* eject the thumb drive
* right click the drive and pick the "Eject" option
* wait for the safe to remove message (this must be done to prevent
file corruption)
* remove the drive
* open the program again
* insert the thumb drive
* open the file and test if you can edit and save or not

If it is possible to edit and save the file on the thumb drive then the
problem is most likely the security settings for the location the files are
being saved to on the computer.

BUT even if files on the thumb drive can be edited and saved with
LibreOffice while those on the computer cannot be, there is still another
bit of info that's needed. Using other programs is it possible to
create/edit/save files to the same place on the computer as the LibreOffice
files?

If other files also can not be created/edited/saved to the same place with
other programs (the same problem as with LibreOffice) then the culprit is
nearly certainly the computer's security settings for that location.

If only the LibreOffice files can not be created/edited/saved then more
investigation into the files and LibreOffice installation will be needed.

If you try the above, please provide an update so we know if it is only
LibreOffice doing this (so likely an LO problem to work out) or other
programs do it too (so likely a computer security problem).

Knowing the above will help with troubleshooting and resolving the problem.

On Wed, Mar 6, 2024 at 5:00 PM Emily Scharf 
wrote:

> I have used Libreoffice for years. But recently I downloaded it and -
> mistakenly - responded to an option for greater security.  This turns out
> to be 'administrator' which continually blocks me from anything but
> read-only documents.
>
> How do I turn off the 'administrator'?  I even tried to uninstall and
> download again and it is still happening with my documents..
>
> If I cannot stop the 'administrator' I will be forced to use another
> programme (though I have used LibreOffice for years)
>
> Thank you for your help.
>
> Emily from London
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Tab Settings

[Alan B]

... sent original reply to OP only. My error ...

To modify default tab stops in LO 7.6.x

   - Select Tool>Options
   - Open the "LibreOffice Writer" branch
   - Select the "General" option
   - In the Settings option
  - accept or select the measurement unit
  - then set the tab stop dimension
   - Click "OK"

When I do that with a new blank document, the inverted "T"s under the ruler
change their spacing without requiring the document or the program to be
closed and opened.

There is also a topic in LibreOffice help "Inserting and Editing Tab Stops"
which address other ways to set tab stops

On Thu, Dec 28, 2023 at 2:39 PM charles meyer 
wrote:

> Brian wrote...  The solution, where you need to use tab stops in this
> way, is to set
> them specifically where you need them... 
>
> How do you set tabs where you need them?
>
> Steps? Screenshots?
>
> Thank you,
>
> Charles.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Adding hotkey

[Alan B]

The hot keys mentioned are default operating system hot keys on Windows,
since at least Windows 95, and on Ubuntu linux, since I don't know when.

On Ubuntu the keyboard shortcuts can be found in Settings>Keyboard. The
default settings can be changed there.

In Windows, not sure where.

Do the shortcuts work as expected in other programs and they only don't
work in LibreOffice or do they not work as expected in any program?

If only not working in LibreOffice then I would try starting the program in
safe mode and see if it works. If it does, then recreate your LibreOffice
profile and see if that works.

On Thu, Dec 28, 2023 at 1:40 PM W. Robert J. Funnell, Prof. <
robert.funn...@mcgill.ca> wrote:

> Jarek -
>
> I wasn't aware of that shortcut (I close LibreOffice by clicking on the X
> button or by using Ctrl+Q) but I looked it up in the Customize > Keyboard
> dialogue (in LO 7.6.4.1). For me, Alt+F4 is greyed out so it can't be
> modified or deleted. Ctrl-F4, which apparently does the same thing, is also
> greyed out. Is that not the case for you?
>
> - Robert
>
> 
> From: Jarek.Krcmar 
> Sent: December 28, 2023 10:22
> To: Users Libreoffice 
> Subject: [libreoffice-users] Adding hotkey
>
> Hello, I'm writing to you because I managed to delete the access control
> by deleting the alt + 7 shortcut. But I accidentally deleted the alt +
> F4 shortcut because now I can't close Libreoffice. Could you please
> advise me how do I add the shortcut to the list? Thank you in advance
> for your answer. Best regards
> --
> Jarek
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] LO 7.6 and Win7pro

[Alan B]

Per the LibreOffice docs,
https://www.libreoffice.org/get-help/system-requirements/, the current
version runs on Windows 7.

However Microsoft's KB3063858 update must be installed for it to work.

On Sun, Nov 19, 2023 at 5:51 AM DaveB  wrote:

>
>  Original Message 
> From: Pat Brown [mailto:mistyha...@gmail.com]
> Sent: Saturday, 18 November 2023 at 19:41 UTC
> To: Libre Office
> Subject: [libreoffice-users] LO 7.6 and Win7pro
>
> > Are there any issues with running the latest version of LO on a Win 7
> > machine?
> >
> None that I have encountered, running version 7.6,2.1 on both a Win 7
> real and virtual machine. For me the performance and functionality are
> the same as on Win 10 and 11.
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] CalcGuide auto sum

[Alan B]

Not sure if you've gotten the answer you're looking for.

Others have mentioned enabling/disabling the automatic updating of
formulas. If that's what you needed this isn't the answer you're looking
for.

Chapter 1 pg 20 of the 7.2 Calc Guide identifies the sum function as part
of the formula bar and describes how it is used.

If you are looking for a function that will sum a column (or row or table)
of figures when clicking in the worksheet then what you're looking for is
the sum function. That is part of a button just to the left of the input
line. The button has the sigma symbol and a down arrow on it, Σ▾.

In the worksheet...

Select an empty cell at the bottom of the column of figures to sum.
Next click the Σ▾ button, it will display a list of functions including
SUM.
Click on SUM and the sum formula is entered into the cell with the range
automatically selected from the column above.
Press Enter and the selection is summed.

Or BEFORE the button is clicked
Select the range of cells to be summed and one empty cell beyond
Next, click the Σ▾ button to reveal the list of functions, including SUM.
Click on SUM and the sum formula is entered into the cell with the range
included
Press Enter and the selection is summed.


On Wed, Nov 1, 2023 at 10:08 AM Jackie Beauchamp  wrote:

> Good morning
> I am unsure where the total (auto sum) feature is in order to total my
> columns, can you please
> advise where that tool/feature is in CalcGuide ?
> Sincerely yours,
> Jackie Beauchamp
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] where to submit enhancement requests?

[Alan B]

I should know this but don't.

How and where do enhancement requests get submitted?

I recently came across UI features in Calc that are inconvenient and
usability would be improved if they are changed.

To illustrate the differences.
https://wp.boba.org/wp-content/uploads/2023/09/ExcelVsCalc_filter.png

In both cases the column being filtered is the result of a calculation and
is formatted as US$.


-- 
AB

-- 
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] Help please with multipage document.

[Alan B]

With the link, thank you, I see that opening the document always shows me a
full screen view with thumbnails of all seven pages. If that is what you
mean by "it opens to show 7 pages all at once and showing in the same
window" then...

Use the "View > Zoom" menu and select a page view that works for you.

On Thu, Jul 6, 2023 at 11:15 AM Budge  wrote:

> I have downloaded a document from the VistitBritain/VisitEngland website
> which is in which is in a Windows 2007 .docx format.
> When I open the document it LibreOffice Writer it opens to show 7 pages
> all at once and showing in the same window.
>
> How may I break this down into individual pages within the document please
> so I may work on each page and then page down?
>
> Hope somebody can help me with this as I have never seen this format
> before!
> Budge
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Help please with multipage document.

[Alan B]

Which website? There are visitbritain . com and . org

And what file name or document title?

With the above info, others can attempt to open it and solve the problem.

I've tried opening several .docx downloaded from the . org site. All opened
with no issue in LO 6.4.x


On Thu, Jul 6, 2023 at 11:15 AM Budge  wrote:

> I have downloaded a document from the VistitBritain/VisitEngland website
> which is in which is in a Windows 2007 .docx format.
> When I open the document it LibreOffice Writer it opens to show 7 pages
> all at once and showing in the same window.
>
> How may I break this down into individual pages within the document please
> so I may work on each page and then page down?
>
> Hope somebody can help me with this as I have never seen this format
> before!
> Budge
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Writer- find and replace a number

[Alan B]

p.s. I've just seen Eyal Rozenberg's answer which is quite similar.

Aside from [0-9]+ vs [:digit:] there is one significant difference, the "+"
at the end.

Using Eyal's method any consecutive string of digits is replaced with
whatever is in "Replace:".

Using the method I offered each individual digit is replaced by what is in
the "Replace:" field.

That is not because of [0-9] vs [:digit:] but because of the "+".

Pick whichever meets your needs best.

On Fri, Jun 30, 2023 at 6:04 PM Alan B  wrote:

> Regular expressions (regex) are a challenge to get your mind around. Your
> need seems to be straight forward so there's not a lot to absorb to use
> regex for this case.
>
> Open the "Find & Replace" dialog.
>
> In the "Find:" field enter "[:digit:]" without the quotes.
>
> In the "Replace:" field put whatever you'd like to replace EACH digit with.
>
> Tick "Regular expressions" in "Other options".
>
> The regex given will find each individual digit no matter what it is and
> replace it with whatever is in the "Replace:" field.
>
> In essence, it is giving that wildcard you want for numbers.
>
> If you want to experiment some with regex, branching out from the above,
> check the LO regular expression webpage.
> https://help.libreoffice.org/6.2/en-US/text/shared/01/0211.html
>
> I hope this is what you are looking for.
>
> On Fri, Jun 30, 2023 at 5:27 PM .  wrote:
>
>> How do I find and replace all numbers in Writer?
>>
>> What I'm trying to do is get rid of the numbers in a list.
>>
>> I have NO idea what they're talking about "regular expressions" and
>> can't figure out a wild card for numbers.
>>
>> Any ideas?
>>
>>
>> Thanks,
>>
>> Peter
>>
>>
>> --
>> 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
>>
>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Writer- find and replace a number

[Alan B]

Regular expressions (regex) are a challenge to get your mind around. Your
need seems to be straight forward so there's not a lot to absorb to use
regex for this case.

Open the "Find & Replace" dialog.

In the "Find:" field enter "[:digit:]" without the quotes.

In the "Replace:" field put whatever you'd like to replace EACH digit with.

Tick "Regular expressions" in "Other options".

The regex given will find each individual digit no matter what it is and
replace it with whatever is in the "Replace:" field.

In essence, it is giving that wildcard you want for numbers.

If you want to experiment some with regex, branching out from the above,
check the LO regular expression webpage.
https://help.libreoffice.org/6.2/en-US/text/shared/01/0211.html

I hope this is what you are looking for.

On Fri, Jun 30, 2023 at 5:27 PM .  wrote:

> How do I find and replace all numbers in Writer?
>
> What I'm trying to do is get rid of the numbers in a list.
>
> I have NO idea what they're talking about "regular expressions" and
> can't figure out a wild card for numbers.
>
> Any ideas?
>
>
> Thanks,
>
> Peter
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] text fields to time fields

[Alan B]

Don't know where you are on this at the moment but, apologies, I overlooked
using the a.m./p.m. indicator in the text string.

A solution that does not overlook that is to use a formula in an adjacent
cell to convert the text value to a time value and then format that time
value to display as you like. You can then hide your column with text time
values and display only the column with the time value formatted as you
want.

As follows..
Text in cell A1, e.g. 11:00:00 a.m.

Formula in cell B1, e.g.
=IF(REGEX(A1,"(.*)( p.m.| a.m.)","$2")=" p.m.",TIMEVALUE(REGEX(A1,"(.*)(
p.m.| a.m.)","$1"))+0.5,TIMEVALUE(REGEX(A1,"(.*)( p.m.| a.m.)","$1")))
Format the result as you want it to display.

What's in the formula...
The formula presumes all text string times either end with " a.m." or "
p.m."
The =IF() tests whether the time text has the string " p.m" in it. If it
doesn't have " p.m." then it's presumed to have " a.m."

The test uses =REGEX() to parse out the " a.m." or " p.m." string and save
it to a REGEX capture group, "$2". The capture groups are those parts of
the REGEX expression inside parentheses.
In this case the expression is "(.*)( p.m.| a.m.)". It has two capture
groups, two sets of parentheses.

The way you enter your text times is a valid time format without the "
a.m." or " p.m." at the end. Take the time portion of your text, the "$1"
capture group, and convert it to an actual time value.
TIMEVALUE(REGEX(A1,"(.*)( p.m.| a.m.)","$1"))

In the IF test if "$2" capture group equals " p.m." then 12 hours needs to
be added to the time otherwise it is used without adding hours.

So finally if $2 is " p.m." calculate the time as TIMEVALUE(REGEX(A1,"(.*)(
p.m.| a.m.)","$1"))+0.5

Otherwise calculate the time as TIMEVALUE(REGEX(A1,"(.*)( p.m.|
a.m.)","$1"))

Then format the cell with the desired time format.

Hope I haven't overlooked something this time.

On Wed, Jun 28, 2023 at 5:31 PM James  wrote:

> That seems to leave 11 pm as 11:00 (I expect 23:00).
> Maybe I am doing it wrong.
>
> On 2023-06-28 17:10, Alan B wrote:
> > Select the text fields, hopefully they are in a column or columns.
> >
> > After selecting the fields select "Data > Text to Columns..." from the
> menu
> >
> > In the Text to Columns dialog box select the following options:
> > For "Separator Options" tick "Separated by".
> > The only separator option that should be ticked is "Space".
> > Be certain "Detect special numbers" is ticked in the "Other Options"
> > choices.
> > Click the "OK" button.
> >
> > The time portion of the column will now be a time formatted number in the
> > column it was already in. Depending on the default format it may or may
> not
> > have AM/PM. If it doesn't, just change the time format to what you need
> at
> > this point.
> >
> > The "a.m." or "p.m." portion of your original text will be moved one
> column
> > over. It will overwrite what is in the next column if the column is not
> > empty.
> >
> > To prevent adjacent columns from being overwritten, while still in the
> > "Text to Columns" dialog box, go to the "Fields" section at the bottom.
> >
> > There should be two columns with a heading of "Standard", one column
> > showing the time portion of your text, the other column showing the
> a.m/p.m
> > portion. Click the word "Standard" over the a.m/p.m column.
> >
> > Now open the "Column type" list and pick the "Hide" option.
> >
> > Finally, click OK to close the dialog box.
> >
> > You text time will now be a time number in the column it was already in.
> > The a.m/p.m portion has not overwritten the adjacent column as it has
> been
> > discarded as part of the Text to Columns operation.
> >
> >
> > On Wed, Jun 28, 2023 at 4:32 PM James  wrote:
> >
> >> I have text fields like:
> >>
> >> 10:06:59 a.m.
> >> 8:57:36 p.m.
> >>
> >> How do I convert them to 24-hour time fields?
> >> --
> >> 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/
> >

Re: [libreoffice-users] text fields to time fields

[Alan B]

Select the text fields, hopefully they are in a column or columns.

After selecting the fields select "Data > Text to Columns..." from the menu

In the Text to Columns dialog box select the following options:
For "Separator Options" tick "Separated by".
The only separator option that should be ticked is "Space".
Be certain "Detect special numbers" is ticked in the "Other Options"
choices.
Click the "OK" button.

The time portion of the column will now be a time formatted number in the
column it was already in. Depending on the default format it may or may not
have AM/PM. If it doesn't, just change the time format to what you need at
this point.

The "a.m." or "p.m." portion of your original text will be moved one column
over. It will overwrite what is in the next column if the column is not
empty.

To prevent adjacent columns from being overwritten, while still in the
"Text to Columns" dialog box, go to the "Fields" section at the bottom.

There should be two columns with a heading of "Standard", one column
showing the time portion of your text, the other column showing the a.m/p.m
portion. Click the word "Standard" over the a.m/p.m column.

Now open the "Column type" list and pick the "Hide" option.

Finally, click OK to close the dialog box.

You text time will now be a time number in the column it was already in.
The a.m/p.m portion has not overwritten the adjacent column as it has been
discarded as part of the Text to Columns operation.


On Wed, Jun 28, 2023 at 4:32 PM James  wrote:

> I have text fields like:
>
> 10:06:59 a.m.
> 8:57:36 p.m.
>
> How do I convert them to 24-hour time fields?
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Importing a row from a spreadsheet

[Alan B]

Ian, if you reply, please reply to users@global.libreoffice.org, not my
email. Thank you.

I created a twelve (12) column spreadsheet, A to L, with two rows in Calc,
then selected A1:L2, then copied and pasted it into Write.

That had the same result as you described, columns disappearing off the
right of the page.

HOWEVER, when I created an empty one (1) row, twelve (12) column table in
Write FIRST and then pasted the Calc selection into it (cursor at R1, C1 of
table in Write) both rows were pasted into the table and the table did not
expand beyond the margins of the page.

If you haven't tried creating a blank, one row table in Write, with the
same number of columns as your source spreadsheet, give that a shot.

Create the table in Write. Only need one row but need the same number of
columns as in your source spreadsheet.

Then, copy the rows and columns in the spreadsheet.

And finally paste into R1, C1 in the Write table.

See if that produces the result you're looking for.

Also, if you wish to have an individual one row table in Write for each
item in the catalog, proceed with the copy/paste as described above. The
resulting table in Write will have one row for each row pasted from Calc.

To separate the rows in Write, put your cursor in any row, then select
Table>Split Table... from the menu. Select the "No heading" option and
click "OK" button. Repeat as many times as you need to break the table into
individual rows.




On Wed, Apr 26, 2023 at 6:48 AM Ian Graham  wrote:

> Good morning from Wales, UK
>
>
> I am a member of a local Heritage Society which some years ago created a
> digital archive of several hundred photographs.
>
> The archive is indexed in an Excel-type document, which was possibly not
> very skilfully formated at the time. The index comprises 12 columns,
> A>L, in an A4 Landscape layout, but the actual document seems to extend
> rightwards almost to infinity.
>
> I would now like to create new individual ‘slides’, probably as pdfs,
> uniting each image with the information about it. But I have not yet
> worked out the best method by which to import the information from the
> *.ods.
>
>
> One difficulty is that a ‘copy’ of a row from the dbase does not paste
> neatly into a new document – it always seems to spill out to the right.
>
> The other difficulty is choosing the best method of pasting. I have
> tried all the ‘paste special’ options, and none of them seem to offer a
> one-stop-shop route of import.
>
>
> I have tried, for instance, creating a new table of 12 equal columns
> that fits on my new page, with the idea of pasting into it, and then
> sorting out the spacings, but I have not yet even found a way of so
> pasting.
>
> The best method I have come up with so far is simply pasting the copied
> row as unformated text, and then manually inserting the various elements
> into the appropriate cell of a new table; which achieves the desired
> result in the end, but is going to be cumbersome over several hundred
> photos.
>
> Any suggestions as to the most efficient way to proceed will be greatly
> appreciated.
>
> Sincerely
>
> Ian Graham
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] calc formula are displayed as ###

[Alan B]

I see the same effect when the column is too narrow to display the formula.
Display is 

If the column width is increased so the entire formula can be displayed,
then the formula will be displayed.

The fact that the formula does not display over adjacent empty cells, like
text does, I would think of as a required feature. Not calling it a bug
because I don't know and couldn't understand the programming behind the
Display Formulas setting.

The formula() function does not behave the same way and will display the
formula over adjacent cells if they are empty.

On Wed, Jul 13, 2022 at 1:49 AM Uwe Brauer  wrote:

>
>
> Hi
>
> Using LO 7.2, in scalc I selected
>
> Tools-->Options-->Scalc-->View--Display_Formulas
>
> Which I activated
>
> However then the formula in that colum are displayed as ### (before
> turning this option on, the result was displayed)
>
> Is this a BUG or a feature.
>
> If it is a feature I fail to see its benefits.
>
> Regards
>
> Uwe Brauer
>
>
>
>
> --
> I strongly condemn Putin's war of aggression against the Ukraine.
> I support to deliver weapons to Ukraine's military.
> I support the ban of Russia from SWIFT.
> I support the EU membership of the Ukraine.
>
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Toolbar name in Libre Draw

[Alan B]

View > Toolbars > Stardard

displays the toolbar containing the Pilcrow on my LO 6.4.7.2 installation.
I infer the name is "Standard" since if that toolbar is not checked the
toolbar with Pilcrow is not present.

Tools > Customize > Toolbars appears to be the way to identify the features
set for the toolbar. Not a listing as you're asking for but a way to
identify the features on the toolbar nonetheless.

On Sun, Mar 6, 2022 at 5:04 PM charles meyer  wrote:

> Hi All,
>
> I have a Toolbar in Libre Writer with the Pilcrow, Bold, Italics, Font
> Style, Font Size, etc on it.
>
> I looked in Wrier under View > Toolbars and it doesn't seem to have any
> more checkmarks next to any special Toolbars  besides Standard.
>
> Is there a certain name for the Toolbar with the above-mentioned features?
>
> My Googled results just describes how to add Toolbars - not what features
> appear on each Toolbar.
>
> Thank you.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] How to print a section of a SS

[Alan B]

I hasn't been mentioned if the OP is printing to PDF, and my bad for never
reporting the bug, but using LibreOffice File>Export as PDF or the Export
Directly as PDF icon causes EVERYTHING on all tabs to print to the PDF no
matter what print range might be specified, no matter if the print ranges
are deleted then selected anew. EVERYTHING gets dumped into a PDF.

Need to be certain the OP isn't using the PDF feature. If they are, that is
the source of the problem.

On Mon, Oct 18, 2021 at 8:38 PM Steve Edmonds 
wrote:

> Hi John.
> What version of Libreoffice are you on.
> When you say you want to print a section of a sheet, is that a single
> section on just one sheet or sections of multiple sheets.
>
> For me on a single sheet, sometimes the print range has some history
> from previous activity.
> I go Format>Print Ranges>Clear to start.
> Then I highlight the range to print with the mouse and go Format>Print
> Ranges>Define.
>
> Then I go to File>Print Preview to see how many pages that selected
> range will print on, and if necessary adjust the top -/+ slider or page
> format to suit my needs.
> Steve
>
> On 18/10/2021 16:12, John R. Sowden wrote:
> > In an "office" program, I made the foolish assumption that people
> > would understand that SS means Spread Sheet.  I apologize to those who
> > did not grasp that.
> >
> > The version of Thunderbird is 13.0 (32 bit).  Again I assumed that the
> > instructions for a common function, that of printing a section of a SS
> > (see reference above) would not change from version to version.
> > Again, I apologize to those who were confused about the stability of
> > user interfaces.
> >
> > Humbly,
> > John
> >
> >
> > On 10/16/21 8:07 AM, Dan Lewis wrote:
> >>
> >> On 10/15/21 8:25 PM, John R. Sowden wrote:
> >>> I went to Format->Print Range--> define.  Failed
> >>> Went to Help (when all else fails) read, follow instructions, blank
> >>> screen (no examples)
> >>>
> >>> Help?,
> >>>
> >>> John
> >>
> >> What do you mean by SS? Which component of LibreOffice are you using?
> >> What version of LibreOffice are you using?
> >>
> >> Dan
> >>
> >>
> >
> >
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Question

[Alan B]

Default in LO 7.1.5.2

Security level High - Only signed macros from trusted sources allowed to
run.

Plus not 100% compatible with Excel. Excel VBA not likely to run in Calc.
(Formulas are a different story. Much better cross product support.)

On Wed, Oct 6, 2021, 7:36 AM sleepy  wrote:

> Does LibreOffice Calc have macros turned on by default? I accidently opened
> a xlsx file using Calc and I'm a really paranoid and think the file is
> infected I meant to download it but I accidently opened it
>
> --
> 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] extracting cell values

[Alan B]

Hello Miss K.

The result, 16.7, may be pasted into another cell using "Paste value". This
will not paste the formula.

If your result cell is displaying the formula and not the result then there
is a Calc setting to change. Even if you are seeing the formula, using
"Paste value" will paste the value and not the formula.

Also, if pasting into another program, e.g. an email, Paste will paste the
value not the formula.

If you see a formula when you look at your result cell then the Calc
options have been set to display formulas, not results.

To return Calc to the usual setting, display result instead of formula, do
the following:

From the menu select Tools > Options

In the dialog displayed Open the Calc branch, select View, and make certain
the "Formulas" option is not checked. Click OK to finish.


On Sat, Sep 25, 2021 at 12:04 PM mxk  wrote:

> Users Ahoy:
>
> Is there a way to get LO (v5.2.7.2) calc to extract the numerical value
> from a cell, and use that instead of the cell reference in further
> calculations?
>
> Frinstance, if I have 167 in cell A1, and want 16.7 in A2, how can I
> program it, (if at all)?
>
> If I put =A1/10 into A2, A2 will contain A1/10, not 16.7,even though it
> will display as 16.7.
>
> I want to get away from cell references and use the contained values. Can
> I?
>
> I thought that =VALUE(A1)/10 might work, but the result continues to use
> the cell reference, not the contained value.
>
> Miss K
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Calc how to display Autofilter values?

[Alan B]

Not at all what I'm trying to do. Distinct values have their uses. But I
already knew how to do that.

I'm trying to display the AutoFilter values being applied to a table so
they can be read without opening up each filter at the top of each column
to see what the settings are.

For example, three columns Name, Weight, Dimensions. The table has 1000
rows. AutoFilter is in use and 727 rows are displayed. What are the filter
settings? Sure, can tell if a filter is applied by looking at the filter
list widget and opening it if it shows the filter is in use. And even if
all three are in use, no big deal. Only three to open and check the values.

When the table has 30+ columns and hundreds or thousands of rows, not such
a simple task. Much more convenient just to have a formula that will
display the settings of all applied filters.

If I'm not explaining the requirement clearly please look at the link to
the Excel solution. That's got pictures along with an explanation of the
problem and solution.

That's what I'd like to reproduce in Calc.



On Wed, Jun 9, 2021 at 6:49 AM Mike Flannigan  wrote:

>
> See this:
>
> https://bytefreaks.net/applications/libreoffice-calc-get-the-distinct-unique-values-in-a-column-or-a-list-of-elements
>
> You can use Ctrl-z to undo the command, but don't use Ctrl-Shift-y to redo
> it
> on another column.  You must go through the command again on another
> column
> and then do Ctrl-z again.
>
>
> Mike
>
>
> On 6/9/21 3:07 AM, users+h...@global.libreoffice.org wrote:
>
> Many moons ago I was using some Calc sheets with AutoFilter routinely. The
> filter value would be changed, the sheet closed and sometime later opened
> again.
>
> To understand the displayed rows the filter values needed to be known. And
> that involved opening each filter and checking the value.
>
> So I asked, is there a way to display those values? No answers. And the
> need went away.
>
> Just recently had the same need in Excel. Found online the exact answer
> needed to make it 
> work.https://www.extendoffice.com/documents/excel/1444-excel-display-show-filter-criteria.html
> The section "Display / Show auto filter criteria in worksheet with VBA
> code" is what I referenced.
>
> I've used that info to try and extrapolate a similar method in Calc to no
> avail.
>
> Have done a limited amount of searching in Andrew Pitonyak's OpenOffice.org
> Macros Explained book and searched through OASIS Open Document Format
> documents using terms like "filter" and "range". The answer might have been
> staring me in the face, I'm thinking in particular of section 15.6.3 of
> Andrew Pitonyak's OpenOffice.org Macros Explained, but I just didn't
> understand it.
>
> Can anyone provide guidance to display the autofilter values in a Calc
> sheet equivalent to the instructions provided for Excel at the link above?
>
> Thank you.
>
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Calc how to display Autofilter values? Not answered, maybe insight from Excel elicits answer

[Alan B]

Many moons ago I was using some Calc sheets with AutoFilter routinely. The
filter value would be changed, the sheet closed and sometime later opened
again.

To understand the displayed rows the filter values needed to be known. And
that involved opening each filter and checking the value.

So I asked, is there a way to display those values? No answers. And the
need went away.

Just recently had the same need in Excel. Found online the exact answer
needed to make it work.
https://www.extendoffice.com/documents/excel/1444-excel-display-show-filter-criteria.html
The section "Display / Show auto filter criteria in worksheet with VBA
code" is what I referenced.

I've used that info to try and extrapolate a similar method in Calc to no
avail.

Have done a limited amount of searching in Andrew Pitonyak's OpenOffice.org
Macros Explained book and searched through OASIS Open Document Format
documents using terms like "filter" and "range". The answer might have been
staring me in the face, I'm thinking in particular of section 15.6.3 of
Andrew Pitonyak's OpenOffice.org Macros Explained, but I just didn't
understand it.

Can anyone provide guidance to display the autofilter values in a Calc
sheet equivalent to the instructions provided for Excel at the link above?

Thank you.

-- 
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] Write Closed but Windows 10 won't provide safe to remove flash drive

[Alan B]

When Windows displays that programs need to be closed, does it display any
of the program name(s)?

If yes, what is the name or what are some names? (If Paul's response fixed
it, never mind.)

On Sat, Mar 6, 2021 at 4:38 PM charles meyer  wrote:

> This is both a Writer question and a Windows 10 issue.
>
> I close Libre Writer and all the other  programs I had  opened but when I
> click the flash drive icon in the "system tray" (lower right) to receive
> the Safely remove the flash drive it keeps displaying  that I need to close
> programs.
>
> I've check each program along the toolbar (on the bottom) and none are open
> but it still won't give the OK to pull the flash drive out.
>
> I've Googled this and reads both that you can just pull the flash drive out
> as its plug and play and others say the flash drive will stop working oif
> you keep pulling it out with the "Safe to Remove" message.
>
> Your thoughts and suggestions are greatly appreciated.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Scrolling too fast

[Alan B]

Mouse scroll settings are controlled by one or both of the mouse program,
e.g. Logitech programs for their mouse, and the operating system's
settings. Libreoffice's mouse settings control mouse position and the
effect of clicking the middle button, if present. They don't affect scroll
speed.

On Thu, Feb 25, 2021 at 4:27 AM Maria Karlsson  wrote:

> Hello!
>
> I really am enjoying this program so far. I am wondering though, is there
> a way to change the speed of the scrolling? I think it is too fast for me.
>
> Thank you in advance //M
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Reducing extra space in a jpg scanned in Writer

[Alan B]

Your call, "quick/easy"
Open Draw
Drag image onto page
Click the image
From menu Format > Image > Crop
Drag crop handles to desired position
Press Enter to complete crop
Right-click image, select Save...
Click Yes
Provide file name
Change format (defaults to PNG) to JPEG if wish to keep same format (bottom
right of save dialog)
Click Save
Adjust JPG options if desired
Click OK - new file has been saved in location and with name you just
specified
Close Draw
Click "Don't Save"

On Mon, Feb 22, 2021 at 4:34 PM charles meyer 
wrote:

> Hi my esteemed listmates,
>
>
>
> I scanned both sides of a business card as separate jpgs.
>
>
>
> I opened each jpg (one jpg for each side) and there’s a lot of extra white
> space.
>
>
>
> Is there a quick/easy way to eliminate all that wasted white space around
> the business card?
>
>
>
> Advantage Libre Writer: I can open the 2 jpgs (front and back of the
> business card) in Writer and even copy the back side (jpg #2) into the jpg
> #1 (front side of the card) but neither will open in MS Word 365 like some
> jpgs do.
>
>
>
> Thank you.
>
>
> Charles.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Lost files

[Alan B]

Nick,

LibreOffice would not have deleted any document, spreadsheet, etc files
that you created. There aren't even options on the menus to perform those
actions. Same for the LibreOffice installer, if a new version was recently
installed.

I have read recently of some Microsoft Windows updates causing loss of data.

My guess would be one of the following caused file deletion:
- a faulty Windows update
- someone inadvertently or purposefully deleting files

If you have backups my recommendation is restore from backup.
If no backup and you're using Windows
* check the Trash to see if the files are there. If found recover from Trash
* try a file recovery tool, i.e. Windows File Recovery,
https://www.microsoft.com/en-us/p/windows-file-recovery/9n26s50ln705?activetab=pivot:overviewtab,
from Microsoft. Other tools from other vendors are available

On Thu, Feb 18, 2021 at 6:41 AM nickv  wrote:

> I have been using Libreoffice for a number of years with good success and
> have created many files.
>
> Today many off those files are missing/lost and no longer show on my
> computer.
>
> Multipule files were saved in folders now some of those folders are now
> empty other folders have some files missing.
>
> I see online others have had the same experance.
>
> Please advise if these files can be recovered and why would they be
> deleted.
>
> Nick
>
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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: Fit last column in spreadsheet to print

[Alan B]

Hi Charles,

Your initial question was "...see how I cna fit the last column in to print
on  8/12 x 11..." which to me is equivalent to "fit all columns on a single
sheet". So the answer is to set the page width of the printout to one sheet
wide.

Not sure what to say to your follow up, "...I have no idea what I would set
the “Width in pages” to fir this spreadsheet...", because width will ALWAYS
BE set to one sheet if you want the printout to fit across one sheet. If it
has many rows then be sure to set the #of pages high by a number that will
fit everything. If set to 100 the output won't be stretched to be 100 pages
tall.

And you hit on the real trick, "...with all columns across the same page
and also in readable print..." Readable print depends on the number of
columns and the width of the sheet.

If the print isn't legible, try printing the sheet landscape. Now there's
immediately 2½" more paper to scale your columns across. If the print is
still too small then try landscape on a legal page or reduce the number of
columns that need to be seen or both.

p.s. moved back to the list. meant to reply there the first time

On Mon, Jan 4, 2021 at 2:52 PM charles meyer  wrote:

> Hi Alan,
>
>
>
> I hope you’re enjoying a good new year.
>
>
>
> In Calc, I opened the spreadsheet and then held d own the mouse to
> highlight all the columns and rows of content to print.
>
>
>
> I then selected Format > Page and the Sheet tab and selected “Fit print
> range wit width/height” but I have no idea what I would set the “Width in
> pages” to fir this spreadsheet both with all columns across the same page
> and also in readable print.
>
>
>
> I tried this in Excel and I can either get all the columns across the page
> on one page but in tiny print or I can cat the font size in readable size
> but not all the columns align across the one page.
>
>
>
> Any further thoughts re: the “Width in pages” to be set to in Calc?
>
>
>
> I can’t even see how many pages this spread sheet is on as unlike Libre
> Writer or Word there is no page indicator in either Calc or Excel.
>
>
>
> Thank you.
>
>
>
> Charles.
>
>
>
> From: Alan B 
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer 
>
> Charles,
>
>
>
> Both LibreOffice Calc and Microsoft Excel include a print feature to scale
> the print range by width and height. The width and height unit used is
> number of pages.
>
>
>
> From your question I expect you want the printout to be one page wide.
>
>
>
> In Calc, select the print range then the menu Format > Page Select the
> Sheet tab and for scaling mode select "Fit print range(s) to width/height"
> and then specify the desired "Width in pages:".
>
>
>
> Same for Excel though I'm sure the menu path would be different.
>
>
>
> On Tue, Dec 22, 2020 at 1:49 PM charles meyer 
> wrote:
>
> Hi all,
>
> Woulds anyone please be willing to look at my spreadsheet file to see how I
> cna fit the last column  in to print on  8/12 x 11.
>
> It's in Excel.
>
> Maybe Calc would do better?
>
> Thank you.
>
> --
> 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
>
>
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>
>
> -- Forwarded message -
> From: Alan B 
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer 
>
>
> Charles,
>
> Both LibreOffice Calc and Microsoft Excel include a print feature to scale
> the print range by width and height. The width and height unit used is
> number of pages.
>
> From your question I expect you want the printout to be one page wide.
>
> In Calc, select the print range then the menu Format > Page Select the
> Sheet tab and for scaling mode select "Fit print range(s) to width/height"
> and then specify the desired "Width in pages:".
>
> Same for Excel though I'm sure the menu path would be different.
>
>
> On Tue, Dec 22, 2020 at 1:49 PM charles meyer 
> wrote:
>
>> Hi all,
>>
>> Woulds anyone please be willing to look at my spreadsheet file to see how
>> I
>> cna fit the last column  in to print on  8/12 x 11.
>>
>> It's i

Re: [libreoffice-users] Question on value comand and Err:502

[Alan B]

Haven't found documentation to confirm but I believe your first example
=value(1+1) is recognized as a formula, the formula is processed and the
result converted to a value.

It works for me if I enter =value(sum(1,1)) the cell displays 2 and
=CELL("type",), pointed at that cell, displays v

If I format a cell as text, enter a decimal digit, e.g. 2, and point
value() at that cell it returns the number 2.

If i point cell("type",) at the cell containing digits that are
formatted as text the result is "l" (lower case L).

If I point cell("type",) at the value() formula that points at the
text formatted digits it returns v.

So, I would say that value() converts a number formatted as text to a
value, converts a formula that results in a number to a value, but will not
recognize a formula written as a text string and convert the string to
produce the value.

On Mon, Nov 23, 2020 at 11:50 PM Michael D. Setzer II 
wrote:

> Put a more complex question, and got no responses yet.
> So, here it is in simplest form
> =value(1+1)  converts the 1+1 to 2
> But =value( ) fails with Err:502 is text "1+1" is used or i a cell
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a text
> string to a value? Is there another command, or am I doing something
> wrong?
>
> Contents of a simple spreadsheet
>
> 2   "=value(1+1)
> Err:502 "=VALUE("1+1")
> "1+1TRUE=ISTEXT(A3)
> Err:502 "=value(a3)
>
>
> ++
>  Michael D. Setzer II - Computer Science Instructor (Retired)
>  mailto:mi...@guam.net
>  mailto:msetze...@gmail.com
>  Guam - Where America's Day Begins
>  G4L Disk Imaging Project maintainer
>  http://sourceforge.net/projects/g4l/
> ++
>
>
>
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] use calc 7 IF command to change some column values?

[Alan B]

a correction to my message

This statement
puts the A column value in the corresponding row in column B if that value
is less than 28, otherwise it puts 0 in the column B row.

Should instead read as follows
puts the A column value in the corresponding row in column B if that value
is less than 29, otherwise it puts 0 in the column B row.

or, to state it the way the formula is written
puts 0 in the corresponding row in column B if the value in column A is
greater than 28, otherwise it puts the A row value in the corresponding B
row.

On Tue, Oct 20, 2020 at 7:03 AM Alan B  wrote:

> Dave,
>
> Not sure I'm following your intention but...
>
> This formula:
> {=IF(A1:A13>28,0,A1:A13)}
>
> puts the A column value in the corresponding row in column B if that value
> is less than 28, otherwise it puts 0 in the column B row.
>
> Note the curly braces surrounding the formula. These cannot be typed in.
> The formula will not work if they are. To enter this formula, type it in
> without the curly braces and then use Ctrl+Shift+Enter to complete the
> formula.
>
> Ctrl+Shift+Enter are the magic keys to create an array formula. Once
> formula entry is completed with those keys you will see the formula has the
> curly braces, values in A*n* will be in B*n* if they are less than 28,
> otherwise 0 will appear in B*n*.
>
> On Mon, Oct 19, 2020 at 11:07 PM Dave Stevens  wrote:
>
>> I have a column of 365 daily values, non-negative integers, (for a
>> calendar year)
>>
>> I want a columns (column 2) just like that but with some cells (start
>> and end row specified) to be zeroed if they are too large.
>>
>> so...
>>
>> 1   1
>> 3   3
>> 21  21
>> 29  0
>> 22  22
>> 0   0
>>
>> All values in column 1 to be copied to column 2 and if
>> greater than 28 replaced by zero.
>>
>> The help page gives a highly relevant IF function example that almost
>> works. I just don't see how to write the value of the column 1 contents
>> rather than the cell reference. The modified example is
>> '=IF(A1:A13>28,0,"too small")'
>>
>>
>> at first I tried changing "too small" to A1 but I get "A1" in
>> column 2 rather than a value.
>>
>> I don't see the syntax to get column 1's value rather than its
>> reference.
>>
>> Anyone?
>>
>> Dave
>>
>>
>> --
>> 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
>>
>>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] use calc 7 IF command to change some column values?

[Alan B]

Dave,

Not sure I'm following your intention but...

This formula:
{=IF(A1:A13>28,0,A1:A13)}

puts the A column value in the corresponding row in column B if that value
is less than 28, otherwise it puts 0 in the column B row.

Note the curly braces surrounding the formula. These cannot be typed in.
The formula will not work if they are. To enter this formula, type it in
without the curly braces and then use Ctrl+Shift+Enter to complete the
formula.

Ctrl+Shift+Enter are the magic keys to create an array formula. Once
formula entry is completed with those keys you will see the formula has the
curly braces, values in A*n* will be in B*n* if they are less than 28,
otherwise 0 will appear in B*n*.

On Mon, Oct 19, 2020 at 11:07 PM Dave Stevens  wrote:

> I have a column of 365 daily values, non-negative integers, (for a
> calendar year)
>
> I want a columns (column 2) just like that but with some cells (start
> and end row specified) to be zeroed if they are too large.
>
> so...
>
> 1   1
> 3   3
> 21  21
> 29  0
> 22  22
> 0   0
>
> All values in column 1 to be copied to column 2 and if
> greater than 28 replaced by zero.
>
> The help page gives a highly relevant IF function example that almost
> works. I just don't see how to write the value of the column 1 contents
> rather than the cell reference. The modified example is
> '=IF(A1:A13>28,0,"too small")'
>
>
> at first I tried changing "too small" to A1 but I get "A1" in
> column 2 rather than a value.
>
> I don't see the syntax to get column 1's value rather than its
> reference.
>
> Anyone?
>
> Dave
>
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Printing Many Columns

[Alan B]

Charles,

Calc or Excel will handle that.

If all columns are not printed there are a number of possible reasons. Two
I can think of:

* the print range does not include all columns
* the print range does include all columns BUT is not scaled to fit all
columns on a single sheet AND additional sheets that would show the
additional columns are not included in the "pages to print".

If the above does not trigger an idea that helps you resolve the problem
would you provide some more specific information about the process you
follow to print the sheet and the output that is produced?

Thank you.


On Sat, Oct 17, 2020 at 11:55 AM charles meyer 
wrote:

> As computer end-users, we're often confronted with which software tool is
> best for a certain task.
>
> I'm at that juncture again.
>
> I have a heading for each column from A - J and thought Calc or Excel would
> handle that.
>
> But, when I print that file in Calc or Excel it doesn't print all the
> columns.
>
> It was then suggested I try Word Tables (Writer equivalent?) but then I
> read Word Tables would be no better an accommodator.
>
> Would Libre Writer be a better choice?
>
> I'm not expert using Libre Writer (Tables?)
>
> Thank you.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Calc: how do I?

[Alan B]

Hello Dan,

As far as I know, each table needs to be opened separately. That will open
a separate Calc window with a tab for the table that was opened. The tabs
can then be moved into a single spreadsheet by right-click the tab in one
of the spreadsheets and selecting the "Move or Copy Sheet..." option.

Alternately the first dbf can be opened then each additional table can be
opened in a new tab using the menu path Sheet>Insert Sheet from File...
This 2nd option saves the step of grouping the sheets into a single
spreadsheet after opening each file into its own spreadsheet.

I do not know of a way for Calc to open all tables in a database into
individual tabs in a single spreadsheet.

I did use dBASE for many years. My recollection is that a "database" was a
logical construct in dBASE. By default it would include all tables in the
database's directory and tables in other directories could be included by
pointers to their location.

There is no option I can find in Calc to read the database file so it can't
open and read all tables in a database by selecting and opening the
database. Each table must be opened individually.

On Wed, Sep 16, 2020 at 10:31 AM Dan Lewis  wrote:

> I have a dBase database with several tables. How do I open this database
> in Calc so that each table will have its own sheet?
>
> Dan
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Copying data from Calc to Base...

[Alan B]

Hello Zed,

I haven't used 6.4 much yet except with already existing databases. With
6.0 (on Ubuntu) it was required that there be an auto incrementing index
field or the import would fail with messages like you describe.

If your ID field is not set to auto increment modify the field property so
it auto increments then try the import again.

On Wed, Jul 22, 2020 at 11:35 PM zed  wrote:

> Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate
> I am trying to copy and paste a LibreOffice Calc file from that program
> to Base.  Here is what I have done so far.
>
> Calc - created spreadsheet
> A = ID (Default format)
> B = Name (Default format)
> C = Location (Default format)
> D = Date - First (Format as DD MMM )
> E = Date - Last (Format as DD MMM )
>
> Base:
> Created a database named Reactors and created fields:
> ID Interger [INTEGER]
> Name   Text [VARCHAR]
> Location Text [VARCHAR]
> Gender Text [VARCHAR]
> No. Number [NUMERIC]
> Date - First Date [DATE]
> Date - Last Date [DATE]
>
> Opened spreadsheet and highlighted columns  (as listed above)
> (as a test I chose only Rows 1-6)
>
> Chose Copy and navigated to Database and clicked to Paste
>
>  From Menu presented, chose Append data (the default option)
> clicked Next and unticked ID
> clicked Create and following error message was displayed
>
> Warning.  Wrong data type:java.lang.IllegalArgumentException.
>
> Searched both Internet (in general) and LibreOffice website (in
> particular) but found nothing to help.
>
> Obviously I am doing something wrong but I am unable to find the
> error.All help will be very welcome.
>
> Zed
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] version control of sorts: it is gone?

[Alan B]

Hello Uwe,

I'm using LibreOffice version 6.0.7.3.

"Version..." is the ninth item on the "File" menu.

I've done no menu customizations.

On Wed, Jul 22, 2020 at 3:27 AM Uwe Brauer  wrote:

>
>
> Hi
>
> I swear I have seen a  version control of sorts[1], maybe back in the old
> days of openoffice. You could manually set versions which tend increased
> the size of the file quite a bit because new versions were saved on top
> of old ones.
>
> I cannot find this feature anymore. Is it gone?
>
> Regards
>
> Uwe Brauer
>
> Footnotes:
> [1]  or sort of version control if you prefer.
>
>
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Printing 18 labels per sheet on Avery A4 sheet L7161

[Alan B]

Hello John,

re: [2] same label for all labels on page with other than the default
formatting applied to all labels

#1 File > New > Labels
#2 Labels dialog, Labels tab --
  -- Label text field : enter desired label text
  -- Brand: Avery A4, Type: L7161 Address
#3 Click "New Document" button, label text field is repeated for all labels
on page
#4 Right-click in text of first label, select Styles > Edit Style...
#5 modify style as desired and click "Apply" button

All labels now have the same style applied to the text.

Is that what you are trying to do?




On Mon, Jun 8, 2020 at 5:13 PM John Kaufmann  wrote:

> On 2020-06-08 11:54, Budge wrote:
> > Two questions please.
> >
> > [1] I am using Avery A4 L7161 adhesive labels and have opened using the
> new>label option which gives me the grid in which to type the text.  Having
> selected font and size I find the print is too close to the edge of the
> label.  How may I adjust the margin between the first line of text and the
> actual label edge.  I think the word is kerning and I need to move the text
> a fraction of the line down on the paper?
>
> On the Labels Format tab, can you not just increase the Top margin by,
> say, a millimeter?
> [BTW: I don't think the word you want is kerning, which refers to a
> spacing relationship between characters.]
>
>
> > [2] Once I have typed one label and edited it to suit, is there a quick
> way to copy the one label to all the labels on the the whole sheet?
>
> I don't know how easily that is done with LO's Labels function, which is
> optimized for merging addresses from a database.  Probably someone who uses
> labels a lot can chime in on that, but I would probably be inclined to just
> format a page with margins of 7.2mm (L/R) and 8.8mm(T/B) and then make a
> 3col x 6 row table full-width (66.0mm columns), with row heights 46.5mm.
> That would give you easy access to all labels as table cells, so you could
> just copy-and-paste quickly.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Problem with print dialogue

[Alan B]

I'm not sure if there is any fix for size of the dialog. Other respondents
have already indicated there is a bug report for the issue.

The minimum recommended screen resolution is 1024x768. If your screen
resolution is below this, resolution may be the problem.
https://www.libreoffice.org/get-help/system-requirements/

Presuming you are using Ubntu then a workaround to move the dialog so the
OK button is visible, hold down the SuperKey (Windows key) and then click
and hold anywhere on the dialog to drag it to a position where the OK
button is accessible.

This technique can be used *anywhere* on a window to drag it to a new
location. It really is convenient. Sometimes I use it just to save a bit of
time arranging windows since I don't have to get the mouse on the title bar
to drag a window and can just move them starting with the mouse wherever it
happens to be.

On Tue, Apr 7, 2020 at 10:04 PM John Sweeney 
wrote:

> I have this version of libre office: Build ID: 1:6.4.2-0ubuntu0.18.04.3
>
> I cannot see the OK button on the print dialgoue because the dialogue is
> too big for my screen and there is no scroll bar nor can i change the
> dialogue's size. It is very frustrating.
>
> Can anyone help?
>
> Thanks,
>
> John Sweeney
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] cannot find and replace paragraph break in writer

[Alan B]

Try using $ as your search term with the regular expression box checked.

When I use \n to search it finds the ends of lines created with Shift+Enter.

When I use $ to search it finds the ends of lines created with Enter.

LibreOffice 6.3.5.2 on Ubuntu 19.04

On Thu, Mar 26, 2020 at 2:03 PM procuste piziocampte 
wrote:

> Im' using Version: 6.4.1.1 on linux opensuse:
> In a writer document I woule like to find paragraph breaks  (A paragraph
> break that can be entered with the Enter or Return key )with a tab
> so following the instructions here
>
> file:///usr/lib64/libreoffice/help/en-US/text/shared/01/0211.html?=WRITER=UNIX
> I should perform a find/replace:
> in find \n and in replace \t
> or if it doesnt works
> in find \n and in replace \n and then in find \n and in replace \t
> checking the regular expression box (only that one)
> but it doesn't work, writer gives me the "search key not found"
> how can I solve??
> manythanks
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Using Libre Writer - with hardware questions

[Alan B]

More information please.

What issues are you experiencing? What make and model laptop?

On Fri, Jan 24, 2020 at 3:11 PM charles meyer 
wrote:

> I like using Libre Writer but have been confounded with a hardware issue
> with my laptop.
>
> Would anyone please suggest a knowledgeable forum where I could post what's
> happening with my laptop to troubleshoot so I can get it stabilized to use
> Libre Writer?
>
> Tom's Hardware has been disappointing.
>
> Thank you.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] filter bank transactions and then sum

[Alan B]

Meant this to go to the list as well (accidentally sent only to Jame on
first reply)...

Expanding on Regina's answer... I routinely use subtotal as she suggests. I
insert a row above the rows of interest then put the subtotal formula above
the column that I want to count or sum.

Set the formula range from the first to last row, not including column
title.

To sum the displayed figures the 1st parameter of the function should be
109, to count the rows displayed the value should be 103.

Turn on Autofilter then filter as desired. The formula updates dynamically
as the displayed rows change.

The formula to sum displayed rows would be =subtotal(109,)
Replace  with the correct value, e.g. A2:A25

On Mon, Jan 13, 2020 at 6:13 PM James  wrote:

> I've got a spreadsheet of all my bank transactions and I want to filter
> them by type and them the results.
>
> eg.
> Tran Type Amount
> 1 A   1.5
> 2 B   2.0
> 3 A   3.5
>
> I can use Data/More Filters/Standard Filer to get:
> Tran Type Amount
> 1 A   1.5
> 3 A   3.5
>
> but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet.
>
> I can copy but filtered rows but that is too easy. :-)
> What is the hardest overkill way? :-)
> Maybe a template or macro that I can reuse.
> I just want to filter them so I can add up the interest I got.
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] full date string to date

[Alan B]

James,

The only way I could get the text sample you provided to be accepted as a
date was to leave the day name off. Typing Wed, Jan 2, 2020 into a cell
resulted in a cell that contained text. Typing Jan 2, 2020 into a cell
resulted in a cell that contained a date in the default date format,
mm/dd/yy. That could then be formatted to NN, MMM D,  and display as
Wed, Jan 2, 2020.

The DATEVALUE() function will convert the string Jan 2, 2020 to a date. It
returns Err:502 when pointed at the string Wed, Jan 2, 2020.

My suggestion would be to input the substring Jan 2, 2020 into the
DATEVALUE function then format as desired to get your dates back.

e.g. =DATEVALUE(MID(A1,6,20))

On Mon, Dec 30, 2019 at 2:55 PM James  wrote:

> I had a spreadsheet with dates that I think somehow got converted to text.
> I tried pasting it as plain text with detecting special numbers and I
> tried setting the column to a date format but it still seems to come out
> as text.
>
> 'Wed, Jan 2, 2020'
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] LibreOffice Calc - Date - increase number times...

[Alan B]

David,

A follow up to my first reply. I wanted to investigate a bit more to see if
I could produce a macro that actually incremented values in column B based
on the corresponding cell in column D being changed.

This works for me incrementing the value in col B by +1 when the value in
column D on the same row is changed. Please note, it only works for the
first sheet of the workbook. I expect it could be made to work for the
current sheet but have not investigated how to do that. Changing the order
of the workbook tabs has no effect on which tab is recognized as the first
one. In addition to the reference I named in my first post the information
from this second reference was instrumental in making a macro that only
responded to changes in cells in column D.
https://docs.oracle.com/cd/E19064-01/so6/817-1826-10/817-1826-10.pdf pg. 119

and the macro...
Sub SheetChange(oEvent)

Dim rowNum, colNum as Integer
Dim oDoc, oSheet, oCell as Object

oDoc = StarDesktop.CurrentComponent
oSheet = oDoc.Sheets(0)

if oEvent.CellAddress.Column = 3 then
  colNum = oEvent.CellAddress.Column
 rowNum = oEvent.CellAddress.Row
 oCell = oSheet.getCellByPosition(colNum - 2, rowNum)
 oCell.Value = oCell.Value + 1
EndIf

End Sub

On Tue, Dec 10, 2019 at 11:50 PM zed  wrote:

> Hi!
>
> Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
>
> I have a spreadsheeet in Calc which records data of reactions to a
> particular performer.  It is in the form: It has Columns A - G.
>
> A - Name, fformatted as Text (records thre name of the persons doing the
> reaction)
> B - No, formatted number general (records number of times this
> reactors has reacted to the performer)
> C - First, formatted DD/MM/YY (records the first date the reactor reaacted
> to this performer)
> D - Last, formatted DD/MM.YY (records last date reactor reacted to this
> performer)
> E  - Days, formatted =NOW()-D3 (records number of days since last reaction)
> F - Weeks, formatted =E3/7 (records number of weeks since last reaction)
> G - Months, formatted =F3/4 (records number of months since last reaction.
> reaction)
>
> Is there a formula that I can enter in Column B which will increase
> incrementally increase the figure by 1, please?
>
> Regards from New Zealand on a very warm summer evening.
>
> David
> --
> Zed
> "To use the term blind faith, is to use an adjective needlessly." Julian
> Ruck
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] LibreOffice Calc - Date - increase number times...

[Alan B]

Hi David,

As I understand it you have values in column B and dates in column D. When
a new date is entered in a cell in column D or an existing date is changed
you want the cell on the corresponding row in column B to increase by 1.

e.g. B1 = 5, D1 = May 5, 2019
change D1 and B1 becomes 6.
- or -
e.g. B3 = 26, D3 = blank
set D3 = Feb 3, 2017 and B3 becomes 27

The root of an answer is here,
https://ask.libreoffice.org/en/question/84677/which-event-macro-on-spreadsheet-contents-change/
Provided by Peter Williams.

The macro sample would need modification but seems to clearly demonstrate
the capability you wish to implement.
Sub SheetChange(oEvent)
MsgBox "Column is " & oEvent.CellAddress.Column
MsgBox "Row is " & oEvent.CellAddress.Row
End Sub

On Thu, Dec 12, 2019 at 2:13 PM Johnny Rosenberg 
wrote:

> Den tors 12 dec. 2019 kl 05:38 skrev zed :
>
> > Brian Barker  wrote:
> >
> > > At 17:49 11/12/2019 +1300, David Noname wrote:
> > > > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted
> > > > number general ...
> > > >
> > > > Is there a formula that I can enter in Column B which will increase
> > > > incrementally increase the figure by 1, please?
> > >
> > > I think you are saying that you want values in column B to be one
> greater
> > > than they are. That's a contradiction. If the value in Bn is four, you
> > > want it to be five. But that means it's no longer four. And if it's now
> > > five, how would any formula know you do not want it to be six? And so
> on?
> >
> > Thank you for your prompt reply, Brian.  It is much appreciated
> >
> > Perhaps I didn't explain myself clearly enough.
> >
> > In simple terms, I want to know whether there is any way that when I
> enter
> > a
> > new date in Column D it will automaticall increase the current value in
> > Column B by 1.  I cannot think of a solution - but then I only use Calc
> for
> > simple things - but was hoping that there is a solution.  If there
> isn't, I
> > will just have to try and remember to manually increase the value of
> Column
> > B every time I enter a new date in Column D.
> >
>
> Can you explain it again, but this time also mention rows?
> Do you mean that a certain cell in column B, say B1, should increase its
> value when you enter a new date in a previously empty cell in column D? Is
> that cell always direclty below the last used row?
>
> Do you mean that when you enter a date in the D column, the cell at the
> same row in column B should be the cell above it + 1?
>
>
>
> >
> > David
> > --
> > Zed
> > Smoking kills. If you're killed, you've lost a very important part of
> your
> > life.
> >
> > --
> > 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Can't open LO Base file

[Alan B]

Great news!

Now if you would  like to get back opening the files by double-click then
(on Windows 10) do the following:

- find the file the same way you do to get the message about file:///...
- RIGHT-click the file
- click the "Properties" option at/near the bottom of the menu
- click the "Change..." button that is to the right of "Opens with:"
- click the program, Base, that you will use to open the file
  + if Base isn't an option click the "More apps ↓" link to display more
programs to open the file
  + if Base still isn't in the list then install LibreOffice again
- click the "OK" button
- click the "OK" button

Now double-click the file and it should open in Base

If you're not using Windows 10 the process will be similar whatever
operating system you're using, earlier Windows versions, Mac OS, Linux.
Select the file, show its properties menu, select the menu option for what
program opens the file, select the program to use.


On Fri, Nov 22, 2019 at 10:55 PM Howard Barr  wrote:

> Alan,
>
> Thank you.
>
> Yes, you are right, I was double-clicking on the file.
>
> Your suggestion worked.
>
> Thanks for your help.
>
> Problem solved.
>
> Howard
>
> On Sat, 23 Nov 2019 at 10:11, Alan B  wrote:
>
>> Howard -
>>
>> I'm thinking you're finding the file and double-clicking it to open it in
>> Base? If so the fact that the file name starts with file:///... and the
>> message is the file can't be loaded, NOT it can't be found, has me thinking
>> the file association is changed. If the file association has changed then
>> the message makes sense if you're double-clicking the file to open it .
>>
>> Have you tried:
>> - Open Base
>> - select the option to "Open an existing database file" in the Database
>> Wizard
>> - click the "Open" button
>> - navigate to the file
>> - select it and
>> - click the "Open" button?
>>
>> If opening Base then using Base to open the file works then the problem
>> is likely a wrong file association.
>>
>> On Fri, Nov 22, 2019 at 7:30 PM Howard Barr 
>> wrote:
>>
>>> Hello List members.
>>>
>>> I recently imported files from my old laptop and cannot open LO Base
>>> files.
>>> The error message is:
>>>
>>> > The connection to the data source "My Database" could not be
>>> established.
>>> > The file file:///home/username/filename could not be loaded.
>>> >
>>>
>>> I have moved "My Database" file onto the computer I am now using. Maybe
>>> the
>>> link has broken.
>>> How can I open and read/write to this file?
>>>
>>> All advice appreciated.
>>>
>>> Howard
>>>
>>> --
>>> 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
>>>
>>
>>
>> --
>> Alan Boba
>> CISSP, CCENT, ITIL v3 Foundations 2011
>>
>>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Can't open LO Base file

[Alan B]

Howard -

I'm thinking you're finding the file and double-clicking it to open it in
Base? If so the fact that the file name starts with file:///... and the
message is the file can't be loaded, NOT it can't be found, has me thinking
the file association is changed. If the file association has changed then
the message makes sense if you're double-clicking the file to open it .

Have you tried:
- Open Base
- select the option to "Open an existing database file" in the Database
Wizard
- click the "Open" button
- navigate to the file
- select it and
- click the "Open" button?

If opening Base then using Base to open the file works then the problem is
likely a wrong file association.

On Fri, Nov 22, 2019 at 7:30 PM Howard Barr  wrote:

> Hello List members.
>
> I recently imported files from my old laptop and cannot open LO Base files.
> The error message is:
>
> > The connection to the data source "My Database" could not be established.
> > The file file:///home/username/filename could not be loaded.
> >
>
> I have moved "My Database" file onto the computer I am now using. Maybe the
> link has broken.
> How can I open and read/write to this file?
>
> All advice appreciated.
>
> Howard
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Display criteria currently used in AutoFilter

[Alan B]

When I use AutoFilter on a worksheet I often put a row above the filter to
show how many rows are displayed or some other formula that updates
dynamically as the filter is changed.

It would be helpful at times to display additional information such as the
current filter criteria.

Is there a way to interrogate the AutoFilter for the current criteria?

I have not found a method for this.

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] record durations, not time of day

[Alan B]

If entered just as you've typed, it seems all the formats presume hrs,
minutes, and seconds. Applying the time formats don't cause the display you
wish because the "3" is presumed hours and the "5", minutes.

Enter instead 0:3:5

Then this custom format should do:
MM:SS displays 03:05

Available ready made formats display as follows...
[HH]:MM:SS.00 displays 00:03:05.00
MM:SS.00 displays 03:05.00
[HH]:MM:SS displays 00:03:05
HH:MM:SS displays 00:03:05
HH:MM displays 00:03

On Wed, Jul 31, 2019 at 6:45 PM Eric Beversluis <
ebe...@researchintegration.org> wrote:

> I want to enter numbers in Calc like 3:05 that stands for 3 minutes and 5
> seconds (duration), not for some time of day. How do I do this?
>
> Eric Beversluis
> Short fiction at www.ericbeversluis.com
>
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Inserting a Trademark Symbol in Label

[Alan B]

The following won't help you see/find the symbol. It will however let you
type it directly.

Put your cursor where you want the symbol to appear then

If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) -
Type 2122 then Alt+X

If using Linux -
Ctrl+Shift+U and release, then 2122, then enter

On Tue, Apr 2, 2019 at 6:23 PM Budge  wrote:

> Using Writer with DejaVu Sans font and having created a label using the
> Avery A4 template with Synchronize active, all is well until I try and
> include the Trademark symbol.  The advice I have is:-
>
>  Place the cursor in the location where you want the symbol to appear.
>  On the Insert menu select Special Character.
>  In the dialog that appears, choose Symbol from the Font list.The
> trademark symbol is available in a Serif font (character 212) or in a
> San-Serif font (character 228). ...
>  Click OK.
>
>   My problem is that once I select Special Characters the Font is shown
> and then a huge list of available Subsets and using for example Basic
> Latin, I get a whole lot of characters, all too big and all overlapping
> so even if the TM symbol is there I cannot see it.
>
> I need some guidance please.
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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 display AutoFilter filter criteria?

[Alan B]

When I set up a spreadsheet with AutoFilter I often insert a row at the top
to show how many rows are displayed by the current filter, e.g. ="Rows
displayed - " & SUBTOTAL(103,A3:A2)

Now I'm trying to find a way to display the criteria used by the AutoFilter.

e.g. "Rows displayed - " & SUBTOTAL(103,A3:A2) & " - filter applied:
"

Obviously could use an Advanced Filter and create some formula to produce
the  element above.

Am hoping to find a way to inspect the conditions used in the AutoFilter
and append them to the "Rows displayed..." legend.

Any suggestions?

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Can imported images keep the aspect ratio?

[Alan B]

You haven't indicated which app you're using.

If using Write, maintaining scale while resizing an image is the default
when dragging the handles to resize.  At least in version 5.4.5.1 it is.

On Sat, Mar 10, 2018 at 8:38 AM, Anne Wilson  wrote:

> My 200+ entries can now display the relevant images, but they are scaled
> to fit the available space.  Since the files being read in are cropped
> images, some are portrait mode and some are landscape mode, so there is
> no ideal size for the display.  Is it possible to affect the image, to
> fix it to keep the aspect ratio?
>
> AnneW
>
> --
> 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/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with extra space at bottom of pages.

[Alan B]

Hello Leam,

I suggest try the following...

Open your document then...
Ctrl+A

This will select *everything* in the document

Then right-click to bring up the context menu

Click on the "Paragraph..." option

In the dialog box that appears click the "Text Flow" tab

At the bottom of this tab in the "Options" tic "Do not split paragraph". If
this is not available clear the tics in "Orphan control" and "Window
control". Once that's done it should be possible to tic "Do not split
paragraph".

Now go back through your document with "View > Non-printing characters"
enabled. Delete all the extra paragraphs you've inserted to cause your
paragraphs to display in their entirety on one page.

With "Do not spit paragraph" enabled your paragraphs will not split across
pages.

On Mon, Dec 19, 2016 at 6:51 PM, Leam Hall  wrote:

> I have several multi-page documents that have extra space at the bottom of
> the page. Turning on the "View" -> "Non-printing characters" shows one or
> two paragraph markers and then an inch or more of extra space.
>
> If I go to the last paragraph and hit delete twice it will generally draw
> up the paragraph from the next page. I then hit enter twice and the new
> paragraph stays on the page. Since my paragraphs are short I can do that a
> few times on each page.
>
> This issue is that I'd rather not do that several times on each of a
> hundred or so pages. Is there anything else I can look to check? Using
> LibreOffice 5.2.1.2 on Linux.
>
> Thanks!
>
> Leam
>
>
> --
>  Dec 2016
> I am a professional writer. My writing pleases my Father, encourages
> others, and pays the bills. I work on my craft, content, platform, and
> business. I show up for work every day, meet my goals, and let my Father
> determine success. I am a professional writer.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] how do i Link to External Data?

[Alan B]

On Fri, Mar 11, 2016 at 12:07 PM, Beau Thompson  wrote:

> Hi All,
> I like to use calc to pull data from a web page using Link to External
> Data all videos are old
> thanks for any help


Hi Beau. "Insert > Link to External Data..." works for me. Select this menu
option then enter the URL and press enter. A prompt for character
translation may then appear, if so I just click ok. Then a list of
selections is presented. Experimentation by trying the various selections
leads to the desired data being loaded into Calc

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc as a Flat File Database

[Alan B]

On Tue, Mar 8, 2016 at 8:02 AM, Ian Whitfield 
wrote:

> So I was wondering if there is and Add-On or Extension available to give
> you a "Form" to overlay the Spreadsheet so that you can view the data one
> row at a time??
>

Hello Ian - I don't know the particulars but can say that the Form...
option in the Data menu works for me for a simple test file.

I created a spreadsheet and put column titles in row A then entered several
rows of data. Selecting Data>Form with any cell within the boundaries of
the column labels and data already selected brought up the form.

If the selected cell was outside the range then the form was empty.

There was no need to name the data range. Simply entered column titles and
rows of data and it worked.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Database help please

[Alan B]

On Fri, Mar 4, 2016 at 3:13 PM, John Montgomery  wrote:

> Thank you to everyone who replied to my query, A01, A02 etc works, I am
> very thankful for that. Now the problem to prevent duplication, I have
> tried several ways but obviously what I am doing is incorrect as it doesn't
> work.
>

Hello John. I am thinking that you are seeing duplicate grave numbers? If
this is correct then I suggest creating an index for the grave number
column and selecting the option that the index be unique.

That constraint, unique, will prevent duplicate entries. It will also
prevent successfully creating and saving the index as long as there are
duplicates in the grave number column.

So first make sure there are no duplicate grave numbers in your table (that
includes grave numbers that have not been entered, e.g. blanks). Then
create the grave number index being certain to select the unique property
for the index. Save the change and it will no longer be possible to save a
record with duplicate grave numbers.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Envelopes print in wrong orientation

[Alan B]

On Mon, Dec 14, 2015 at 7:53 AM, Philip Jackson 
wrote:

> When I dropped Windows for linux about 18 months' ago, I moved to
> LibreOffice 4.2.8.2 and saw that LO Writer had inherited the same bug
> from OO.
>
> My case involved a standard size European envelope to suit A4 paper
> folded into a third (two folds on the long side) - approx 22cm x 11cm.
> IIRC, this is the DL envelope in LO and OO.
>
> LibreOffice (and OO) give in this case an unwanted 2" top margin. Your
> workaround to correct paper size, adjust top margin, shift the text
> boxes, is too much hassle if you've lots of envelopes to do.
>

Yes, that workaround is too much if envelopes are routinely being printed.
I did the same thing, create a template for #10 envelopes, when I was on LO
3.x. Even though I wasn't making lots of envelopes I seem to recall it was
even harder to get a properly printed envelope than the steps provided in
my response. Creating a template was the only way to consistently get a
properly printed envelope.

Since I've been on LO 5 I've only printed #10 envelopes using the menu
features (didn't bring the template forward to the new installation) and
haven't encountered any bug. I was surprised to see it rear its head when I
did the testing to reply to Bill's message. Since it's happening to you on
a different size perhaps the bug is a component of the envelope size or
maybe the printer setting or a combination.

Regardless, yes it is a very frustrating bug to deal with If I was a
programmer I certainly would try and resolve that one. But I'm not. So
can't do more than identify, develop workarounds, and hope for it to go
away.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Envelopes print in wrong orientation

[Alan B]

On Sun, Dec 13, 2015 at 7:17 PM,  wrote:

> Im try to print 6x8 envelopes. The text prints perpendicular
> to the
> long edge instead of paralleled to it no matter what format I select in
> the Insert Envelope wizard. I cant figure out what Im doing
> wrong.
>
What version of LO, what operating system, what printer?

I just successfully printed a 6x9 as follows
1. open LO 50.2.2
2. select from menu "Insert | Envelope..."
3. on Envelope dialog
3.1. Envelope tab, enter addressee and sender
3.2. Format tab, select size User Defined, set Width 9", Height 6"
3.3. Set Addressee position, from left 4.5", from top 3"
3.4. Set Sender position, from left 1", from top 1"
3.5. Printer orientation, print from top, vertical center (am using HP LJ
1000), no change to shift values
4. Click new document
some kind of bug or error, the new document is 9x7.25 (it has a 1.25 inch
top margin for unknown reason)
5. Select "Format | Page" from the menu
6. change height to 6"
7. change top margin to 0"
8. click OK
9. grab each text box, sender and addressee, and move to desired position
(they're too low after removing the margin)
9. Click print

Resulting output is correctly printed envelope.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

[Alan B]

On Sun, Oct 25, 2015 at 4:48 PM, ajebay  wrote:

> I have a calc spreadsheet with many lines of data which include one column
> with names for the line.
> I want to sort the names from A to Z, top to bottom, and have all the
> corresponding data in each line move with the corresponding name.  Hope
> this is clear.
> Is this possible?


I see you've already gotten several helpful replies. Couldn't resist adding
my 2¢. It gives me a chance to share a video I did several years ago to
answer the very same question for my Uncle.

https://youtu.be/RjTgDyNqqQY?list=PLGCG5NYY1-dqMgUQ5E1kAITPfqlHmPJP1

Apologies for the monotone. Riveting narration is not my forte.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Digital signatures

[Alan B]

On Sun, Oct 11, 2015 at 10:14 PM, Евгений  wrote:

> No one here used signatures?
> No one can help or give some advices to resolve problem?
>

Sorry Евгений, I have only used self signed and only a few times.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Show full content of a cell when selected [Calc]

[Alan B]

On Fri, May 15, 2015 at 11:07 AM, Alichino smar...@yahoo.co.uk wrote:

 I have a cell with a large amount of text in it.
 I don't want to Wrap text automatically because that will expand the cell.
 Instead I'd like to keep the cell small, and only expand when it is clicked


I don't know of a way to do that. However, if you desire to read the full
content of the cell, note that when the cell is selected the content is
displayed in the input line.

If the input line isn't long enough, and text is cut off, the input line
can be widened vertically so it will display more text. The shortcoming of
this method is the input line height is not preserved when saving the
spreadsheet. Each spreadsheet in which the wider input line is needed
requires expanding the input line whenever the spreadsheet is opened. It
isn't a solution that is activated as needed or remembered as a property
of the spreadsheet.

Sorry, don't know any other options.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Unzipped opendoc files

[Alan B]

On Tue, May 12, 2015 at 5:43 AM, Michel Kapel mkir...@gmail.com wrote:

 I seem to remember ... a long long time ago.
 It was possible to use an unzipped open-doc file (a directory) as a zipped
 one.
 So it was somehow possible to start-up open/libreoffice using as starting
 point one of the files in the unzipped directory.


The .odt file can be opened with a zip file viewer. Within the .zip file
there will be a file 'content.xml'. That file contains the actual text of
the original document with xml tags.

To reduce it to only the original text with no xml tags would require
stripping the tags. Don't know if there is a tool available to do that.

As for opening 'content.xml' directly in Open/LibreOffice that could be
accomplished by right clicking the 'content.xml' file, selecting the Open
with... option from the context menu and then selecting the desired
application. Remember however the xml tags are included in the document and
will be displayed in the Open/LibreOffice document.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: Re: [libreoffice-users] first step forward

[Alan B]

On Wed, Mar 4, 2015 at 5:49 AM, anddos an...@neostrada.pl wrote:


 I work for medicine, to be precise, as an engineer active in the human
 ecosystem personal care.
 It makes me very satisfied, but I have to deal with quite a range of
 technological problems.
 That, explains maybe that I'd rather try to get help, instead of wasting
 time on my one in case

 I did edit your spreadsheet and put a copy here.

 https://docs.google.com/spreadsheets/d/1xusCFUw5wy62IOcRJTTTfCQxtAcnyccXJuMHUilZ9T8/edit?usp=sharing
 In my copy I've highlighted all the number/value pairs and have some
 questions based on that.

 First, some numbers aren't paired with anything. What do they belong with?
 thay are orfans,  I,ve just did not remark it
 Second, you refer to the values as an array but, given the organization of
 the spreadsheet I don't see any arrays. What arrays are you referring to?
 Cell addresses would be helpful to understand.
 the array was ment as follow:
 There are severall tools, which give their output sequentially in time.
 The output creates an arrey, data are
 placed in rows and columns
 Regarding your question about numbers of rows and columns I believe the
 max number of rows is 1,000,000 and max columns is 1024.
 thank you.
 The question:  till know, I don't realise, it was meant spreadseet or base
 table 1,000,000x1024 ?

Your example was given in a spreadsheet. My answer re: rows and columns was
therefore limits for the spreadsheet.


 Your example for A target shows the one positive value for A in one
 column and the negative values for A in a different column. In the target
 the order of values by row is the same as in the source.
 right, it should rest as in the input array
 Which gets me back to I still don't understand what you need to accomplish.
 I belive now, to be understood, I need to accomlish it as in example for A

 Answers to a few questions may help me:
 - is the goal to rearrange the Raw Alphanumerical so it is organized
 like the target
 yes, separately in files for A, B, C, etc, and additionally, if possible,
 all in columns in one file
 - is there a specific repeatable method for why data is where it is in the
 Raw Alphanumerical and if there is what are the rules? Knowing the rules
 would go a long way to planning how to rearrange Raw into Target
 output of each tool gives specyfic array of data, there are several tools.
 Tools are active in axis of time,
 independently each of other, in a kind of burst of time.

I am still trying to understand the source data. Looking again at the
spreadsheet I wonder does each row represent the same point in time? In
other words, for row 7 events were recorded from source A and B at the same
point in time. For row 9 events were recorded from source B, D and G at the
same point in time.

With this idea as reference my thought is to first organize the input so it
is collected in one of two ways with some similar rules for both methods.
First rule, no empty rows. Second rule, column A should be a time stamp for
when the event happened.
Method1
Column A is time stamp
Column B is A, B, ..., G, etc, a tag to indicate which device
provided the value
Column C is the value provided by the device

In this method Column A may have multiple rows with the same value because
multiple devices may have an event at the same time. Therefore the values
in column A and column B together make each row unique.

The spreadsheet can now be used as the source for a pivot table or database
query that displays the data in your desired format.

Method2
Column A is time stamp
Column B is A, B, ..., G, etc, a tag to indicate which device
provided the value
Column C is the value provided by the device
Column D is A, B, ..., G, etc, a tag to indicate which device
provided the value
Column E is the value provided by the device
Column F repeat pattern above...

This method requires data from each device, the device label and value, go
into specific columns. In other words device A must always put it's values
in columns B and C, device B puts its values in columns D and E, ...,
device G puts its values in columns N and O, etc.

As in the first method each row represents a single point in time

Again the spreadsheet would be used as the source for a pivot table or
database query to display the data.

I think Method1 is the better way to attempt. Devices can be added and
removed without considering what column the data goes in. It will always go
in A, B, and C. Timestamp, Device identifier, Value.




 Allan, sorry for shaggy english from time to time. My brain was created in
 polsh, I have friends and technical
 relations in the world, so I have to deal with english, russian, germen
 and french.
 I believe, my english part of the brain is helpfull enough, to make me be
 understood with a bit of effort of yours.

:-) no worries about your English. I'm jealous of your language skills. I
can only speak English, bad English and a very teeny ting bit of
Vietnamese.

-- 
To unsubscribe 

Re: [libreoffice-users] database2spreadsheet

[Alan B]

On Wed, Mar 4, 2015 at 4:59 AM, hw h...@gartencenter-vaehning.de wrote:

 how would I create a spreadsheet from a table in a database?

 I know I can copy and paste, and I want to avoid that.  Basically, users
 should be able to click an icon in LO (or on their desktop) and be
 presented with a spreadsheet which displays an export from a table I have
 in a mysql database.  Fields in the spreadsheet must be in a different
 order than in the database and be formatted to a pre-defined width.


Hello hw, there was recently conversation on the topic of data export. The
thread is here...
https://listarchives.libreoffice.org/global/users/msg43335.html

There is no icon or menu selection providing access to that feature
however, yes, the export and reordering of columns can be done. It is done
via the SQL command window. The command, using HSQL syntax, is...
SELECT * INTO TEXT exportTable1 FROM Table1

Syntax would need to be modified to mysql equivalent to support the same
action with a mysql source.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] first step forward

[Alan B]

On Tue, Mar 3, 2015 at 8:24 AM, an...@neostrada.pl wrote:

  Thank you, Allan for the prompt reply, ...
 The sample is simply enough, I belive, so the point is how to proceed it
 to get output in several seperate SS or database tables, preserving
 the sequention in row position.


Unfortunately I don't understand your spreadsheet.

I've added the mail list address back to the message. Please reply to mail
list. That way more (and better) brains than mine can then give their
feedback too.

I did edit your spreadsheet and put a copy here.
https://docs.google.com/spreadsheets/d/1xusCFUw5wy62IOcRJTTTfCQxtAcnyccXJuMHUilZ9T8/edit?usp=sharing

In my copy I've highlighted all the number/value pairs and have some
questions based on that.

First, some numbers aren't paired with anything. What do they belong with?
Second, you refer to the values as an array but, given the organization of
the spreadsheet I don't see any arrays. What arrays are you referring to?
Cell addresses would be helpful to understand.

Regarding your question about numbers of rows and columns I believe the max
number of rows is 1,000,000 and max columns is 1024.

Your example for A target shows the one positive value for A in one
column and the negative values for A in a different column. In the target
the order of values by row is the same as in the source.

Which gets me back to I still don't understand what you need to accomplish.

Answers to a few questions may help me:
- is the goal to rearrange the Raw Alphanumerical so it is organized like
the target?
- is there a specific repeatable method for why data is where it is in the
Raw Alphanumerical and if there is what are the rules? Knowing the rules
would go a long way to planning how to rearrange Raw into Target

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Can the most up-to-date LO import and print pdfs?

[Alan B]

On Thu, Feb 26, 2015 at 7:24 AM, Tom Davies tomc...@gmail.com wrote:

 Hi :)
 +1
 I agree that dedicated programs that do 1 single task tend to be better
 for that task.  I seldom have a problem with LO's rendering of Pdfs but
 that could easily just be luck.


Perhaps not so much on luck as on the document itself I think. When I saw
this thread I had just downloaded CW-Business-Planning-eBook-FINAL.pdf from
Connectwise.com. So I opened that file in Draw. It opened fine but every
page rendered incorrectly.

Am using LO Version: 4.2.7.2

As always depends on what's needed. If the op gets good results with their
usual documents no need for change. If not then a solution that fits the
need is required.

Thanks for the +1.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting ranges with merged cells

[Alan B]

On Thu, Feb 26, 2015 at 1:27 AM, Brian Barker b.m.bar...@btinternet.com
wrote:

 At 18:45 25/02/2015 -0500, Alan Bonly wrote:

 On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk wrote:

 «Ranges containing merged cells can only be sorted without formats».
 This message implies that such ranges can be sorted without splitting cells.


 I believe this is a poorly worded information message. I have not found
 any way to sort a range with merged cells including selecting the whole
 range, right-clicking and selecting Clear direct formatting. It seems
 merging of cells is treated as a formatting option, at least in the case of
 this message.


 Well, the message has certainly misled you. You are suggesting here that
 without formats means that you cannot sort cells to which some sort of
 formatting has been applied. But no: that's not what it means.

 When you sort cells generally, the range may have different formatting
 applied to different cells: imagine, for example, that one of the cells has
 a different font colour. Is that colouring associated with the particular
 cell or with the value it contains? It could be either. When you sort the
 values, do you want that colouring to stay in the same cell or to move with
 the value as the range is sorted? That will depend on why you have applied
 that colouring, so you have a choice. This is controlled by Include
 formats on the Options tab of the Sort dialogue. If you have this ticked,
 then formatting moves with the values; otherwise it stays in the same cells.

 You can certainly sort a range that includes merged cells, but you can do
 so only if you leave the formatting where it is, not move it with the
 values. If you try to sort a range including merged cells with the Include
 formats option ticked (which appears to be so by default), you will be
 warned that - although you can sort the range - you can do so only with
 that option deselected.


Thank you Brian, that was new to me. When I did my experiments I tried
several formating options but used the sort button for sorting so never saw
the sort dialog. In the past when I have used the dialog I'm sure I never
took notice of the Include formats selection.

Seems this is an area where the help could be improved. The explanation for
the choice is simply Preserves the current cell formatting. It makes no
mention that any formats are incompatible with sorting or which formats
they may be. Nor does it make clear, at least to me, that the meaning of
Preserves the current cell formatting is that the formating moves with
the value as opposed to the formating stays with the cell.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Large Database

[Alan B]

On Thu, Feb 26, 2015 at 9:06 AM, Patrick pkh5...@comcast.net wrote:

 ok i am hours new to Libreoffice so hopefully i dont sound too off here.so
 i use a large database in access that has several tables that have 80-100k
 lines in them. iam looking for a way to have access to this database while
 i am away from my work computer. i thought i could use base on a thumb


Patrick if your need is to use the data in the tables Base can access it
with an ODBC connection to the Access database.

If you need to use the database program, any forms used to enter/edit data,
or reports to display or print the data, Base cannot use those.

In the first case the following links provide information how to read the
data. Only the first link is specific to LibreOffice Base. The other two
refer to Apache OpenOffice so not all the information there may be
applicable.
https://wiki.documentfoundation.org/Faq/Base/How_to_connect_to_a_Microsoft_Access_database
https://www.openoffice.org/FAQs/ms-access/ms-access.html
https://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access

Another option, if your company allows, would be a remote connection to
your computer get at the database when you're out of the office.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Can the most up-to-date LO import and print pdfs?

[Alan B]

On Wed, Feb 25, 2015 at 10:42 AM, Lisi Reisz lisi.re...@gmail.com wrote:

 Can the most up-to-date LO import and print pdfs?


Lisi - as suggested by V Stuart Foote using LO to print PDF may not provide
the most accurate rendering.

You don't say if you need to edit the documents.

If editing is not needed a dedicated PDF viewer like Adobe Reader or Foxit
PDF Viewer will give you better results.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sortting ranges with merged cells

[Alan B]

On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk lera.goncha...@gmail.com
wrote:

 «Ranges containing merged cells can only be sorted without formats». This
 message implies that such ranges can be sorted without splitting cells.


Lera - I believe this is a poorly worded information message. I have not
found any way to sort a range with merged cells including selecting the
whole range, right-clicking and selecting Clear direct formating.

It seems merging of cells is treated as a formating option, at least in the
case of this message.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: And while I'm here, data extraction

[Alan B]

On Thu, Feb 5, 2015 at 1:40 AM, CA Säger saege...@t-online.de wrote:

 Download this artbitrary database document with an embedded HSQLDB:
  https://forum.openoffice.org/en/forum/download/file.php?id=22304

 Run this:
  SELECT  * INTO TEXT exportTable1 FROM Table1

 which creates exportTable1.csv in the same directory where the document
 lives.


...and it does work. So I tried again on my original database and a few
others.

It worked in my other embeded HSQL databases except for two exceptions...

#1 The database and table I had been trying with from the very beginning.
There it continues to fail. The only distinctive feature of that table is
it was created by importing an Excel spreadsheet.

#2 A table with a blob field failed if I used select *. It did not fail
with that table if I listed fields and did not include the blob field in
the list.

So now I need to create another table by import from Excel. If that table
cannot be exported into text then I suspect the import from Excel is
creating some sort of problem that prevents subsequent select * into text
operations on the table. If I am able to select * into text then time to
go back to the original table and try it field by field to see if one or
several fields are preventing the export.

Anyway, this has been an interesting exercise.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: And while I'm here, data extraction

[Alan B]

On Wed, Feb 4, 2015 at 6:20 PM, Andreas Säger saege...@t-online.de wrote:

 Am 04.02.2015 um 01:26 schrieb Alan B:
  select * into text newfile' from Sheet1;

 Well, it's obvious. Isn't it?


:-) when you put it that way.

Gave me hope for a moment it was my error. Unfortunately I must have made a
typo in my email. I went back with a corrected statement (below is cut and
paste from command window) and got the same error. :-(

select * into text newfile from Sheet1;

1: syntax error, unexpected NAME, expecting ':' or '?' or '['

also tried...
select * into text 'newfile' from 'Sheet1';
select * into text 'newfile' from Sheet1;
select * into text 'newfile' from Sheet1;
select * into text newfile from Sheet1;
select * into text newfile from Sheet1;
select * into text newfile from 'Sheet1';
select * into text newfile from Sheet1;
select * into text newfile from 'Sheet1';
select * into text newfile from Sheet1;

All above are cut and paste from command window. All produced the same
error.

If {into text newfile} is removed and the command
select * from Sheet1;
is run the command succeeds with Sheet1 and Sheet1 but fails with
'Sheet1'.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] And while I'm here, data extraction

[Alan B]

On Tue, Feb 3, 2015 at 6:55 AM, Mark Stanton m...@vowleyfarm.co.uk wrote:

 Having said all of that, is it ideal that the only way to get a data
 output from Base is C'n'P?


No it isn't, not at all. Having used dBase, FoxPro, Paradox and Access and
others I can attest that all had multiple result export methods.

I would appreciate export in Base also. Unfortunately don't have the skill
to code it or the cash to fund development so am left with what is.

After a little bit of digging I did find that HSSQL does offer means to
export data. So it may be possible to use the SQL command line in Base to
perform your exports. I write may because not all commands I've run at
the SQL command line seem to be executed as I would expect.

And this method certainly isn't as trivial as an Export to option in the
UI would be. In any case perhaps this link can help you accomplish your
goal...
http://hsqldb.org/doc/2.0/util-guide/sqltool-chapt.html#sqltool_csv-sect

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Support options

[Alan B]

On Thu, Jan 15, 2015 at 1:07 PM, dave boland dbola...@fastmail.fm wrote:

 What is easy and convenient?  I thought I answered that.  Quick to do,
 no reistration, no passwords, able to see the appends in a thred like


Yes, you did say that before. I'm not familiar with a forum like that (esp
the no registration, no passwords part). The description seemed like a
requirements spec for a product design. I thought you may have specific
forum in mind or examples.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Support options

[Alan B]

On Wed, Jan 14, 2015 at 4:49 PM, dave boland dbola...@fastmail.fm wrote:

 I'm more than a little frustrated/angry at the support options for LO.

 Can't we find a way to offer support that is easy and convenient?  I get


Dave, I think easy and convenient is pretty much in the eye of the
beholder.

Can you say what you feel meets that criteria?

I use the mail list and find it quite satisfactory. Only use the mail list
interactively from my pc. I do browse it on my smartphone and will do
deletions there. Replies are always on the pc.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base Help Anyone

[Alan B]

On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk
wrote:

 I
  have been using Base to provide a database for my paintings via a
 simple form.  I recorded 200 records and then added the facility to
 include a photograph .jpg file and this is when the gremlins started to
 appear.


 It constantly issues error messages when adding data
 and causes me to endlessly loose work as it has failed to write to the
 table from a form for no obvious reason I can see, sometimes I can add a
  new data or several set/records on the form OK and then it will fail
 with the error message as follows where the Table1 is my Table


Hello Alan. I haven't used Base to store binaries however I have monitored
this list for a while and used Base for a few small projects.

I expect the two primary recommendations you will get are...
1. Don't store data in Base, use a separate database back end because the
embedded HSQL is not very stable. To that end I've recently found the
native MySQL connector works well for me (never had reliable connections
with the Java or ODBC connectors).
2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
the table size down, minimizes loss if the db becomes corrupted.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base Help Anyone

[Alan B]

On Tue, Nov 18, 2014 at 8:19 AM, Alan Pedder alanped...@hotmail.co.uk
wrote:







 *Really appreciate your reply but unfortunately a lot of what you wrote is
 a bit over my level of knowledge and whilst I understand the terminology it
 did raise several questions i.e.1. Storing binaries refers to jpg files?2.
 What would a back end database look like? A spreadsheet?3. MySQL is an
 application that would interpret/interact with the database. Hence Libre
 Base would not be involved?4. Are there more stable databases products
 available excluding Access5. I get what you say about pointing to
 jpg/binaries but that is a feature I like about Base and not sure what
 Field Type would do that?*

Hi again Alan.

Sorry to jump in the deep end with my reply. A database is typically used
by a very small number of people compared to word processing, spreadsheet,
etc. As a result I didn't even think about holding back the jargon in my
reply.

Seems a number of people have given answers that should help you on your
way. Regarding your questions here...
1. Yes
2. Yes, that is one way the table can be viewed. Like looking at the table
in your database. Just keep in mind it is not a spread sheet and so even
though it looks similar it does not work the same way.
3. MySQL *is* the database. LibreOffice Base is the program that shows you
the table that is MySQL gives it. Kind of like your web browser lets you
look at web pages. Each web site has its own web server and gives the web
page to your browser to display for you. MySQL is the server and gives the
table to LibreOffice Base to display for you.
4. There may be. I don't know of them. Hopefully other respondents can give
an idea what options there are and how stable they might be. (Presuming you
envision a single product answer where the whole thing can be managed by
a single program as with Base and Access.)
5. Andreas provided that answer. If you missed it he suggests VARCHAR(100).

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Alan B]

On Sat, Nov 15, 2014 at 12:11 PM, Brian Barker b.m.bar...@btinternet.com
wrote:

 At 11:45 15/11/2014 -0500, Alan Bonly wrote:

 Method 2 [Select Format|Paragraph, then the Borders tab, pick a top or
 bottom border, ...] suffers the same disadvantage if the border is
 specified as a bottom border. However if a top border is selected it is not
 applied to the following paragraphs.


 It will be unless Merge with next paragraph is ticked.


I didn't tick anything. Just selected top border and clicked Okay.

Reviewing your comment I find Merge with next paragraph is ticked
already. At least on my system it is a default, Ubuntu 14.04 and LO 4.2.7.2.

Is it not ticked on your system? If so then perhaps there's a bug, or
platform or version difference. I don't generally remark on defaults unless
there's reason to suspect it may be changed.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Writer, how to insert horizontal line

[Alan B]

On Sat, Nov 15, 2014 at 10:57 AM, William Drago wdr...@suffolk.lib.ny.us
wrote:

 I'm trying to insert a horizontal line into my LO document. The help says:

 1. Click in the document where you want to insert the line.
 2. Choose *Insert - Horizontal Rule*
 Well, there's no Horizontal Rule under insert. So how is this done?


You're  right Bill. (At least insofar as LO 4.2 is concerned.)  Though it
works for AOO so seems this is a place where the two have diverged.

In any case to insert a horizontal rule I know of two methods...

1. Type three consecutive dashes --- at the beginning of a line and press
enter.
2. Select Format|Paragraph, then the Borders tab, pick a top or bottom
border, a line style width and color and click OK.

Method 1 has the disadvantage that every subsequent paragraph gets
underlined and so the format must be disabled on subsequent paragraphs.

Method 2 suffers the same disadvantage if the border is specified as a
bottom border. However if a top border is selected it is not applied to the
following paragraphs.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

[Alan B]

On Wed, Oct 1, 2014 at 10:22 PM, Dan Lewis elderdanle...@gmail.com wrote:

   I understand your problem. Accidentally, both links were to the
 same 32 bit connector because I became confused by the naming Nabble used
 for the two files. (I uploaded teh same file twice.)
  Here is the 32 bit connector for others if they want to test it:
 nabble_a href=mysql-connector-x86.oxtmysql-connector-x86.oxt

 Here is the 64 bit connector (which is the one you really needed):

 nabble_a
 href=mysql-connector-x86_64.oxtmysql-connector-x86_64.oxt/nabble_a

  And a very special thanks to you for what you have done.


Hmm... not sure what the thanks are for but, thank you and you're welcome.

And thanks to you. The corrected links enabled me to use the native MySQL
connector. Not like I have a particular need. However databases, the
desktop kind, are one of the things that got me started on an IT career so
I continue to dabble.

I have limited funds to purchase h/w or s/w and as a result the h/w and s/w
I use to experiment is relatively underpowered.

I have a database from the US gov't, npidata freely available, with about
3.5 million rows and around 350 columns. Actually the gov't provides a csv.
Imported it into a MySQL db using the MySQL command line. Never been able
to read the primary table using the Java connector. With the native MySQL
connector I can. At the MySQL command line I can. That alone tells me
something is better.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users]

[Alan B]

On Wed, Jul 30, 2014 at 10:34 PM, Wanda Moore justme...@gmail.com wrote:

 I have tried to email questions, but they have never been responded to.  I
 have been getting everyone else's emails, which is in the hundreds.

 I don't know why I haven't gotten through about my questions . . . .

 Please let me know how I can do this.  Thank you.

 I no longer want to receive everyone else's emails.


Hello Wanda, sorry your questions haven't been getting replies. If you've
been sending your questions to users@global.libreoffice.org they're going
to the right place.

As for everyone else's email... that's the way mailing lists work. You get
all the mail. Your mail program can assist in filtering so it all goes to
some folder other than your inbox but you'll still get all the email.

That said there are some options. Unsubscribe from the list and you won't
get email. Subscribe to the list digest and you'll get one email (not sure
how frequently, daily or weekly) that contains a list of the messages
posted for that period. I believe the email includes links to the messages
so if one is relevant to you click the link and you can read it.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How to ensure all new text entered into a document is different font, without changing the old font settings of the document?

[Alan B]

On Sat, Jun 7, 2014 at 9:54 AM, quickbooks office 
quickbooks.off...@gmail.com wrote:

 How to ensure all new text entered into a document is different font,
 without changing the old font settings of the document?

 That is the document has questions in it, with lets say Times New Roman.

 When I type the answers in, the font remains Times New Roman.

 But I want it so that all new text entered to be Segoe Print without
 changing the font of the text already existing in the document (i.e.
 the questions)


I feel I must be missing something about your question. There are at least
two solutions that occur to me that seem relatively straightforward.

1. Place the cursor at the place you wish to begin typing the answer
2. Before beginning to type the answer change font to Segoe Print by:
 a. selecting Format | Character... from the menu, finding Segoe Print in
the list of Families on the Font tab and clicking ok
 b. or from the tool bar, open the Font Name list and selecting Segoe Print
from the list
3. begin typing

- or -

1. Create a new paragraph style, call it Answers. In the style set the font
to Segoe Print.
2. Place the cursor at the place you wish to begin typing the answer
3. Change the style to Answers and begin typing the answer or type the
answer and set the style to Answers before pressing enter

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Can't get leading zeros in Calc

[Alan B]

On Sat, May 31, 2014 at 7:34 PM, Oogie McGuire oog...@desertweyr.com
wrote:

 I'm tearing my hair out here.

 I have a spreadsheet and the data was originally entered as 4 digits. I
 need to pass it to a database system that requires 6 digits. I've tried
 formatting with 2 leading zeros but I still cannot get the number to
 properly show up as 00number


Oogie are you still thinking of tearing out hair or have you gotten a
solution from the responses so far?

If you're still in the hair tearing stage perhaps you might find the
following useful...

In my experiments copying data from Calc and paste appending to a Base
table:

1. If source data is a number formatted with leading zeros and destination
column is VarChar then leading zeros are preserved

2. If source data is a number formatted with leading zeros and destination
column is Integer then leading zeros are not preserved

3. If source data is text with leading zeros and destination column is
VarChar then leading zeros are preserved

4. If source data is text with leading zeros and destination column is
Integer then leading zeros are not preserved

So experiment 1 and 3 produce the results you want, leading zeros preserved.

If none of the above gets you where you need to be then perhaps you could
provide the following information that should aid in troubleshooting:
1. What database program is the spreadsheet data being loaded into?

2. Are you able to inspect the table structure to see the data type of each
column that you are interested in? If yes, what is the data type of each of
those columns?

3. What is the data type of each of the spreadsheet columns you want to
import?

To see the data type of a value in a cell enter the formula
=CELL(TYPE,address) in a nearby cell. The address should refer to the
cell that needs to be inspected. Is the result of the formula l or v?
The first result is a lower case letter L the second is much more obvious,
a lower case v. address needs to be a cell reference, e.g. B5, not the
literal address that I've written here. The actual formula would look
like =CELL(TYPE,B5) to find out the data type in cell B5. Repeat the
formula for each column that is loaded into the database. Will want to know
what type of data is already in each column.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: [Sclug] (no subject)

[Alan B]

On Sat, May 3, 2014 at 2:38 AM, David Lang da...@lang.hm wrote:

 googling for grub2 windows parition finds several pages that look
 promising

 http://askubuntu.com/questions/110698/add-windows-to-my-boot-menu

 suggests running update-grub and it should detect the windows partition.



 On Fri, 2 May 2014, jelan...@gmail.com wrote:

 Jon upgraded from Kubuntu 13.10 to Kubuntu 14.04. In the process Grub2
 lost his Windows (XP) boot option. Jon is willing to use Linux but not to
 the exclusion of Windows.

 I also upgraded but I think I use legacy Grub as my boot loader. In any
 case I did not lose my Windows (Vista) boot option.


Not sure if this is on target but... I have had dual boot for quite a
while. Windows 7 and whatever is the latest Ubuntu with Ubuntu being the
default boot. The Ubuntu upgrade to 14.04 broke grub so the machine
wouldn't even boot.

After some panic I found some posts that help me develop the following
solution that was quite pain free
https://plus.google.com/10168442054679206/posts/hGPDqdiRFRs

The short of it
- created a bootable SuperGrub disk
- booted my system from it
- use BootRepair to restore the boot options/order

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Getting back to the Start screen

[Alan B]

On Fri, Apr 11, 2014 at 11:29 AM, dollyp da...@lochnevis.com wrote:

 What I am talking about is the start screen that appears when I start LO,
 the one with a graphic representation of recently opened files and access
 to
 templates and creating new documents etc. I tend to use a few files


This suggestion doesn't display the LO start screen you're referring to,
however it does provide a button to access recently used files.

In all my LO applications there is a button very close to the left end of
the toolbar that looks like an open folder. Immediately to the right of
that button is a small down arrow.

Clicking that arrow opens a list of recently used files.

The list shows *all* recently used LO files. In other words it doesn't
filter the list to display only Writer files or only Calc files if that's
what I'm currently using.

The Folder button and adjacent arrow are there by default, I didn't add
it. So presumably it is there for you as well. Hovering the mouse over the
folder or adjacent down arrow activates both and displays the message Open
(Ctrl+O)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Getting back to the Start screen

[Alan B]

On Thu, Apr 10, 2014 at 2:25 PM, dollyp da...@lochnevis.com wrote:

 Is it possible to have a button on my toolbar that will bring back to start
 screen?


If by start screen you mean you mean all program windows minimized so the
desktop is shown just as it appears after logging on to the computer then
yes it would be possible.

It would require a macro that talks to Windows (if that's what you're
using) and tells it to minimize all open windows.

The same thing can be done without writing a macro. Press the Windows
key+D key combination and all windows are minimized. Press it again and
the windows are all restored. Windows key is the key next to the space
bar with the small flag on it. The key combination will work even if you're
not using LO.

A LO macro to do this would have to send the Windows key+D command to
Windows. That's something I don't know how to do. Hopefully the keyboard
combination I've mentioned would be sufficient for your needs.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc worksheet stalls when opening

[Alan B]

On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote:


 I have a spreadsheet that stalls when I try to open it and when I try to
 save it. It does eventually open after a very long time. I


Just looking for confirmation the issue is with only one particular
spreadsheet?

Calc on Ubuntu does this to me fairly often with any spreadsheet. I filed a
bug report but I don't think there's active interest in it. When the report
was filed I got a suggestion to upgrade, did so and the problem stopped.
Now, a few Ubuntu patches later, and the stall when open behavior is back.

My work around has been Apache OpenOffice. When I get tired of the stalling
(and it's only Calc not Write or other programs) I start using AOO Calc.
Usually after a few LO patches are part of the Ubuntu updates the stalling
stops.

So... if is a problem with any spreadsheet, check if there is a newer LO
and install that to see if the issue is resolved.

If the issue isn't resolved by upgrading LO consider installing AOO and try
opening the spreadsheet with AOO Calc. If the problem persists when the
spreadsheet is opened with AOO Calc it is definitely the spreadsheet.

Regardless of trying AOO, if it is only one particular spreadsheet, a bit
more information would be helpful trying to diagnose the problem.

- did this spreadsheet always act this way?
 - if no,
  -- what changes were made to the computer between the time the
spreadsheet last opened normally and first opened slowly? i.e., add/remove,
upgrade, or patch software
  -- what changes were made to the spreadsheet between the time it last
opened normally and it first opened slowly? ie, add borders to cells,
create new formulas, add more data

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] same calc sheet in 2 windows?

[Alan B]

On Thu, Mar 6, 2014 at 4:20 PM, John R. Sowden
jsow...@americansentry.netwrote:

 I have a calc sheet about 600 lines long with data at the top that I would
 like to see while I an using the data at, say line 400.  Is it possible to
 open a second window showing the data at the top while editing the data at
 lower lines?


Brian has already offered one solution. That solution locks rows in the top
portion of the sreadsheet so they cannot be scrolled.

If however you want to be able to scroll both the top rows and the bottom
rows there is another possibility...

- Open your spreadsheet
- place your mouse at the right edge of the spreadsheet just above the
vertical scroll bar, over a small horizontal black line just to the right
of the column letters. The pointer will change to a two headed arrow
pointing up and down
- while the two headed arrow is displayed click the mouse and drag down,
the spreadsheet will be separated into a top and bottom half and both can
be scrolled independently

LibreOffice's instructions for this can be found by opening Help and using
split window as the search term in Help's Find tab. Select Split or
Window from the list of found topics. Split describes doing this with
the mouse. Window describes doing it using the Window menu's Split
command.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

[Alan B]

On Tue, Feb 25, 2014 at 1:45 PM, Paul D. Mirowsky
p_mirow...@bentaxna.comwrote:

 Please download and install

 http://extensions.libreoffice.org/extension-center/numbertext-1

 Very nice. I've installed it.

If I could change the extension (maybe I will try) I would make optional or
remove the name of the currency and have first letter of initial word
capitalized or possibly first letter of each word.

If I wish to write $35.50 I would write Thirty-five dollars and fifty
cents, not Thirty-five US dollars and fifty cents.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

[Alan B]

On Tue, Feb 25, 2014 at 8:09 PM, James E Lang jim+...@lang.hm wrote:

 I believe the traditional way to write this on a check is, Thirty-five
 and 50/100 dollars


Good point. That's certainly the way I've done it. And the word dollars
is preprinted on the checks I've used so the program output for check
printing should only be Thirty-five and 50/10.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Application of Speadsheet

[Alan B]

Not sure you've gotten answers to your questions and whether the auction
has come and gone and any answer is moot.

If you still wish answers here are some suggestions I hope you might find
helpful.

On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote:

 Attendees' names and paddle numbers will be entered at the start of
 the auction.

 The second phase is the entry of purchased item codes, winning bid
 amounts and paddle numbers of winners.


Third phase is checkout. I was thinking of copying the spreadsheet as it
 existed after phase 2 to a second laptop so that people could checkout
 with last-names-A-through-M going to laptop 1 and N-Z, to laptop 2.

 From your descriptions of phase 1, 2 and 3 I am presuming phases 1 and 2
are done by an individual and only phase three may be done by people
working independently of one another. So one computer, one file to build
the spreadsheet through phase one and two.


 2. When it's all over, how do I combine the two spreadsheets??

 My answers to your question #2


If you break the spreadsheet into two pieces as you've suggested with A-M
on one and N-Z on another to combine them

at laptop with A-M names..
1. make copy of A-M names spreadsheet as error insurance
2. open original A-M
3. open copy of N-Z spreadsheet on A-M computer (get copy there with thumb
drive perhaps)
4. copy all rows / columns of spreadsheet N-Z
5. paste all just copied rows into spreadsheet A-M at bottom of existing
data


If you have complete spreadsheets at each computer as I've suggested
at laptop with spreadsheet 1, s1...
1. make copy of s1 spreadsheet as error insurance
2. open original s1
3. open copy of spreadsheet 2, s2, on s1 computer (get copy there with
thumb drive perhaps)
4. copy all rows / columns of spreadsheet s2
5. paste all just copied rows into spreadsheet s1 at bottom of existing data
6. sort spreadsheet by paddle number

Presumably winning bidders will check out at only one computer. So in this
case there will be two rows for each paddle number. One with purchased
items codes, one without.

At your convenience delete the rows that contain only paddle numbers and
names. (came from the spreadsheet on the computer that the bid winner
didn't check out at)

Note: this presumes organization of your spreadsheet as follows...
Stage 1 columns - name, paddle no
Stage 2 columns - name, paddle no, {purch item code, winning bid
amount}...

where a paddle holder who purchases more than one item has the additional
items listed on the same row as in...
Stage 2 columns - name, paddle no, purch item code1, winning bid
amount1,purch item code2, winning bid amount2...

If your spreadsheet(s) have a different column configuration please advise
so I may consider other options.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

[Alan B]

Dennis,

It looks to me that you're asking how to convert a number to the words that
are spoken to say that number.

You've asked how to convert a number ... to text. People familiar with
programming/macros and data types will read that and think of something
different than creating the words to speak the number.

I found a few solutions, links below, from different sources that take a
number and write out the words to speak the number. None however are
solutions written for Calc. The links do provide solutions how to convert a
number to words with other programs. The logic will be the same in Calc but
the syntax will need to be converted to Calc. Perhaps someone familiar with
programming can assist you to create a Calc function that does what you
wish.

http://delphi.about.com/od/objectpascalide/a/curr2words.htm
http://support.microsoft.com/kb/213360
http://www.dbase.com/codelib/Plus/dUFLPPlus_AA.zip this last is a small
code library written for a product called dBASE. In this library are
routines called Cash2Check, Num2Words, and Thou2Words. The logic of the
three routines is used together to convert a number to the words to say the
number. I can attest to the 1995 (approximately) version of this function
working correctly.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Application of Speadsheet

[Alan B]

On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote:


 Third phase is checkout. I was thinking of copying the spreadsheet as it
 existed after phase 2 to a second laptop so that people could checkout
 with last-names-A-through-M going to laptop 1 and N-Z, to laptop 2.


The first thing that stood out to me is phase 3. Why not have the entire
spreadsheet on both laptops?

I ask because I can't imagine everybody always going to the correct queue.
So why not support them even if they show up in the wrong place? The other
scenario that came to mind is one queue is busy. So, my process suggestion.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Document Recovery window appears

[Alan B]

On Feb 19, 2014 9:18 AM, Tom Davies tomc...@gmail.com wrote:

 Hi :)
 I thought he just meant the Escape key on the keyboard.  It does about
 the same as the Cancel button within the dialogue-box itself

I did mean the Esc key. And, at least on my system, it did make the always
appearing Document Recovery dialog stop showing up when none of the
dialog box controls would.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - sort in to columns

[Alan B]

On Wed, Feb 19, 2014 at 7:04 PM, IGraham gra...@lovatt.co.uk wrote:

 How do I sort out from a mixed list of membership types the email
 addressers
 into separate columns without gaps or 'false' or '0' appearing
 http://nabble.documentfoundation.org/file/n4098035/test2.ods


I'm guessing from your question and sample spreadsheet that by sort out
you wish to have the email addresses appear in a separate column. If
correct the following may not be suitable but...

Use a filter on the columns. It will present a list of entries in your
members table showing only the member type the list was filtered by. Copy
the filtered list of email address to wherever you need them.

To filter...
1) select the entire member table, including the column headings
2) from the menu select Data | Filter | AutoFilter, column headings will
now have a small downward arrowhead at their right hand edge
3) click the arrowhead to the right of member type
4) check the box next to each member type you wish to see in the filtered
list
5) click OK

The member list is now displayed filtered by the member type(s) you chose.
The emails can be copy/pasted wherever else you need to use them.

You should be aware
- the entire member list must be selected to begin, step 1 above, or you
won't get all the members you expect in your filtered list

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Document Recovery window appears

[Alan B]

On Tue, Feb 18, 2014 at 4:46 PM, Muriel Parker rspn...@gmail.com wrote:

 The Document Recovery window comes up every time I open LO.  When I Start
 Recovery Recovery failed comes up.  Closing out window I can continue
 with LO.  I have uninstalled and reinstalled LO, but it is still happening.

 Sounds like the problem I've had.

Next time the Document Recovery window appear press Esc instead of the
things you name above.

Saw this tip while lurking on this list and it worked for me.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Writer record changes feature

[Alan B]

On Thu, Feb 13, 2014 at 10:54 PM, Brian Barker b.m.bar...@btinternet.comwrote:


 The option that is indeed present in (recent versions of?) Microsoft Word
 but missing in LibreOffice is the display of the original, unedited version
 of the document.  But you kept a separate copy of that, didn't you?

 Yes, I do have the original. I'm not really concerned about preserving
that though. Was just looking for an easy (for me) way to toggle among the
three document states, original, edited, edits committed, so that in the
process of making my changes I could switch back and forth among the
various versions of the document. And the switching would occur at the
current cursor location. That way there's no mode change like Alt+Tab ing
to the original version of the document in another window then scrolling to
the current location.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Writer record changes feature

[Alan B]

Thanks for the thought. It's not quite as KISS as I'd like though.

I haven't used MS Word for a while, when I did, this was available. It was
possible to see a document in it's original form, with all edits displayed,
or as if all edits are accepted.

That function, or a close approximation, is what I'm hoping is available.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Writer record changes feature

[Alan B]

On Thu, Feb 13, 2014 at 9:57 PM, Dale Rebgetz dale.rebg...@setec.com.auwrote:


 The way it works for me is if show changes is de-selected (after the
 changes have been made), then what I see is what you are asking for - the
 CHANGED document, not the original.

 Dale.


Made me look Dale, you're right. It is the changed document that's shown as
if edits have been accepted. That's only half of what I am looking for
though.

Would like to be able to toggle state between original, edits displayed,
and edits accepted versions of the document. Accepted in quotes because
they wouldn't really have been committed otherwise the other document
states would be lost.

In the MS Word of a few years ago this was straightforward to do (could
click icons on a tool bar) and something that I found very convenient.
Especially going back to the original document to be sure my edits hadn't
changed the meaning.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Writer record changes feature

[Alan B]

The way it works for me is if show changes is de-selected (after the
 changes have been made), then what I see is what you are asking for - the
 CHANGED document, not the original.

 Dale.


...and p.s. sorry to get folks off on the wrong track. I was hurrying
through an unfamiliar document and thought I saw the original when show
changes wasn't enabled.

Regardless of that, seeing the three states of the document, original, with
edits, and edits accepted is what I'm hoping to be able to do.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Additional KSSS for an Auction Question

[Alan B]

On Fri, Jan 24, 2014 at 12:46 PM, Pikov Andropov piko...@gmail.com wrote:

 We would like the Kingsoft Spreadsheet (KSSS) to have the following
 columns:

 A. Name
 B. Amount of winning bid
 C. Code for item purchased
 D. Description of item purchased
 E. Starting bid

 We realize that D and E can be entered (somewhere -- lower down in the
 spreadsheet. in another sheet, ???) as soon as the auction catalog is
 prepared, but is there any way to get KSSS to automatically enter the
 description and starting bid when the purchase is logged at the auction?

 If I understand, it seems the end goal is to have a spreadsheet after the
auction with rows where columns A, B, C, D, and E are completed. And items
that don't sell would have no entry in column A or B on their row.

If C, D, and E are known before the auction begins why not work directly in
the spreadsheet when buyers come to cash out? When the buyer is cashed out
search the column of item codes and put the buyer's name and winning bid
amount right in the correct row during the cash out transaction.

If E is actual starting bid vs something like minimum starting bid, then
enter A, B, and E when the buyer comes to cash out.

Seems to me this would work and produce the final output desired as part of
the cash out process. Not post production steps. If the cashiers couldn't
do the lookup and data entry then more thinking is needed.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: Re: [libreoffice-users] Calc question

[Alan B]

On Fri, Jan 24, 2014 at 7:51 AM, Carl Paulsen carlpaul...@comcast.netwrote:

 Dang, I hate the new list behavior of replying to the sender instead of
 the list.  C

 +1 there. I spammed Carl trying to reply and ask for feedback on
alternatives suggested to OP

Now from computer instead of phone

Yes pivot table can do that. I've used it many times. Have you tried the
Subtotal method I described?

Has anybody tried both Carl's method and mine?

It would be interesting if there's a consensus given OP's expectation of
unskilled users and intended outputs? Anybody?

After using both myself, and the pivot table MUCH more than the Subtotal
option I favor the Subtotals. Fewer clicks to get result, result displays
by adding rows to existing data no need to look somewhere else (another
tab) , using outline button can display rows of only customer name and
total purchase, then with outline and row expansion show purchase detail
for individual customer, once Subtotal has been applied totals and customer
detail can be displayed or hidden with one click, no need to open a menu,
it seemed users may be familiar with sort and up to clicking the OK
button on the Subtotal dialog this seems to me more similar to sort.
Other ideas?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc question

[Alan B]

On Thu, Jan 23, 2014 at 9:28 PM, Pikov Andropov piko...@gmail.com wrote:


 Next to each buyer will be a price. How do I total the amount of a
 buyer's purchase on the fly, so-to-speak?

 Have labels at the top of each column such as Buyer and Price.

Once you're ready to get your totals by buyer
1) sort by buyer as you intend
2) select the entire data range including the column labels
3) from the menu select Data | Subtotals...
4) in the Subtotals dialog box make sure the Group by option is Buyer
5) tick the Price check box in the Calculate subtotals for list
6) confirm Sum is the selected function in the Use function list
7) click the OK button

You'll be back to your spreadsheet with subtotals for each Buyer inserted.
Plus to the left of the row numbers you'll see outline features that allow
hiding and showing the various subtotaled rows.

-Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Query

[Alan B]

On Sun, Jan 19, 2014 at 6:15 AM, Ernest Dale ernest.dal...@gmail.comwrote:

 ... I appear to have succeeded but the result
 is what looks like a spreadsheet and I cannot find a way to display one
 record at a time.


As already suggested filtering can limit the number of rows that are
displayed. If you prefer to see the data in a form (which shows only one
record at a time regardless of filtering) rather than what appears to be a
row in a spreadsheet...

1. Open your LO Base database.
2. Select Forms from the column of icons on the left side of the window
3. In Tasks, near the center top of the window, select either option. I
suggest selecting Use Wizard to Create Form...
4. Use the options in the Wizard to create a form that displays one record
at a time.
-- Form arrangement options are in step 5 of the form wizard. Chose any
Arrangement of the main form options *except* As Data Sheet


 ... I could do with
 a simpler manual than the one I have found on the web which is hundreds of
 pages long and I cannot copy the sections which look as thought they might
 be helpful. Can you help?
 Ernest Dale

 ernest.dal...@gmail.com


If you haven't already found this link
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
it connects to several varieties of documentation. A full manual which you
apparently found and several smaller guides as well.

I don't have any idea what is causing your problem ...I cannot copy the
sections... The link provided above goes to user guides in both PDF and
ODT format. Individual pages can be printed from any of these documents.
And, anything in those documents can be copied using the usual method
- select with mouse
- right click selection
- click copy
- go to destination
- paste copied text/image into destination

-- 
Alan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with libre

[Alan B]

On Thu, Jan 9, 2014 at 4:58 PM, Mark Bourne 
libreoffice-ml.mbou...@spamgourmet.com wrote:

 Some
   how when I was doing a lot of work on libre office,  I landed up with
 some solid lines running across my page, which I cannot delete or
 remove?

 Why?

 How can I remove them?


 That sounds like a border applied to the paragraph either above or below
 the line. Assuming that's what's happened, to get rid of it:
 - Right-click in the paragraph immediately above the line
 - Click the Paragraph... option from the context menu
 - Click the Borders tab



Just fyi, Mark and list, I have encountered the same error and have been
delinquent not to report it and provide a sample document. Keep telling
myself next time I will. I think the next next time it is a promise I
must keep.

Why?

Because none of the techniques for removing the presumed paragraph border
may have worked. Even going so far as Select All then Clear Direct
Formatting has only partially worked.

What is partially worked? The line is removed. However when additional
paragraphs are entered in the document the line reappears in its original
location.

I might have posted a remark on this about the time of one of the recent
recurring conversations about reveal codes.

The only successful workarounds I've found for this are recreate from a
blank sheet a new version of the document and copy / paste as text the
contents of the old document. Or open AOO writer and paste the contents
there. For whatever reason the persistent formatting problem doesn't paste
into the AOO document.

Note: The steps Select All, Copy, Delete, Paste As Text in the LO source
document does not eliminate the persistent formatting problem. Only Paste
As Text into a new document will.

Just wanted to let all know that if the op has tried the suggested fixes
and found none to work folks shouldn't presume that the directions were not
correctly followed.

-- 
Alan
CISSP, CCENT, LPIC-1, ITIL Foundations v3, MS Computer  Information Science
...credentials provided to assure that I'm not a noob and can report
reasonably well on experiences at the keyboard

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted