[libreoffice-users] Can't open new version of LO
I was running version 7.4 & got a notice to download 7.6.6.3. After downloading & restarting my computer, when I click on the new version icon on my desktop, the icon highlights but the program never opens. I am running Windows 7(yes I know it's a bit old & I am looking to replace this computer) but I do need Libre Office to continue my work until I can get the new computer. I would appreciate any advice. Maybe deleting the program completely & try downloading it again? Please help now. Bill Bauer -- 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] stripping crlf
On 1/3/2024 2:18 PM, Brian Barker wrote:
At 11:08 03/01/2024 -0500, Bill Drescher wrote:
I have a document that I copied from the original on the web
(legally). Now I need to modify it using LO. The document has
hard line breaks that I want to remove.
The first thing to do is to understand what you are handling
here. Calling these "hard line breaks" (or, even worse, "crlf"
- as you have in your Subject header) is unhelpful, as what I
assume you have here is what in a word processor are *paragraph
breaks*.
Using the find and replace form I can not figure out how to
indicate a line break.
It's generally necessary to think in terms of the paragraphs
themselves, rather than breaks. (But perhaps not here ...)
With "Regular Expressions" selected /n, /n/lf fail.
Those would need to be backslashes, not slashes. And \n matches
a line break, not the paragraph breaks that I believe you have
here.
What can I use to replace the line break with a space?
Just "$" (no quotes), it seems.
Another thought: consider using Paste Special (instead of
ordinary Paste) and "Unformatted text" when inserting text from
elsewhere. This avoids some problems.
I trust this helps.
Brian Barker
--
Bill Drescher
william {at} TechServSys {dot} 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
Re: [libreoffice-users] striping crlf
I have a document that I copied from the original on the web
(legally). Now I need to modify it using LO. The document has
hard line breaks that I want to remove. Using the find and
replace form I can not figure out how to indicate a line break.
With "Regular Expressions" selected /n, /n/lf fail.
What can I use to replace the line break with a space?
Thank you
Thanks to all who helped. I have been in Windows land for too
long, thus the front slash. When I used \n it worked just fine.
To Brian:
Many thanks, I actually was looking for line breaks not paragraph
breaks: they clearly occurred in the middle of a sentence and
once I went back to Linux land (in my thoughts) and used
backslash "\n", it worked fine.
I never tried $ as \n worked but thanks to Michael and Wiebe.
--
Bill Drescher
william {at} TechServSys {dot} 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
[libreoffice-users] striping crlf
I have a document that I copied from the original on the web
(legally). Now I need to modify it using LO. The document has
hard line breaks that I want to remove. Using the find and
replace form I can not figure out how to indicate a line break.
With "Regular Expressions" selected /n, /n/lf fail.
What can I use to replace the line break with a space?
Thank you
--
Bill Drescher
william {at} TechServSys {dot} 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
[libreoffice-users] problem with synchronize while formatting business cards
I am attempting to create a business card. I enter the form data
and on the options tab I have checked synchronize. When I create
the New Document it formats the page correctly but I can not find
the Synchronize Labels button.
Where is it and/or suggestions for finding out what is wrong.
Thanks in advance.
--
Bill Drescher
william {at} TechServSys {dot} 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
[libreoffice-users] multiplying time
On a spreadsheet I want to multiply time worked in hh:mm by pay
rate (integer) and I can't find out how.
Help please.
--
Bill Drescher
william {at} TechServSys {dot} 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
Re: [libreoffice-users] Prevent Template Name Appearing in Document Title [SOLVED]
On 9/23/2021 11:28 AM, Dave Barton wrote:
On 16/09/2021 13:32, Dave Barton wrote:
Is there any setting available to prevent template names being
automatically added to the Title field of the file properties. This is
not the case for the "hard coded" default templates.
I am fully aware of how to remove the template name from the Title
field, but I do not want to do this every time I open a new file based
on another template.
TIA
Dave
Answering my own question. While watching Gabriele Ponzo's "Professional
Templates" LiboCon presentation today, the realisation hit me that
templates inherit ALL aspects of of the document from which they are
created. The simple solution to my issue is to ensure that the "Title"
field of the "File Properties" dialog is cleared before the template is
saved.
Apologies for the list noise.
Dave
I appreciate your query and solution.
-bill
--
Bill Drescher
william {at} TechServSys {dot} 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
Re: [libreoffice-users] regex help
Thank you very much Brian.
I decided that it would be easier to be the "earnest human" and
manually delete the extraneous lines(paragraphs).
Maybe when I have more time I will come back to this and post an
example to the list.
--
Bill Drescher
william {at} TechServSys {dot} 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
Re: [libreoffice-users] regex help
On 1/3/2021 4:09 PM, Brian Barker wrote:
At 14:19 03/01/2021 -0500, William Noname wrote:
I have a script that mysteriously became double spaced. I want
to search for 2 end of paragraph marks and replace them with one.
So it's the paragraphs that are spaced, not lines (the usual
meaning of "double-spaced")?
Yes, I do mean lines are double spaced, but...
I can't do what I want to do in my programming editor and when I
read the script into LO the line endings are suppressed and each
line is treated as a paragraph.
I can do a regex search for $ and find them all, but $$ finds
none - I presume there is something between them that does not
show as a formatting mark.
You are labouring under the common misapprehension that the
pilcrow that indicates the presence of a paragraph break has an
actual presence in the document; no: think of it merely as the
indicator that it is. And you think that the $ symbol matches
this; also no.
Thank you.
I don't want to remove all blank lines, just the ones that
have a blank line following.
In other words you want to remove blank empty *paragraphs*.
Yes, but I have intentional blank lines that I do not want to remove.
What is the regex for a paragraph mark in replace?
There isn't one. Instead, the $ symbol merely locks your
pattern, whatever it is, so that it will match only something
that occurs at the end of a paragraph.
Or, any other suggestions.
Don't think of searching for paragraph breaks, which you cannot
do. Instead, search for the empty paragraphs that you wish to
delete. They contain nothing, so the pattern you need is also
nothing. But you need to arrange that it matches nothing only
if that nothing occurs at the beginning of a paragraph and at
the same time at the end of a paragraph. The symbol for locking
to the start of a paragraph is the caret, "^", so the pattern
you should search for is "^$" (no quotes, of course) -
replacing with nothing.
Is there a way to select a paragraph followed by an empty paragraph?
I trust this helps.
Brian Barker
--
Bill Drescher
william {at} TechServSys {dot} 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
Re: [libreoffice-users] passing filter options with the --convert-to CLI switch to soffice?
anne-ology <lagin...@gmail.com> wrote: >Maybe I understand what you're attempting; I'm confused about > whatever CLI switch is though. A "CLI switch" is an sub-command or option that can be specified on the command line as part of the command-line interface (CLI). >I've only converted PDFs to Word and all appears fine, But perhaps you are not using "filter data" options? > so unless there's a bug in your program version, I don't see why > reversing the process should be a problem. No, what I'm wondering about is how I specify that I want the generated PDF to be tagged (a modern-day requirement for compliance with accessibility regulations). Running "soffice --help" on the command line gives me this (plus much other information): --convert-to output_file_extension[:output_filter_name[:output_filter_options]] [--outdir output_dir] files Batch convert files (implies --headless). If --outdir is not specified then current working dir is used as output_dir. Eg. --convert-to pdf *.doc --convert-to pdf:writer_pdf_Export --outdir /home/user *.doc --convert-to "html:XHTML Writer File:UTF8" *.doc --convert-to "txt:Text (encoded):UTF8" *.doc In the last couple of examples, I think "UTF8" is a filter option. But it doesn't have the name=value form. So I'm wondering how it's supposed to work. And where it's documented. Bill > >Have you checked to see if others have reported a bug?; if not, then > maybe doing so, as a query, might bring someone to offer help, > > > > > From: Bill Janssen <jans...@parc.com> > Date: Tue, Apr 17, 2018 at 12:08 PM > Subject: [libreoffice-users] passing filter options with the --convert-to > CLI switch to soffice? > To: users@global.libreoffice.org > Cc: jans...@parc.com > > > I'd like to be able to use the convenient --convert-to CLI switch on > soffice to convert from Word to PDF. However, I'd like that conversion > to create tagged PDFs, and the default for UseTaggedPDF is false. > > A number of PDF export options are listed at > https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export, and after > reading that I tried, > > $ soffice --convert-to pdf:writer_pdf_Export:UseTaggedPDF=true --outdir > /tmp myfile.docx > > But still got untagged PDF in the output file. > > Can anyone see what I'm doing wrong? > > Thanks in advance! > > Bill > > -- > 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 -- 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
[libreoffice-users] passing filter options with the --convert-to CLI switch to soffice?
I'd like to be able to use the convenient --convert-to CLI switch on soffice to convert from Word to PDF. However, I'd like that conversion to create tagged PDFs, and the default for UseTaggedPDF is false. A number of PDF export options are listed at https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export, and after reading that I tried, $ soffice --convert-to pdf:writer_pdf_Export:UseTaggedPDF=true --outdir /tmp myfile.docx But still got untagged PDF in the output file. Can anyone see what I'm doing wrong? Thanks in advance! Bill -- 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
[libreoffice-users] What jar files and environment variables to use for Java LibreOffice programs?
I've written a Java program using the Java bindings to the LibreOffice 5 UNO API. But I can't find documented anywhere the specific runtime environment that needs to be used to run it. Specifically, what jar files from the LibreOffice distribution need to be on my CLASSPATH, and what environment variables and/or system properties need to be defined, and what are the values they need to be defined to? Thanks for any enlightenment on these matters! Bill -- 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] localc 5.1.4.2 - comment and reference issues
On 07/23/2016 08:18 PM, Brian Barker wrote: At 14:50 23/07/2016 -0700, Bill Noname wrote: reference (internal to one sheet) issues if you link =$page1.$A$1 to page2 cell a1 changes to the cell update immediately but changes to comment content, size or position never to regardless of global localc general updating setting That's because what you have here is not a link but a formula. Formulae evaluate values only and do not carry over other aspects of a cell - formatting and so on. Remember that your formula, referencing only a single cell, is a special case of something more general. Whatever label you choose (formula, link or reference) it's about replicating cell data from one cell to another. Deferring to your "formula" label, when you set it up using Edit/Paste Special you ARE given the option to include/exclude formatting, comments and make it a "link" so if these are not to carry over why have those options in the first place? What would you want to happen if your formula were instead =Sheet2.$A$1+Sheet3.$A$1 ? The destination cell couldn't inherit aspects of formatting from both of two different cells. Note that a formula such as this, which happens to reference another sheet or sheets in the same spreadsheet, is no different from one that operates only within a single sheet. Point taken, IMHO it would be rare you'd want linked comments in many to one references with those rarities easily worked around. I can't see the need but you could treat those rarities in the same way we do when merging multiples cells with data into one. Or simply default to using the first cells format, comment, etc... On spreadsheets with only internal links the "Edit/Links" is ghosted. Again, that is because these are formulae, not links. Yes, but there is no Edit/Formulas and I was trying everything before posting. it would be nice to have a hotkey to update INTERNAL links including row height, comment window content, position and size You would break most people's idea of how a spreadsheet should operate if you achieved this. "most people" don't use comments at all, much less linked comments. No one I know who does disagrees with this being a deficiency. I trust this helps. Brian Barker -- 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
[libreoffice-users] Calc - detect landing on a particular cell.
I want to trigger an event when a particular cell becomes the active cell. Here's the situation: After entering a payment in a specific cell (say $10 in A5) and hitting enter, I'd like to programatically put the current time as hidden "userdata" in the cell immediately below it (A6) - the new active cell. I'd like to detect leaving that cell (A6) or entering the cell below (A7) without modifying the visible contents of A6 or A7. I want to use the elapsed time between the enter keystrokes to change the way the sheet reacts. $10 (enter) (immediate enter) Signals that the transaction is over and a macro sets up for the next transaction. $10 (enter) (wait a second) (enter) Signals the transaction isn't over and just sits there. The time difference between the double enter keystrokes determines what happens next. This spreadsheet has 6600 lines of macro code that makes it function, and I'm already relying heavily on event handling, but it only works on a modified cell. In this case, I'm not modifying A6 or A7, but I want to trigger an event that lets me know they have become the active cells. -- Bill Gradwohl -- 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
[libreoffice-users] Using PriorToReset event in Base form
Please correct me if I'm wrong, and if there's a better place to ask, let me know. It is my understanding (experimentally verified) that the PriorToReset event will fire when a new database row is produced for data entry. Inside this event, I can use the passed in event object to get the Form and from the form get at the elements of the form. I named my sub the same as the event it relates to. Sub PriorToReset(event) dim Form dim DateField Form=event.source DateField = Form.getByName(Date) Now I can drop a date into the Date field via : DateField.setPropertyValue(Text, 01/04/2015 ) That date shows up on the screen as though I had keyed it in by hand. Great so far. Once I fill out the remaining fields manually, and an attempt is made to send the data to the database, an error shows up asking to fill in the mandatory Date field. I'm looking at it filled in exactly as I want it, but somehow the system thinks it's not filled in. If I focus the date field and backspace over the last digit (5) and then re enter 5 and hit enter, and then attempt to save the record, it works. Why? Why can I see the date field filled in exactly as I want it, but somehow the system thinks the field is empty or somehow invalid until I touch the field and tinker with its last digit. If I set the last digit to 9, for example, a database row is stored with 01/04/2019 in it as expected. -- Bill Gradwohl -- 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
[libreoffice-users] Re: Compress images
I am in the same boat as the OP. I have searched for a quick, simple solution to this for several years, always smiling at the discussion boards dismissal of it as a needed add-on... Just now decided the current solution remains to find someone with a copy of Word and use it for the 5 minutes it would take to do this. The 300 images in the documents I am working with are secondary to the text, but they are nice to have. The .odt file is occasionally emailed back and forth for editing of the text. The original file I am working with was created by others less technical and they embedded huge images. The production process will eventually led to an InDesign or Web based product but for now the ability to email the files back and forth is important. A single menu option to Save As and Compress to A. Small, B. Smaller or C. Smallest Image size would be awesome. But today I'll just take the files on a flashdrive to my neighbor next door... -- 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
[libreoffice-users] Re: Basic IDE Right Click
Thanks for the pointer Tom, but that doesn't seem to make any difference. So for no good reason I went in and uninstalled Libre from the XP machine which seemed to take a /lng/ time, but eventually completed as expected. No error messages. It left tons of files laying around the machine though so I manually deleted everything I could find. Then I rebooted XP. Finally I downloaded fresh install files from LibreOffice.org (4.2.1.1) and reinstalled them. At that point things seem to work properly. I'll have to use it some to verify, but the original problem is resolved. Thanks. Bill -- View this message in context: http://nabble.documentfoundation.org/Basic-IDE-Right-Click-tp4098726p4099206.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Basic IDE Right Click
Actually no. That's what Tom suggested, and which I tried first. Libre regenerated a new profile but still had the same problem. Bill -- On 2/26/2014 6:19 PM, Andrew Douglas Pitonyak [via Document Foundation Mail Archive] wrote: So the problem was likely related to your user profile... If the problem occurs again, try renaming your user profile while LO is not running and then restart LO. -- View this message in context: http://nabble.documentfoundation.org/Basic-IDE-Right-Click-tp4098726p4099228.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Basic IDE Right Click
I'm using the latest version of Libre under XP and under Win7. When I open a Libre Calc spreadsheet I can right click anywhere and I get a menu as one would expect. However under XP if I then open the Basic IDE and edit a macro, the right click does not do anything. I can't copy/paste using the right click for example. It works properly under Win7, but fails to work under XP. Do I need to touch some configuration setting or something to fix this? Does this sound familiar to anyone? Thanks. Bill -- View this message in context: http://nabble.documentfoundation.org/Basic-IDE-Right-Click-tp4098726.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Declare Statment - Calc
Win XP is on the particular old machine I'm using. No error message, just doesn't seem to work properly. Just an error beep, not a tone of specified duration. Since Win XP is scattered full of files named user32.dll, I presume Libre was just picking up the wrong one. Once I gave up on the example though, I went back to my own DLL code and Basic program. I finally got it to work if I put my DLL in the Libre bin subdirectory. Libre wouldn't find it when I placed the DLL in with my ODS files as Excel would have. Apparently I need to somehow tweak the Libre settings to make it look for the DLL in the same subdirectory as my spreadsheet files. Providing a fully specified path name for the DLL in the Declare statement wasn't the answer. Thanks. Bill -- View this message in context: http://nabble.documentfoundation.org/Declare-Statment-Calc-tp4098016p4098155.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Declare Statment - Calc
I've tried to implement the simple example shown in the Calc Help system for the Declare Statement. Somewhere it expects to find a file: user32.dll but I have no idea where to find it. Windows has many user32.dll files for it's own use but presumably none of them are relevant to LibreOffice.The file does not seem to be included in the DLL files that install with Libre. So does it need to be downloaded from the web somewhere and manually installed?I'm just trying to understand how to link Basic to a DLL file so I can go off and do something more complex. Thanks.Bill -- View this message in context: http://nabble.documentfoundation.org/Declare-Statment-Calc-tp4098016.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Thanks for you help.
Hi All, Thank you All for your fast responce to my question. it is appreciated. Take care Bill -- 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] Would somebody be able to help a newbe to LibreOffice.
Hi All, Thanks for responding to my call for help. Here is the situation: I have a LibreOffice Cal sheet with rows 1-34 with text. Rows 35-40 with titles above 7 colums. Rows 41-100 is entries. I would like to modify document so that rows 35-40 stay fixed when I scroll down to say column 100. This way the titles of the seven columns would always be visible. I know this can be done. What formula would I use and where would I put that? Many thanks in advance Bill On 11/7/13, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I am getting the feeling he was hoping the answer would be No. been waiting for a question all day! Regards from Tom :) On 7 November 2013 21:11, anne-ology lagin...@gmail.com wrote: yes, you've found it; what's you're next question ;-) From: Bill Gassner bill.gass...@gmail.com Date: Wed, Nov 6, 2013 at 9:08 PM Subject: [libreoffice-users] Would somebody be able to help a newbe to LibreOffice. To: users@global.libreoffice.org Greetings Is there a list of willing helpers. Thanks in advance. Bill -- 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 -- 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
[libreoffice-users] Would somebody be able to help a newbe to LibreOffice.
Greetings Is there a list of willing helpers. Thanks in advance. Bill -- 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
[libreoffice-users] Libreoffice 4.1
desktop-Hello I was trying to install the Libreoffice on ubuntu .deb. Its says in the instructions cd desktop-integration but there is no folder the Debs folder call desktop-integration are you missing something? Bill Stark -- 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
[libreoffice-users] couple questions
I heard about your system on Corbett Report. The reason I would want to join is do not want NSA checking my emails or other forms of communications. Am I protected with your site. Also, if I join your system, do I drop my Cox Internet Connection or still keep it plus with emails do I get to keep my Outlook or hotmail accounts? William Zaffer www.zafferhomes.com Scottsdale, Arizona 480-201-7387 Stop being exploited, learn to eat healthier at home, learn to live a Earth Friendly lifestyle, shop local, and buy more American but moderate consumption. We need to rethink and restructure the system. It is not sustainable. If you’re not prepared to be wrong, you’ll never come up with anything original.” -- 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
[libreoffice-users] LibreOffice API
Where can I find information about the Methods and Properties of LibreOffice API? -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-API-tp4059011.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] 3/4/13 in writer table
I have a writer document with a table. The first col is formatted
as date, but when I enter today ( 3/4/13 ) the 3/4 is formatted
as a small 3/4th.
I checked the col formatting and it really is date (MM/DD/YY)
Any thoughts or suggestions ?
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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] Using_LibreOffice_in_a_Web_Browser
On 2/23/2013 3:00 PM, Luuk wrote:
Not any good answers, and not any bad answers.
No answers at all. ;(
Seems no one is interested in being able to edit via a browser
I can not imagine why I would want to.
Why would I want to ?
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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: method to subdivide individual cells
On 2/15/2013 10:33 AM, jomali wrote:
I've been following this thread and wondering what a use case would be for
subdividing cells.
I own a breeding kennel. I created a table to keep track of
medication administration
col A: date
col B: dog 1 name, col title being the medication
but when I got to col C I needed to put in 3 dog names, with the
col title being the medication
I also use a winding for a checkbox.
It sure would have been nice to be able to subdivide col C
horizontally. The only way I could do it was to put in the first
box and the first dog's name and then space until it forced a
wrap and put in the second and again for the third. Of course it
all falls apart if I change the col width.
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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: method to subdivide individual cells
On 2/15/2013 1:47 PM, Jay Lozier wrote:
On 02/15/2013 01:43 PM, Tom Davies wrote:
Hi :)
Ahh, there was something about
Ctrl Enter
inside a cell makes an extra newline inside the cell itself.
It doesn't sub-divide the cell but does just give you a
newline in there.
Regards from
Tom :)
CTRL + Enter inserts a new line within the cell
That is terrific - thanks
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] page down in word processors - find next
I am keeping the same thread as it is closely related.
The one thing that I really don't like is that as soon as you do
a search the page down button becomes continue search forward
and the page up becomes continue search backwards. That is
fine while you are searching, but how does one return it to page
up and page down ?
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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] Feature Request
On 2/12/2013 2:04 PM, John R. Sowden wrote:
I know this is a bad time, since 4.0 was just released, but
improvement is an ongoing process.
For the 'recent documents' menu selection under 'file', it
would be nice to:
1) allow us to set the number of recent documents, under
tools/options.
2) allow us, in the recent menu, to right click and set certain
files to 'permanent' so
they will not fifo off the stack. An asterisk (blue?)
could act as a visual flag.
John
I like both of these ideas, but especially the ability to flag a
file as permanent.
When you file the bug/feature let us know the number or link so
we can add our +1.
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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: [tdf-discuss] First Round of Questions for my Master Thesis
On 1/25/2013 4:34 PM, Simos Xenitellis wrote:
...
Hi Regina, Indeed, the ASF holds now the OpenOffice.org
trademark in the US. The issue is about the OpenOffice
trademark (without the .org part), which for the US it is
reserved by someone else,
http://tess2.uspto.gov/bin/showfield?f=docstate=4002:4o6qwv.2.1
If there is such a trademark search website for Europe, then you
will find that the OpenOffice trademark is also taken in Europe
by someone else, and also in Brazil (that's why the Brazilian
team selected BrOffice). That's why we do not use OpenOffice
by itself. Simos
My trademark search says that open office and openoffice both
have dead trademark applications and thus are available to be
trademarked.
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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] Inserting a code for today's date
On 10/19/2012 11:20 PM, Brian Barker wrote:
At 10:26 19/10/2012 -0400, Bill Drescher wrote:
Is there any way I can insert code so that when I open a
template the date is the date that the document is opened
rather than the date it was created ?
When you open the template, both these dates are the same!
Templates are used only to create new documents, so the
document is created at the point that the template is opened.
But I think I see what you mean. You want a template
containing a date field such that any document created from
that template will, after it is saved and reopened, show the
date that the document was reopened (and then reopened and
reopened) and not initially created from the template.
As has already been suggested by others, you can do that at
Insert | Fields | Other... | Document. Under Type select
Date and under Select select Date - not Date (fixed). One
point of confusion is that at Insert | Fields you will see a
Date entry - but this is actually the Date (fixed) variety,
not the (variable) Date that you need. So ignore that and
proceed to Other... .
I trust this helps.
Brian Barker
Thanks Brian, that works.
(this may be a duplicate as the first reply I sent seems to have
gotten lost in cyberia.
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Inserting a code for today's date
Is there any way I can insert code so that when I open a template
the date is the date that the document is opened rather than the
date it was created ?
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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-merging a master document
On 7/29/2012 2:53 PM, Brian Barker wrote:
At 13:32 29/07/2012 -0400, Bill Drescher wrote:
Is there a way to have the master document merge the
subdocuments again without closing and opening it ?
Try Tools | Update | Links (or Tools | Update | Update All).
I trust this helps.
Brian Barker
Thanks Brian, you are terrific.
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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-merging a master document
On 7/29/2012 2:49 PM, Gabriel Risterucci wrote:
If I understood correctly what you want, in the navigator you can do right
click-refresh-all (or something along this line, I use a different
locale). This will refresh all subdocuments.
Thank you, not only 1 way - 3 ways
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] re-merging a master document
Is there a way to have the master document merge the subdocuments
again without closing and opening it ?
--
Bill Drescher
william {at} TechServSys {dot} com
--
For unsubscribe instructions e-mail to: users+h...@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] LibreOffice / OpenOffice Calc very slow with Excel File
On 09/25/2011 12:37 PM, Cor Nouws wrote: However, the file turns out to have 41472 empty (?) graphics on the second sheet ... Cor: This creation of objects is earily similar to the problems I encountered where I would have numerous hidden buttons on a spreadsheet that I never created. My document was created and used only under OO / LO, never Excel. Could the interpretation of the Excel document involve an internal conversion to LO xml and then a read of that xml to actually load the spreadsheet? I'm convinced the xml writing/reading is the source of many of the issues I've seen. -- Bill Gradwohl -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] storeToURL fails until machine is rebooted.
Below are 2 routines that print a sheet to paper and then to a .pdf file. After the machine is started in the morning, and then for x number of transactions, these routines work as expected. At some point however, an error occurs at the line below that says: thisComponent.storeToURL(pdfURL,args()) When I use the debug window to look at the fields being passes to the storeToURL, they are as expected. I have no idea why after a while the storeToURL fails and continues to fail until I reboot the machine. Getting out of LO does not work. I have to reboot the box to get it functioning again. After a reboot, the sheet that was to be printed and turned into a pdf again works as expected. Other executions work as expected until it stops working as expected some number of transactions later and I have no idea why. Because I have to bounce the box to correct this, I suspect the problem is in a loaded library that does not unload when LO is closed. Anyone have any insight? I think this is a real bug. sub receiptPrint(PrintOnPaper as boolean) dim printRange(0)as new com.sun.star.table.CellRangeAddress dim nullRange() as new com.sun.star.table.CellRangeAddress dim printOptions(1) as new com.sun.star.beans.PropertyValue dim doc as object dim sheetReceipt as object On Error goto errorRoutine doc = ThisComponent sheetReceipt=doc.sheets.getByName(Receipt) printOptions(0).Name=Wait printOptions(0).Value=True printOptions(1).Name=CopyCount printOptions(1).Value=1 printRange(0).sheet=sheetReceipt.RangeAddress.Sheet printRange(0).StartColumn=0 printRange(0).StartRow=0 printRange(0).EndColumn=9 printRange(0).EndRow=getEndRow(sheetReceipt) thisComponent.sheets(sheetReceipt.RangeAddress.Sheet).setPrintAreas(printRange()) if printOnPaper=True then thisComponent.Print(printOptions()) end if On error goto 0 printPDF(receipt) thisComponent.sheets(sheetReceipt.RangeAddress.Sheet).setPrintAreas(nullRange()) saveSpreadSheet() exit sub errorRoutine: dim message as string if Err0 then message=Error Number Err at line Erl chr$(10) Error() chr$(10) msgbox message,0,Error Occurred endif end sub ' receiptPrint sub printPDF(subDir as string) dim odsURL as string dim pdfURL as string dim strArray() as string dim x as integer DIM args(0) AS NEW com.sun.star.beans.PropertyValue 'exit sub odsURL=thisComponent.getURL() ' file:///bill/Desktop/WestEnd.ods ' Need file:///bill/Desktop/.pdf/YYMMDD/subDir/count#.pdf strArray=split(odsURL,/) for x=0 to ubound(strArray)-1 pdfURL=pdfURL strArray(x) / next x pdfURL=pdfURL .pdf if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / right(year(Date()),2) right(100 + month(Date()),2) right(100 + day(Date()),2) if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / subDir if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / x=1 while dir(pdfURL right(1000 + x,3) .pdf,16) x=x+1 wend pdfURL=pdfURL right(1000 + x,3) .pdf ' Save as PDF args(0).Name = FilterName args(0).Value = writer_pdf_Export thisComponent.storeToURL(pdfURL,args()) end sub -- For unsubscribe instructions e-mail to: users+h...@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: CALC - copy formula via macro
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/03/2011 06:41 AM, Andreas Säger wrote: http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangeMovement.html#copyRange provides the normal way to copypaste with all (conditional) formattings, relative/absolute references and validation. Thank you for both links. I was so intent on finding methods for formulas that I completely missed looking at the problem from the cell perspective. Thanks for waking me up. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5j61kACgkQ7Orvev+eC8r41gCggWjM5lHQO3KhP+xloyx48K1v UCEAoIzpt4azfLvHD7xjKWKCg6dshghw =U5JL -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 - copy formula via macro
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/04/2011 07:38 PM, Andrew Douglas Pitonyak wrote: Dim o Dim oSheet Dim oRange Dim oDoc oRange = oDoc1.Sheets(0).getCellRangeByName(B2:C3) oDoc1.CurrentController.select(oRange) o = oDoc1.CurrentController.getTransferable() oRange = oDoc2.Sheets(0).getCellRangeByName(F1) oDoc2.CurrentController.select(oRange) oDoc2.CurrentController.insertTransferable(o) Andrew: I'm going to have to study this one. GetTransferable / insertTransferable - Never heard of them! - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 IM:billgradw...@gmail.com (No email please-IM only) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5kRz4ACgkQ7Orvev+eC8qdkQCgtdzPAwRSQPvV3OWOTY4EH4fI hWoAoJeBMO5zxfEbmnJZg9rTX1p0Mzgp =+R9E -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] CALC - copy formula via macro
Assume: A1 contains the formula =SUM(B1:E1) I want to programatically copy A1's formula to somewhere else in column A that is determined at execution time, and I need the cell references adjusted accordingly. If it gets copied to A19, for example, I need the formula to read: =SUM(B19:E19) The getFormula and setFormula methods don't adjust the relative references - they get and set text. Is there a way to get the references adjusted auto-magically? Is there a method that can take the formula obtained via the getFormula and apply a row and column distance offset to the contents? I don't want to use the macro recorder/dispatcher - too ugly. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@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: Linking between two separate spreadsheets result in Err:509.
On 08/31/2011 05:53 AM, Andreas Säger wrote: The target document keeps a copy of the referenced data anyway, so why not store all the sheets in a single document? Because the primary doc may be used by an employee and that doc generates information the employee should have no access to. The second doc has the private data. This is useful when the primary doc uses a macro to generate the data for the second doc so the primary doc does NOT have a copy of the output of the macro. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@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: Suggestions to PTB
On 08/27/2011 06:48 AM, Alexander Thurgood wrote: . However, where some of the bugs are very old, the investment needed to correct them is often perceived as greater than the benefit to be obtained, in fact greater even than rewriting the whole corresponding code module. As such large rewrites are more future oriented than bug catch-up, it is normal then for such bugs to be placed on standby, pending further new development. I might not like that any more than you (especially with respect to Base in my particular case), but I can understand it from both a human motivation and ressource allocation point of view. If Ford did to automobiles what you suggest is proper conduct for software development, Ford would be out of business. If during the normal course of using a product (Ford car), the brake pedal would periodically fall off for no apparent reason, consumers would be outraged, Ford would put a team on it and it would get corrected. I'm certain of it. I and many other people use OO/LO and periodically get file corruption rendering the document useless. I'd say that's roughly the equivalent of the brakes falling off a car. I've reported this for years and corruption issues persist with identical symptoms from one release to the next, from OO to LO. I can understand your position for nuisance items, but file corruption is the software having a brain aneurysm. It needs emergency attention right NOW. I'm a professional software developer (mainframes PC's) and I've managed software teams to produce products sold for hundreds of thousands of dollars per copy. The market incentive to produce a reliable product is what is missing in open source. No ones butt is on the line - no accountability. As the old saying goes, Lead, follow or get out of the way. LO has positioned itself as an alternative office suite. It has an obligation to produce a reliable product. Period. If that can't be achieved year after year, then the management of that project, or lack of it is at fault. Stop writing code. Get the project organized, possibly even create a branch for profit, and get on with it or get out of the way. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@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: Search/Replace in Basic IDE
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/16/2011 12:44 PM, Johnny Rosenberg wrote: When I search for something and leave the Replace With field empty (meaning that I will replace something with nothing), replace will not take place. What you describe is also what I get in OpenOffice on Fedora 14. Searching for a string and having nothing in the replace field causes the dialog to just search and do no replacements. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5KwUMACgkQ7Orvev+eC8otvQCfTgNOakWvFJhNumE9WkNKh/VU mvgAnjvMfxc01SJSC50fxeIvANFlKE6h =sgpU -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 05:23 PM, Simon Cropper wrote: It is obvious that you do not like OO or LO Calc, and that you don't like the fact that your data is continually corrupted. LO is a tool. I neither like or dislike it. As a tool, it has a major defect in that it periodically destroys the product which was built using it. You're right in that I don't like the tool I'm using to destroy my work. You also say you continuously have to rebuild your spreadsheet and that the process can take several days. Just spent 2 long days recreating the spreadsheet using 2 machines. Not fun. If you are so unhappy with the format, corruption and dirty code, my question is why do you persist? I've got a lot of investment in my macro code (9000 lines of it) that can only function within LO. I can't migrate it to something else as is. Had I known about the corruption when I started the project 6 years ago, I would have chosen a different platform. I would have never imagined that over the course of several years that corruption issues would be ignored. That's just inconceivable to me as a professional software developer, but that's apparently the reality. Change packages. Can't, as was mentioned above, unless I rewrite everything. Sad to say, LO is the only real competitor to MS Office and given its corruption history it will turn a lot of people off that might have moved away from MS Windows to Linux had the product been reliable. My real interest is in moving people away from a lousy operating system like Windows to something near bullet proof like Linux. We all need applications tools like word processing, spreadsheet, etc, so a tool like LO is vitally important to Linux adoption. If I could get MS Office compiled to run on Linux as a native application, I'd forget about LO in a heartbeat. MS Office is the best thing Microsoft has. It works well in its native environment. I wish I could say the same for LO, and that's why I'm critical of it. With the time and effort you have already put into recreating corrupted spreadsheets you could of written your own application or mastered alternative packages. I guess you don't write code for a living. I estimate a rewrite of my POS system would take well over a year of my time. While that's going on, I need something reliable to help run a business. I have sketched out a web based replacement much much more sophisticated than what I'm using now, and plan on developing it when I have the time. Wasting time reporting OO / LO bugs that never get taken seriously and recreating a spreadsheet periodically helps keeps me from such a new development effort. My wife (also a professional software developer) keeps telling me to stop wasting time reporting issues - that I'm tilting at windmills. She may be right. I am not trying to be rude here it just if I had a package that caused me so much wasted time I would just move on. I will move on in time, but in the interim, I'd like LO to thrive in the market, and that won't happen unless it becomes reliable. My problem is really with LO management. There isn't any. Despite what you may think, I'm more interested in LO's success than most people are, and I know it won't be successful long term unless its reliable. It hasn't been reliable for years and that's a problem. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5EEGMACgkQ7Orvev+eC8rvIACgly5u6U6eM9DeiCbJJ5++k8rf BpUAoIy9kOViLVFCssIwmN3BfCGnR+Dy =ct68 -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CkUsACgkQ7Orvev+eC8p1pQCeOXYJZ0Hxviu0Vx3FQrS1y0KY OPAAn1FA2iVoMjWyXvUwdLIuTaYVfAT6 =KOyQ -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 08:24 AM, Tom Davies wrote: Hi :) Please post a new bug-report against LibreOffice rather than against OpenOffice. It stands a good chance of getting soem attention now. I already did: https://bugs.freedesktop.org/show_bug.cgi?id=39930 I'm in the process of once again rewriting my spreadsheet from scratch and importing my macro code into it. At least 2 days worth of tedious work. The bug report I submitted was to help someone else avoid my problems in the future should the underlying root cause of the corruption I'm seeing get fixed. A fix won't help me now, as I don't trust the .ods file contents. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CpyoACgkQ7Orvev+eC8rAvwCgs8vTIfZBzm7oljLl0U8yPRmK NqMAoMT9BNc7BctLOyye0ILePyYN2m5Y =UQsx -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 will not save file after sheet deleted.
On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] LO corruption
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 About a week ago, I asked this list for help and got what I needed to further investigate a situation I'm having with calc. I've now determined that my problems are due to corruption of the calc sheet. Further, I believe its calc itself that's doing it. Case in point. My buttons were shrinking randomly, but in a somewhat predictable fashion. Random as in I couldn't be certain when it would happen, but predictable in that when it happened it was done in a reasonably consistent way. Using code that Andrew supplied, I dumped the shapes on each involved sheet expecting 4 items. The first sheet had 1524 shapes of which 1520 had a control=null. The remaining 4 were my real buttons and were scattered among the debris. Common sense says I didn't manually create and somehow abandon 1520 shapes. I had absolutely no code that tried to create or manipulate the buttons, so Sherlock Holmes would deduce that OO / LO did it. I only used the IDE to create these 4 buttons on the first sheet and then copied them to 20 other sheets using cut and paste within the IDE. The remaining sheets all had far lesser amounts of rubbish, but not one sheet had only the 4 buttons it was intended to have. I wrote code to remove the dead ends. It worked like a charm. I saved and reacquired the spreadsheet and then all the buttons were gone on all 21 sheets. I repeated the process several times all resulting in the same outcome. I also wrote code to reinflate my shrunken buttons to their required size. Again, the code worked perfectly and I traversed each sheet to make certain all was well. After a save and restart of LO, I get a bogus password error part way through loading the spreadsheet and the whole thing won't load. The spreadsheet is not password protected, so where did a password come from? On a damaged but working spreadsheet (shrunken buttons), if I move a sheet from one position to another, or attempt to delete a sheet, all is well during that session, but a save and LO reload fails, again with some internal bogus password error half way through the loading process. When LO was OO, I tried repeatedly to have knowledgeable people look at this sheet as it has developed numerous anomalies over the 6 years I've been developing and using it. It is a laboratory full of LO issues that need to be addressed as to how these things could have happened, but I could never get anyone's attention. I'm a professional programmer (operating system internals) and can smell logic errors in the application. The main line works well, but I suspect that bugs exist in the more obscure portions of the code base. Lets face it, it takes computer power to create 1520 dead end objects and I didn't write any such code. Every few months I suck out my 9000 lines of macro code and redevelop the spreadsheet shell it fits within to get rid of the accumulated rubbish. There are almost no formulas anywhere, as I just use the sheet as a convenient GUI. My macros do all the work. Why did I write this email? It was therapeutic for me, and I hope someone in LO calc development will take me up on my offer to supply and help debug strange occurrences as they occur. Short of that, I'm going to have to rewrite this as a web app with a compiled back end. It's a Point of Sale system used in my wife's restaurant and she needs something more reliable than the LO version. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk47TfAACgkQ7Orvev+eC8pm0QCePOi1W+ZdAK7S9OhcwVpKb2H8 qZIAoKfMAN7hJcKE5eOXXPAE5ZErf2LY =9UmO -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 corruption
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/04/2011 08:44 PM, Simon Cropper (The foss Workflow Guides) wrote: ... have you thought about code page errors? To answer your direct question - no I never considered code page errors. I'll check it out. Everything was developed on flavors of Fedora Linux starting on OpenOffice and now running on LO. I've blown this spreadsheet away numerous times over the years, keeping only my macros and a map of all the named cells I use as anchors. I wrote macros to reproduce the named ranges as I did that so often. I'd use one machine to bring up the old trashed spreadsheet and query it for cell widths, heights, colors, etc to reproduce the same sheet on another machine in a pristine environment. Add back my macros and go forward. That's a 2 day job of long tedious hours. Sometimes it would take months for something strange to start to happen, but it always does happen sooner or later. I'm not using any strange symbols. Its a simple POS system that accepts food orders, calculates costs, produces bills and receipts, does payroll, etc. Everything in it is mundane simple arithmetic and text. In the past, I hand massaged the xml files and pulled out huge sections of dead nested repetitive code. In one case I dropped the size of the .ods file by 110k worth of xml trash. I'm certain LO is not cleaning up after itself properly and leaving code droppings behind that cause this. I believe the IDE has some issues as it periodically does some strange things. On numerous occasions, I'd modify code in one module, switch to another module and make changes, save, reload and loose the first modules fixes. Infuriating! Am I supposed to remember to save for each module or should the IDE be smart enough to warn me I'm about to loose changes, or should it simply save everything when I say save? Something that trivial missing from the IDE says something. If you can insert a byte of data and cause LO to go berserk that only means it needs better insulation mechanisms to separate your data from its control codes. The developers should be thrilled to have you report finding a hole in their code so they can close it. If I as an end user can break it using only what was supplied to me to use, then the problem is in the LO product, and needs to be fixed. That's why I'm offering my help in supplying some pretty strange bugs and help in isolating and fixing them to the best of my ability. BTW - my internet connection is 16Kb/sec, when its up at all (Thank You TIGO/Honduras), so that is a tremendous limiting factor in what I can accomplish from here. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk47ZWsACgkQ7Orvev+eC8p7bwCeOR89xquRJhIYi5NJmGMm8uyq APIAnRdNKkvvv7qDqRfXVf/XBpULdaom =9NNM -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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] password problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/04/2011 08:44 PM, Bob Stia wrote: I have a document that I have had for years. Time to time I must open it, edit it and close it again. It is Libreoffice password protected. A few days ago I opened the fdocument and then after editing closed it agaim. The other night I tried to open it again and the password failed. Bob Look at what happens carefully. Even experiment on another test doc to see a slight difference that may be significant. I've experienced password failures on password protected documents part way through the loading process after it successfully took my password and then manufactured a bogus password failure message a certain distance into the loading process. The password failure messages are different depending on if you really keyed in a wrong password or it pops up a bogus message. Create a test document, password protect it and then ATTEMPT to open it with a bad password. Is that the password message your real doc is getting or is it another one? The other one is a bogus message after the file's been corrupted. I noticed this on a large spreadsheet that takes quite a while to load. It would take my password, start to load, and then fail some seconds later on some internal error and puts up a bogus message. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk47aXAACgkQ7Orvev+eC8o8WwCdErYUa/D+UaQMXVCz6fhBx23d gkkAnAwrgPvGI5DvA4LzHSh6S7XlXCCC =L4Ox -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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] Code snippet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote: I expect that you need to set this from the sheets draw page Thank You Andrew. I have a copy of your book back in Texas. I wish I had it here on the island. I wrote most of the POS system we use in our restaurant by referencing your book. It's 9000 lines of macro code. I was up on your web site yesterday and noted that you're putting out a new edition. I tried wrapping my head around UNO several times and failed. I just don't get it. I've hit api.openoffice.org trying to make heads or tails out of what's there, but no joy. The API is an impenetrable collection of unrelated spare parts as far as I'm concerned, and I'm a professional programmer (IBM Mainframes Linux O/S utilities). I can't seem to get the right approach or frame of mind to understand the API set and UNO in particular. That's why I had to ask for help, and you came through. Thank You. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk41nKcACgkQ7Orvev+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj cosAninW5UjFnmRKHrlpKVqsGubBLjrB =tKaN -END PGP SIGNATURE- -- Unsubscribe instructions: E-mail to users+h...@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] Code snippet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/31/2011 08:19 AM, Andrew Douglas Pitonyak wrote: If ashape.Control.Name = CName then Andrew FYI - I had to put an additional test in front of the above if statement as in: if not IsNull(aShape.Control) Some of the items returned do have Control=Null via the debugger. Other than that, It's working fine. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk413n8ACgkQ7Orvev+eC8p6wACghowvArWYqnDYmNIUnRVhWMEY 4H8An2fManqw04EYz2osfMiYhsvLVs5V =2N1t -END PGP SIGNATURE- -- Unsubscribe instructions: E-mail to users+h...@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
[libreoffice-users] Shrinking buttons
On 07/28/2011 01:23 PM, planas wrote: Please file a bug, I do not what the issue is. I have never seen any behavior like this myself. If you could give more details may be (very may be) someone monitoring the list may know what is happening. Here's more detail. I did quite a bit of experimentation on this so please bear with me. I developed the spreadsheet on a large laptop with a very high res display. When I run the spreadsheet on a low res netbook (1024x600) at 100% scaling factor everything starts out fine, but as the spreadsheet is used, the buttons I have on the 21 sheets start getting smaller and smaller vertically (Height) until some are so small you can't hit them. Width stays as originally intended. I have no code that attempts to manipulate the buttons. I created the buttons (3 of them) on one sheet and then copied them to the other 20 sheets on my development laptop. Even stranger is the fact that as these buttons are arranged one above the other vertically, within 1 large merged cell, its always the bottom button that shrinks to near invisibility. The middle button also shrinks but not as much, and the top button shrinks even less. Once the bottom button gets to its minimum size, (.02cm) shrinking seems to cease. If the spreadsheet is saved and reopened, the buttons are still shrunken. Something is rewriting the height of the buttons and a save keeps the shrunken height. The spreadsheet becomes unusable until I blow the buttons away and recreate them as that's easier than fixing them individually. After 12 hours of continuous use, with periodic saves, the bottom button on every one of the 21 sheets is invisible on a netbook. If I use the original undamaged spreadsheet on my laptop or a higher res desktop, this does not occur. This happens across 21 sheets and many of those sheets never get used as its slow season here and we only use about 5 sheets a day that represent the dining room tables for restaurant guests. I suspect its because I copied the 3 buttons from one sheet to the other 20 that they are somehow tied together and whatever is shrinking one shrinks them all. Having said that, a contra indication is that not all buttons shrink to the same size. There appears to be some randomness to the process that gets one button down to .02cm and the same button on another sheet down to only .06cm. Some other anomalies. In the same .ods file, I have a sheet that provides a composite view of the other 21 sheets to a limited extent. I have 21 buttons on that sheet arranged vertically that when hit bring up that particular sheet (dining room tables order). The last 7 buttons, shrink in height so that the bottom button is the smallest (but not completely invisible) and each above it is just a bit greater in height until we hit the 8th button from the bottom which is full height. These last 7 buttons represent dining room tables we're not using. We never hit those sheets and yet something is shrinking the last 7 buttons on my overview sheet. The difference in height between button 21 to button 20, between button 20 and button 19, ... towards the full size button is a constant. Its as though some loop is subtracting a constant height from the bottom 7 buttons. On my development machine, the above does not occur. It has something to do with the low res on the netbook. However, even on my mighty development laptop, if I delete any one of the 21 sheets, I loose every button on every remaining sheet. They all disappear. If I move a sheet from one position to another position, everything is OK till I save and reacquire the spreadsheet. At that point the entire spreadsheet is trashed as it won't open with some bogus internal password error. The unbroken spreadsheet is 254KB. I can upload it and provide the passwords used in it via a private email as I don't want the whole world knowing my business. Its occurred on Fedora 14 as Open Office 15 as Libre Office. We don't use Windows at all. -- Unsubscribe instructions: E-mail to users+h...@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
[libreoffice-users] Code snippet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've searched and can't figure out how to specify the height of a button at execution time via a basic macro. If Sheet1 contains a button name OK, how would I specify a button height of 0.5cm? The only examples I can find are for buttons on forms, not on a sheet itself. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk40jisACgkQ7Orvev+eC8rGHQCgmq3OwAJmVey+UVF051lvj9nj agYAoIiZ3ZEl5074W6+CpTowdUxilfcl =U2Iw -END PGP SIGNATURE- -- Unsubscribe instructions: E-mail to users+h...@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
[libreoffice-users] Shrinking buttons
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a spreadsheet containing 39 sheets, of which 21 are duplicates of one another. They represent tables in a restaurant. On an average laptop or desktop, everything is fine. When I load this up on a netbook with lousy resolution (1024x600), every time I save the file, the buttons on the 21 sheets get smaller and smaller till they some of them have a height of .06cm making them unusable. I leave the screen scaling at 100%. I manually went thru 10 of the sheets and using the forms control tool reset each button to its proper dimensions. Everything looked good as I went from sheet to sheet. I saved the file and brought it back up and the height that was .50cm is now .33cm or .31cm. Why they are different is a mystery. Another save and reload AND SOME OF THE BUTTONS are smaller still. I have no code that attempts to manipulate the buttons, so I conclude that LO is making the changes, and is making these changes permanent across saves. If I move the file back to my development laptop, its trashed. I understand scaling due to resolution issues, but rewriting my code permanently has got to be a bug. I tested this on Fedora 14 as OpenOffice and Fedora 15 as LibreOffice. Both display the identical problem. I can supply additional details, as the whole story has some additional twists, but I'd like to know if this will be taken as a serious issue. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 IM:billgradw...@gmail.com (No email please-IM only) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP 0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm =0qkh -END PGP SIGNATURE- -- Unsubscribe instructions: E-mail to users+h...@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
[libreoffice-users] Spreadsheet Problem
I have a fairly small spreadsheet that when I last opened it, all there was on the screen was a spreadsheet with a bunch of letter and numbers. Can anyone tell me what it is and how I might bet my data back in a form that I can read ? Thanks - Bill -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Download
Where do I click to download LibreOffice This is what I am looking at http://www.libreoffice.org/download/ I am just missing something obvious and I downloaded the Help Pack but when I click install it goes back to installing the help pack and then finds that I have already installed the help pack. Obviously I am just missing something simple, but I am really frustrated. Please advise Bill -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Download
Thanks that did it. I am just too use to eveything being an icon that I click on, which is what happened after I clicked up what you pointed out. My friend came bay and it was very easy for her but she deals with linux sometimes. Thanks, Bill On Sat, Apr 16, 2011 at 7:47 AM, aqualung xfekdcugj...@mailinator.comwrote: Bill Robison wrote: Where do I click to download LibreOffice This is what I am looking at http://www.libreoffice.org/download/ I am just missing something obvious and I downloaded the Help Pack but when I click install it goes back to installing the help pack and then finds that I have already installed the help pack. Obviously I am just missing something simple, but I am really frustrated. Please advise Bill -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted When I visit that page, I see a link for http://download.documentfoundation.org/libreoffice/stable/3.3.2/win/x86/LibO_3.3.2_Win_x86_install_multi.exe Did you download that and then double-click it? The person who published that download page may have thought it glaringly obvious that visitors would know to download both the huge 214 MB install file and the 10 MB help pack file, but that may not be the case always. If I may make a suggestion here, it would be to spell out that information explicitly. -- View this message in context: http://nabble.documentfoundation.org/Download-tp2827350p2828029.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Where do I click?
Hello, I clicked on Download and now I have all these options so I clicked on English Help Pack which loaded fine. But it does not help me download libreoffice. Is there a simple button anywhere that I can click on that leads me through your download procedure. I do not mean to sound like some MS junkie but I am use to clicking and then being led to the next page and so on. Robison2009 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] What happened to the delete row/column icons?
I have recently converted to LibreOffice from OpenOffice. I have a minor quibble - OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. I could do without the insert cells icons. Bill -- +---+ | Bill Purvis, Model Engineer | | email: b...@billp.org| +---+ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] What happened to the delete row/column icons?
On Monday 21 March 2011, Stefan Weigel wrote: Hi Bill, Am 21.03.2011 15:13, schrieb bill purvis: OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. When look at Tools | Customize... | Toolbars | Add... | Edit I can see an icon for Delete Columns as well as an icon for Delete Rows. I am using LibreOffice 3.3.1 on Ubuntu Linux 10.10. Stefan Great! Thanks a lot. I was sure that it must be somewhere but I've obviously not learned how to find my way round it. Bill -- +---+ | Bill Purvis, Model Engineer | | email: b...@billp.org| +---+ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] advice
i don't use openoffice. with the exception of some screwball canadians who appear to be using wordperfect every individual to whom i send a business document uses microsoft word. i am a wordsmith, i have little use for graphics. however my document headings are formatted to give a decent title page. i found that when i created a simple title page in openoffice and saved it in .doc format and then opened it with my microsoft word even the simple text box and drawn black lines came back scrambled. when i opened a word document in openoffice it looked perfect, but then when i simply saved it and re-opened it in word it was scrambled again. i would love to use libreoffice to replace my office 2007. however i need near to absolute assurance that the document i create is going to be the document my clients/associates/customers receive and to the best of my knowledge every one of them will open it with some version of word. this is far more important to me than any feature no matter what it might be. i cannot claim to be sending a client a renoir and have them open a picasso. bill topp otisville ny -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
plino pedlino at gmail.com writes: Bill, do the cells in the range contain only natural numbers? I suspect that you are having a problem with the decimal separator. Your cells are probably identified as text because of that (are the values aligned to the left?) Paste this in cell D2 to check =VALUE(C2) Hello, Plino: This is a second reply. After I wrote you earlier, I tried re-importing the .csv file. This time, I clicked on the Standard heading on top of the column in question, hoping there would be a format for Currency. There was none, but after I clicked Hidden then clicked back to Standard, the file imported with the currencies properly recognized and aligned to the right. Now the =SUM(c2:c46) function works just fine. I am sorry for wasting so many people's time, but I could not figure this out by myself. I am very grateful to everyone involved for their suggestions. One final question: Shouldn't the Import function recognize currencies automatically rather than making the user jump through these hoops? Sincerely/Bill Woodruff -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
Mark mhullrich at gmail.com writes: A sum range is =SUM(C2:C46) - could that be (part of) it? Mark Hello, Mark: Thank you for your prompt reply. I apologize, but I mis-punctuated my original message. The formula, as you correctly observe, is =SUM(C2:C46) --and that's pasted directly from the spreadsheet. However, it still returns a result of 0 (zero). I've been working with spreadsheets (mostly Excel) since the days of Lotus Symphony. I had high hopes for LibreOffice and have had good results with the document package so far. But this spreadsheet behavior is driving me nuts. I would appreciate any suggestions. Would you like me to e-mail you a copy of the spreadsheet? Sincerely/Bill Woodruff -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
