Re: [libreoffice-users] trying (again) to get conditional text to work [solved]
On 2023-10-03 11:55, Gary Dale wrote: I'm running LibreOffice Writer 7.5.6.2 on a Debian/Trixie system. I'm driving certificate production from a database (spreadsheet). I'm trying to get a simple text replacement to work. The field is type "Conditional Text". The condition is [Fun-Run-2023].[Race-17799-final].sex EQ "F" - where the first bit in [] is the database name and the second bit in [] is both the spreadsheet's name and the sheet's name (when I'm in Base, it shows as the table name). The "Then" & "Else" are defined to do the obvious substitutions except I always get the "Then" branch and never the "Else". I could just do the substitution in the spreadsheet, but I have other things I need to make conditional as well. Can anyone identify what I'm doing wrong? Thanks. I got it to work by renaming the database to "Fun_Run_2023" and the data sheet to "final". Apparently Writer doesn't (currently?) respect the [] characters. -- 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] trying (again) to get conditional text to work
I'm running LibreOffice Writer 7.5.6.2 on a Debian/Trixie system. I'm driving certificate production from a database (spreadsheet). I'm trying to get a simple text replacement to work. The field is type "Conditional Text". The condition is [Fun-Run-2023].[Race-17799-final].sex EQ "F" - where the first bit in [] is the database name and the second bit in [] is both the spreadsheet's name and the sheet's name (when I'm in Base, it shows as the table name). The "Then" & "Else" are defined to do the obvious substitutions except I always get the "Then" branch and never the "Else". I could just do the substitution in the spreadsheet, but I have other things I need to make conditional as well. Can anyone identify what I'm doing wrong? Thanks. -- 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] conditional formatting based on day of week
Thanks. Good solution. On 2021-05-28 20:38, Michael D. Setzer II wrote: Try this: Highlight full range of Area In my test A1:F419 For Condition 1 Set to Formula is: Formula to weekday($a1)=1 Weekday returns 1 for Sunday on my setup (1 to 7) Just select ERROR as Style (for testing) With the $a1 it will hightlight whole row of data instead of just that column. On 28 May 2021 at 18:01, Gary Dale wrote: To: LibreOffice Users From: Gary Dale Subject:[libreoffice-users] conditional formatting based on day of week Date sent: Fri, 28 May 2021 18:01:38 -0400 It's been years since I tried to do anything with conditional formatting and now I can't seem to get it right. I have a spreadsheet sorted in date order where I want to highlight the start of each week (i.e. Sunday) to divide up the data visually. My idea was to test if the date cell in the current row was a Sunday, so I constructed the formula as: (WEEKDAY(ADDRESS(ROW(), "B"), 2) = 0) where column B contains the dates. I apply that condition to a selection that excludes the column titles and set the formatting to a background highlight. Unfortunately it doesn't do anything and I can't figure out why. Any ideas? Thanks in advance. -- 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 ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] conditional formatting based on day of week
Thanks. I misread the help document on Weekday, and didn't read the
ADDRESS help. I initially was using INDIRECT but it wasn't working for
the reasons you mentioned.
On 2021-05-28 20:29, Brian Barker wrote:
At 18:01 28/05/2021 -0400, Gary Dale wrote:
It's been years since I tried to do anything with conditional
formatting and now I can't seem to get it right. I have a spreadsheet
sorted in date order where I want to highlight the start of each week
(i.e. Sunday) to divide up the data visually. My idea was to test if
the date cell in the current row was a Sunday, so I constructed the
formula as:
(WEEKDAY(ADDRESS(ROW(), "B"), 2) = 0)
where column B contains the dates. I apply that condition to a
selection that excludes the column titles and set the formatting to a
background highlight. Unfortunately it doesn't do anything and I
can't figure out why. Any ideas?
Yup! There are a number of faults here:
o The ADDRESS() function requires the *number* of columns and rows,
not their letter designations, so you need 2 for the column, not "B".
o The ADDRESS() function requires a third parameter, indicating what
sort of cell reference you need. It probably doesn't matter which you
choose, but you do need to specify it. Choose 1 for absolute,
producing "$B$n".
o The result of the ADDRESS() function is text, not a cell reference.
You would need to apply the INDIRECT() function to the text in order
to interpret it as a cell reference. But the INDIRECT() function will
do the work for you, so ditch the ADDRESS() function and use
INDIRECT("$B$"&ROW())
instead.
o The WEEKDAY() function never gives 0 for Sunday. Instead it gives 1
if Type is 1 or omitted and anything else you want between 1 and 7
depending on Type, but never 0.
o The containing parentheses are unnecessary and probably confusing.
Try something like:
WEEKDAY(INDIRECT("$B$"&ROW()))=1
I trust this helps.
Brian Barker
--
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] conditional formatting based on day of week
It's been years since I tried to do anything with conditional formatting and now I can't seem to get it right. I have a spreadsheet sorted in date order where I want to highlight the start of each week (i.e. Sunday) to divide up the data visually. My idea was to test if the date cell in the current row was a Sunday, so I constructed the formula as: (WEEKDAY(ADDRESS(ROW(), "B"), 2) = 0) where column B contains the dates. I apply that condition to a selection that excludes the column titles and set the formatting to a background highlight. Unfortunately it doesn't do anything and I can't figure out why. Any ideas? Thanks in advance. -- 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] Epson XP-820 paper size setup
I'm running Debian/Bullseye and the printer is attached via USB cable. My LibreOffice version is 7.0.3.1. My CUPS version is 2.3.3op1. The printer is using the Epson ESC/P-R driver. The printer works fine but one thing is driving me crazy. I need to print to a 244mm x 149mm envelope sometimes. This should load through the rear paper slot which is provided for this purpose. However I can't tell Writer to use this size. The envelope is defined as that size but I can only select one of a list of paper sizes for that printer in the Print dialogue. I have the same problem when I try to load the envelope into a paper tray. I can tell the printer what size it is but that still doesn't show up in Writer when I try to print. To make things weird, a number of the paper sizes are given as "User Defined: 9.999in x 9.999in" but I have no idea how they got there - although some seem to be standard sizes (photos, envelopes, etc.). Through trial and error (one or more errors per trial), I've come close to getting an envelope to print reasonably without spraying ink outside the paper range. However, the envelope document only vaguely resembles what is printed. And I have to go through this again if I try to print to a different paper size. Is there a way I can tell Writer to use the paper size of the document so that it actually prints the way I set it up? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] adding / using custom colours to LibreOffice
On 14/10/17 07:37 PM, Toki wrote: On 10/14/2017 04:29 PM, Gary Dale wrote: With a GUI, you just need to know the colour codes and names. Time yourself creating the Sherwin-Williams Paint Colour Palette. Which do you think people are more likely to use? An organisation will hire somebody to construct the colour palette. An individual that needs new palettes on a regular basis, will learn the appropriate XML. jonathon You're labouring under the delusion that organizations all have budgets to do such things. There are large numbers of organizations that only have a one or a small number of people working on documents. And they will not want to use the savings from not having to pay for LibreOffice to be exceeded by having to hire someone to create a palette. -- 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] adding / using custom colours to LibreOffice
On 12/10/17 10:47 AM, Tim-L wrote: On 10/11/2017 02:43 PM, Toki wrote: On 10/11/2017 02:48 PM, Gary Dale wrote: Either way, with that many palettes in play, there should be a way to manage them other than fiddling with XML files. Palettes are function specific. As such, if made according to the user specifications, there is no legitimate reason to change anything within them. I agree that there are some users do not want to create a color palette, but add just a few colors they need to use. I remember doing that a few years ago, for a specific project, before I looked into creating my first color palette. That seems to be the reason for the "custom" palette - which I currently have empty. In terms of creating the palette, it is several orders of magnitude easier to do so, using XML, than colour pickers. (Try creating the Resena Paint colour palette using a GUI. Doable, but instead of taking ten or so minutes, you'll spend hours, and need a second person to proof read the resulting XML file.) Yes creating the XML palette is easy to do. All you need is to rename one of the small color palettes and then replacing the values of a line - like this one - with your colors. All you need to do is copy/paste this type of line, then replace the "Tango: Aluminium 3" with a new name. Then, change this HTML color value of "#babdb6" to the color you want to use. I have a color palette with Resena colors - over 1370 of them. I added LibreOffice Branded colors, as well of a few others, bringing the total to about 1400 of them. Below is the color palette file and then the PDF file of 10 pages with the color names and HTML color codes. http://libreoffice-na.us/colors_resene.soc http://libreoffice-na.us/resene-a--Alphabetical-Color-Chart.pdf I do have other PDF files for other color palette PDF files. Only some of them are listed on the "libreoffice-na.us" site. The Resene palette is not in the same order as the PDF file. I have 6 versions with it either unsorted or sorted by different methods. using these PDF files, I have searched for specific colors/hues, like wood-brown, gold-like, oranges, etc.. Then I created SOC files for these type of colors. The PDF files for the large ones, can be found on a web site link on the top of each page of these PDF files. They are a great way to see defined color names and their associated HTML color code. Luck was with me when I was given the text list of colors for several large SOC files. To be honest, if you use a color picker on these PDF color "boxes" you may find the visible color may not be the exactly same color code as listed in the page. The problem might stem from the software that converted the image files to the PDF pages. Also, for me, my printed pages are darker then what is shown on the display/monitor. Syncing the printer to my laptops and desktops is not something most users can do for themselves. Also only a few printers have drives with options to "tweak" the printed colors. FYI: The palette list I see is: standard standard What is the extension of those two files? Regardless, no OS allows two files in the directory to have an identical name. Some operating systems allow filenames to differ, only by case that used for one or more glyphs. jonathon Yes, Color.soc and color.soc are different on Ubuntu Linux, but as one professor stated "think of the Windows file names as all uppercase or lower case names. . . ". I have run into this type of limitation with transferring files from my Ubuntu laptop to a NTFS or Fat32 USB flash drive and/or to a Windows format external drive. Between the /opt/ root system folder[s] and the hidden .config "home" folder [Linux install], I have 11 installed palettes and a few in the works While for someone literate in XML, creating a palette in XML is not a big deal, that's not your typical end user. At one point most people created formatted text files by embedding descriptions of the text formatting into the text file. Some still do, but doing it through a GUI like Writer or one of the LaTex front ends is the more usual route. To create a palette using a text editor you have to research the format and find out where to store the file in addition to knowing the colour codes and names. With a GUI, you just need to know the colour codes and names. Which do you think people are more likely to use? -- 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] adding / using custom colours to LibreOffice
On 10/10/17 10:34 AM, Tim-L wrote: On 10/10/2017 04:23 AM, Toki wrote: On 10/10/2017 03:38 AM, Gary Dale wrote: I agree that storing organizational (not necessarily corporate) colours in "custom" may not always be the best idea, but given their small number in any rational organization, creating a separate palette for them is arguably also not a good idea. The primary function of an organisation branding palette, is to have a formal description of the _only_ colours used in content produced by, for, or on behalf of the organization. As such, having _one_ palette that consists only of the organisation branding palette makes sense. By way of example, the official colour palette of various organisations: * LibreOffice: 27 colours; * North Carolina State: 13 colours; * University of Leeds: 4 colours; * University of Arizona: 22 in the official palette, 24 in the unofficial palette; * University of South Dakota: 9 colours for printing, 9 colours for the web; * UPS: 4 colours; Back when Mary Kay was alive, woe betide anybody who delivered anything for her company, that wasn't in a colour that wasn't in the official Mary Kay colour palette. (_Even their Uzi's Are Pink_ wasn't much of an exaggeration.) jonathon If creating a small color palette is not a good idea, then add more colors to it AFTER you have the "company" colors. You could start with the - company's colors, then LibreOffice colors, then the web safe colors, and any other colors you might want to use. Your custom palette can represent all of the colors you use, not just the small number of official colors your company uses. They can be in any order or groupings. As for the post stating concern about creating/editing XML files, do not worry. It is really easy. If you make a mistake, then the palette you create will not effect others. That is why I use the LibreOffice .config folder for the SOC file[s] for testing and more. If you have Windows, it might not be as easily as I have with Ubuntu Linux. Still, the color palette file[s] is a lot easier than other XML files I have seen from other applications Still misses the point. Normal users shouldn't have to fiddle around with XML files to create custom palettes. LibreOffice already has at least two dialogues that allow users to define custom colours. The real problem are that they: 1) are different, with each one having features the other lacks 2) aren't where a normal user would expect to find them. The Format | Character | Font effects | Pick a Color dialogue allows you to define colours in RGB, HSB and CMYK formats but doesn't allow you to name the colour nor save it to a palette. This is the same dialogue as used for Shapes | Line colours. Conversely the Shapes | Area colour dialogue only allows you to define RGB colours (unless you notice the "pick" button, which then brings up the other colour dialogue instead of bringing up an eye-dropper to let you pick a colour from elsewhere on your screen) but lets you give them a name and save them in the custom palette. This is a bizarre duplication of effort. Why are area colours given second class status with respect to how you define them while line and character colours are given second class status with respect to being reusable? A secondary concern is why isn't there a palette management tool? There are 11 palettes available in my copy of Writer. I'm not sure if that is normal or not since two of them are named "standard". Are some of them from other applications? Either way, with that many palettes in play, there should be a way to manage them other than fiddling with XML files. At the very least, a simple tool to create a named palette and add colours to it shouldn't be difficult to add to the Tools | Options dialogue. Then you wouldn't need to be able to add custom colours through other dialogues, which would simplify the application. FYI: The palette list I see is: custom standard tonal standard html breeze chart-palettes libreoffice freecolour-hlc tango Document colors The last one seems to be auto-generated to show all the colours used in the current document. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] adding / using custom colours to LibreOffice
On 09/10/17 02:20 PM, Regina Henschel wrote: Hi Gary, Gary Dale schrieb: I'm using 5.4.1.2.0+ on a Debian/Buster AMD64 system. I volunteer with several organizations, some of whom have standard colours that I would like to add to the LibreOffice colour palette. However the formerly available Tools | Options | Colors customization feature seems to have disappeared. Yes it was removed to reduce complexity for normal users. I noticed that the font colour chooser allows you to use custom colours but not add them to the palette. While usable, it's not a good solution when you are going to be using the same colours repeatedly. If you, as single user, need a color repeatedly, then you can add this color to your personal palette "Custom". It is not a real palette, but part of your personal registrymodifications.xcu. This file holds the recent colors too. But a normal user does not need to know these details. After more googling, I eventually found a way of adding custom colours - by creating a shape then right-clicking on it and selecting area. This allows me to add colours to the custom palette (and apparently only the custom palette - even if I select a different palette, the new colour ends up in custom). If you want to maintain "corporate identity" colors, storing them in "custom" is wrong anyway. So do not try to find any "tricks". You should use a *.soc file stored in share/palette for those colors. You can add the colors to one of the existing files or make a totally new such file. The file is a simple xml-file and can be edit with any editor. You only need to add one line per color following the example Instead of "Black" you write the text, which the user will see. Instead of 00 you write the code, which you see in the 'Hex' field in the Area > Color dialog. If you work in Draw you can use Format > Area without any need of a shape. That way each user, who will use LibreOffice will get these special colors automatically. You need writing rights from the OS to change or add files in share/palette. Kind regards Regina I'm frankly dumbfounded by your explanations. You remove a generally useful dialogue to reduce complexity for normal users while simultaneously maintaining two different dialogues to set colours, each of which looks and works differently. Then you suggest that to do something that is in the use case of any normal organizational user (i.e. just about anyone who uses a word processor), you suggest creating/modifying XML files! I agree that storing organizational (not necessarily corporate) colours in "custom" may not always be the best idea, but given their small number in any rational organization, creating a separate palette for them is arguably also not a good idea. My preference is to just add them to the standard palette and let the colour names identify them. You've already got all the code you need to address the problem properly. Writer's code just isn't organized properly. If it was, you wouldn't have the two (maybe more - I haven't really looked) dialogues doing largely the same job but neither doing it really well. -- 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] adding / using custom colours to LibreOffice
I'm using 5.4.1.2.0+ on a Debian/Buster AMD64 system. I volunteer with several organizations, some of whom have standard colours that I would like to add to the LibreOffice colour palette. However the formerly available Tools | Options | Colors customization feature seems to have disappeared. I noticed that the font colour chooser allows you to use custom colours but not add them to the palette. While usable, it's not a good solution when you are going to be using the same colours repeatedly. After more googling, I eventually found a way of adding custom colours - by creating a shape then right-clicking on it and selecting area. This allows me to add colours to the custom palette (and apparently only the custom palette - even if I select a different palette, the new colour ends up in custom). While this is sufficient for what I want to do, it seems rather arcane to bury this useful option in shapes when it clearly can be used for anything that has colour. To make matters worse, the font colour | custom colour dialogue allows you to define colours using RGB and CMYK values while the shape colour dialogue only allows RGB colours (but does allow you to save them). I suggest that the developers should fix this duplication of effort by using only a single colour dialogue that combines the best features of both existing dialogues. They should also restore this to the Tools | Options menu. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] calc: vlookup not behaving in one spreadsheet
Thanks. That explains everything.
On 06/10/17 08:23 PM, Remy Gauthier wrote:
Hi,
I think your issue comes from the changes introduced in Version
5.3. The V5.3 release notes
(https://wiki.documentfoundation.org/ReleaseNotes/5.3#Calc) say the
following:
Option settings
* In new installations the default setting for new documents is now
*Enable wildcards in formulas* instead of regular expressions.
tdf#88581
<https://bugs.documentfoundation.org/show_bug.cgi?id=88581> (Eike
Rathke (Red Hat, Inc.))
o This is for better interoperability with other spreadsheet
applications and a better experience for users who are not
familiar with regular expressions. Wildcards are more
widespread and the large set of regular expression
metacharacters often makes queries too complicated for casual
users.
o See also ReleaseNotes 5.2 for wildcards
<https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2>.
If you go to Tools -> Options -> Calc -> Calculate and enable "Enable
regular expressions in formulas", it should work (at least, it does
for me). You can also change your ".*" to just "*" to make it work
(but that will prevent the other spreadsheet from perhaps working
correctly).
If you want to be more robust, you could use a dedicated worksheet
that has a small array of lets say 1 columns and 6 rows. In column 1
(starting at A1), you place a, b, c, d a, e, f and in column 2
(starting at B1), you place 1, 2, 3, 4, 5, 6, like this:
a 1
b 2
c 3
d a 4
e 5
f 6
Create a named cell (for instance "Wildcard" without the quotes) that
contains this formula:
=IF(ISERROR(VLOOKUP("d"&"*",A1:B6,2,0)),".*","*")
You can then use something like this as your search element the lookup
function: UPPER(TRIM(C2)&" "&TRIM(E2)&Wildcard
I tried to use an inline matrix instead of A1:B6 but I did not get any
good results. If anyone has an idea, I would be interested in knowing
how to do it (it would require only one cell instead of 7 (6 for the
array, 1 for the result)).
I hope this helps.
Rémy Gauthier.
Le vendredi 06 octobre 2017 à 18:46 -0400, Gary Dale a écrit :
I have two spreadsheets. I created the first back in June. It uses two
sheets, one for registration information (Entrants) which I download
from a site that takes registrations for races, and the other (Results)
I download from a site that the timer posts results to. The second sheet
has the standing information while the first has all the entrant
information. I can relate the two by the entrant's name, which is 3
columns in the first sheet and 1 (uppercase) column in the second using
the formula:
=N(VLOOKUP(UPPER(TRIM(C2)&" "&TRIM(E2)&".*"),Standings.C$2:J$37,8,0))
where C & E are the first and last name columns on Entrants, Standings.C
contains the combines first and last names and column J is the number I
want (standing within a division by age and gender). A failed lookup
would mean the person registered but didn't complete the event.
This works in the spreadsheet I created in June but doesn't work in the
spreadsheet I just created. I traced this down to the &".*" part of the
search term. This was intended to handle trailing spaces or other
extraneous characters after the person's name. The spreadsheet I created
in June didn't have any but the one I just created did. However removing
the trailing spaces from the Standings names didn't help. The formula
simply didn't work.
Replacing the &".*" with a simple &" " to assume that the names always
have a trailing space did work, as did removing the trailing spaces and
leaving out the &" ". However the original formula works on the June
spreadsheet with or without trailing spaces in the names.
I'm working with both spreadsheets on the same computer using the same
copy of LibreOffice Calc (5.4.1.2.0+ on a Debian Buster AMD64 system). I
can have them open side by side to demonstrate the problem (it's also
how I copied and pasted the formula between the two - multiple times -
to ensure that it wasn't a typing error).
Does anyone have any ideas on what could be going wrong?
--
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: vlookup not behaving in one spreadsheet
I have two spreadsheets. I created the first back in June. It uses two sheets, one for registration information (Entrants) which I download from a site that takes registrations for races, and the other (Results) I download from a site that the timer posts results to. The second sheet has the standing information while the first has all the entrant information. I can relate the two by the entrant's name, which is 3 columns in the first sheet and 1 (uppercase) column in the second using the formula: =N(VLOOKUP(UPPER(TRIM(C2)&" "&TRIM(E2)&".*"),Standings.C$2:J$37,8,0)) where C & E are the first and last name columns on Entrants, Standings.C contains the combines first and last names and column J is the number I want (standing within a division by age and gender). A failed lookup would mean the person registered but didn't complete the event. This works in the spreadsheet I created in June but doesn't work in the spreadsheet I just created. I traced this down to the &".*" part of the search term. This was intended to handle trailing spaces or other extraneous characters after the person's name. The spreadsheet I created in June didn't have any but the one I just created did. However removing the trailing spaces from the Standings names didn't help. The formula simply didn't work. Replacing the &".*" with a simple &" " to assume that the names always have a trailing space did work, as did removing the trailing spaces and leaving out the &" ". However the original formula works on the June spreadsheet with or without trailing spaces in the names. I'm working with both spreadsheets on the same computer using the same copy of LibreOffice Calc (5.4.1.2.0+ on a Debian Buster AMD64 system). I can have them open side by side to demonstrate the problem (it's also how I copied and pasted the formula between the two - multiple times - to ensure that it wasn't a typing error). Does anyone have any ideas on what could be going wrong? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: background images in business cards
On 22/12/16 04:01 AM, Alexander Thurgood wrote: Le 21/12/2016 à 23:56, Gary Dale a écrit : The behaviour you describe is reported as : https://bugs.documentfoundation.org/show_bug.cgi?id=34585 https://bugs.documentfoundation.org/show_bug.cgi?id=62505 https://bz.apache.org/ooo/show_bug.cgi?id=20209 https://bz.apache.org/ooo/show_bug.cgi?id=32724 One can see from the OOo bug reports that there was already a call to have NoFill equate to 100% transparency, even back then. Alex Merci. It makes me wonder why anyone thought the current behaviour was somehow a good idea. :( -- 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] background images in business cards
On 22/12/16 01:50 PM, Tim---Kracked_P_P---webmaster wrote: On 12/21/2016 11:10 PM, Gary Dale wrote: On 21/12/16 06:46 PM, Don Myers wrote: Hi Peter, In the download section at World Label, there are templates for OpenOffice/LibreOffice. These are table style templates, and they work beautifully. Yes but the fact that you can get around a bug doesn't mean the bug doesn't exist. :) Wow I never saw that issue before. Tried every way to have an image in the background [5.2.3.3 DEB] and I cannot seem to get your "fix" working. I am wondering if the text's "internal white space" can be made transparent? That is where I seem to get the current issues. I wonder if it would be too much to create a business card image file - with the background - in GIMP or DRAW and then just place that image in the first card space and sync all the rest of the card spaces? How much of a "pain" would it be to do that till the bug gets fixed? I use the Background options with WRITER created fliers, posters [US Letter to 13x19 inch], and other documents. I really would have thought it would work the same in the Business Card Templates. The problem with creating a single image for the entire card is that you can't use a database to fill it easily - such as the same card design for multiple employees, just with different names and contact information. The problem doesn't seem to the "internal white space" so much as the page the text sits on. You can make the page transparent (Format | Page | Transparency - set to 100%) which fixes the problem. It's just not very intuitive. -- 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] background images in business cards
On 21/12/16 06:46 PM, Don Myers wrote: Hi Peter, In the download section at World Label, there are templates for OpenOffice/LibreOffice. These are table style templates, and they work beautifully. Yes but the fact that you can get around a bug doesn't mean the bug doesn't exist. :) -- 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] background images in business cards
On 21/12/16 06:25 PM, Peter Hillier-Brook wrote: On 21/12/16 22:56, Gary Dale wrote: This is ridiculous. I've just been reading a question from a 2008 (3.2) version of OpenOffice.org that is the same as my current problem. Namely that you can't place images in the background on a business card. I'm using LibreOffice 5.2 (Debian) and when I insert an image, it refuses to go behind the text whether I select Arrange | Send to back or Wrap | wrap through. It will go behind the text if I select Wrap | in background but then it disappears. And no, before you ask, the paragraph fill is set to none. I finally found a setting in Format | Page | Transparency where setting the transparency to 100% worked. Strangely the original setting was 50% which resulted in the background image being hidden completely. A quick experiment revealed that ANY setting other than 100% hid the background image. I have no idea what this "feature" is for but it seems completely unintuitive and in conflict with the paragraph background setting, not to mention the wrap in background feature. So my beef is: 1) Arrange doesn't appear to work on labels, 2) wrap through doesn't appear to work on labels, 3) there seems to be a page background that is in front of any background image, 4) the transparency setting for that page background only has two values - 100% or opaque, and 5) this situation has been around for at least 8 years without being fixed. Why can't the developers address these basic problems? If you use a table for your layout then placing an image in the background behaves as you would wish. Sadly LibreOffice uses a frame-based layout for labels and that might be where your problem lies. I do not experience problems with my Avery business card stock using the table based approach. Peter HB I am using Avery business card (5371 - white letter size) template. I gather you are suggesting creating a table to do the layout rather than simply using the normal paragraph/text tools. That would place the table above the graphic background, obviating the problem instead of fixing it. Given that it doesn't work this way when creating, for example, letterhead, I still fail to see why this should be treated as anything other than a long-standing bug. I created letterhead for the same organization using the same graphic and Wrap through and Wrap in background both work. Wrap through has the image above the text while wrap in background has the text above the image. Page transparency is irrelevant. Perhaps the developers have some reason why the user experience for these two similar types of documents should be so different but It strikes me as a flaw in the user interface that should be fixed. -- 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] background images in business cards
This is ridiculous. I've just been reading a question from a 2008 (3.2) version of OpenOffice.org that is the same as my current problem. Namely that you can't place images in the background on a business card. I'm using LibreOffice 5.2 (Debian) and when I insert an image, it refuses to go behind the text whether I select Arrange | Send to back or Wrap | wrap through. It will go behind the text if I select Wrap | in background but then it disappears. And no, before you ask, the paragraph fill is set to none. I finally found a setting in Format | Page | Transparency where setting the transparency to 100% worked. Strangely the original setting was 50% which resulted in the background image being hidden completely. A quick experiment revealed that ANY setting other than 100% hid the background image. I have no idea what this "feature" is for but it seems completely unintuitive and in conflict with the paragraph background setting, not to mention the wrap in background feature. So my beef is: 1) Arrange doesn't appear to work on labels, 2) wrap through doesn't appear to work on labels, 3) there seems to be a page background that is in front of any background image, 4) the transparency setting for that page background only has two values - 100% or opaque, and 5) this situation has been around for at least 8 years without being fixed. Why can't the developers address these basic problems? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Local data in writer pulldown list
On 24/10/16 04:22 PM, ponsiarceds wrote: Gary Dale wrote It's actually a little more complicated. In order to create the list box, you need to select a data source. No, using LO 5.2.2 I simply open Writer and 1. selected the listbox icon from the Form Controls toolbar then 2. clicked and dragged the outline of a listbox on the page 3. (as mentioned previously) Are you perhaps using the wizard instead? Yes, when I go into Design Mode then Insert | Form Controls | List Box, it brings up the wizard after I draw the list box. It also does that if I I use the Form Controls toolbar. Since the dialogue pops up in each case, it's not obvious that you can simply cancel it without also losing the form control. So I guess my real complaint is about the wizard being rather the opposite - something that gets in the way of a simpler process. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Local data in writer pulldown list
On 22/10/16 11:21 PM, ponsiarceds wrote: 1. Right mouse click on the list box, choose control 2. On the 'General' Tab, choose List entries. 3. type your first entry BUT press Shift+Enter to make non-breaking space for the 2nd entry 4. repeat as necessary. 5. Choose File>Export as PDF. 6. Select the 'Create PDF Form' option. I left the Submit format as 'FDF', & it worked in qpdfview, prompting me to save when I exited. I'm afraid you'll need to research the other options. Thanks. It's actually a little more complicated. In order to create the list box, you need to select a data source. Then when you go to edit it, before changing the General entries, you need to clear out the Data bits and change the Type of list contents to Value list. Otherwise the list entries is greyed out. Interestingly, the document remembers the data source even though it's no longer in use, so creating subsequent list boxes, etc. use the same data source. However, unlike a form letter, a data entry form could have several data sources (different lists). In fact, I'd suggest that it would be rare for different list boxes in the same document to use the same data source. This suggests to me that the Insert List Box dialogue is designed incorrectly. It should ask for the data source (type and value) instead of forcing you to use a database link. -- 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] Local data in writer pulldown list
I want to create a fillable PDF form using Writer but I'm stuck on one issue. When selecting one of a choice of options, it can be done with a pulldown list or a set of radio buttons. The pulldown list is the simpler way and it uses a lot less real estate on a page, but Writer wants to connect it to a database. I can see this might be useful in some rare instances but creating a fillable PDF isn't one of them. Such a document, or even a Writer form, normally needs to be self-contained so it can be distributed. If Writer simply wants to load the options one time from the database then it should also be possible to insert them directly into the document but I can't see a method to do this. If it wants to maintain the connection to the database so that it loads them when the pulldown is activated, then it makes the feature rather useless. Is it possible to create a pulldown list and fill in the options without connecting to a database? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to change Writer form letter database connection
Thanks Paul. You're right, that does work. However it begs the question of why bother to bring up the database selection dialogue in the initial Mail Merge panel - especially given that it doesn't actually work? IMHO the Edit | Exchange Database menu item is a travesty that should be removed. Instead the database selection dialogue in the Mail Merge panel should be used at run time to select the database/query rather than just the specific records. I will further note that having to go through arcane gyrations to change the query is also nuts. A common use case to have multiple different queries that can be associated with a specific form letter. Each query would be given a meaningful name and the secretary / office administrator who is responsible for the getting the letters out selects the appropriate one. Again, this functionality appears to be present in the Mail Merge panel but doesn't work. Or to put it in more direct terms, the database/query selection should be part of the mail merge operation, not part of the document definition. The document should contain simply the database field name. On 14/10/16 11:20 AM, Paul D. Mirowsky wrote: In my circumstance, I am copying over an old database to a new one and changing the name. Then I add new data to the new database. After that I update the query to access the new data only. I copy over to a new database as a way to remove old records (data) and keep Base from losing it when it has to many records. No data lost and old data is stored away. In every case, in Writer, from the menu , I select the new database and select the new query. All fields update appropriately except which I do manually. As I understand it, if you are not changing database or fields. You should be able to just update your query to select the records you want. Hope this helps. On 10/13/2016 4:46 PM, Gary Dale wrote: On 12/10/16 11:00 AM, Paul D. Mirowsky wrote: Are the field names identical from original to newer data? Are you creating new/updated queries? I'm always switching to new single source databases from boilerplate Writer and haven't had a problem. I have not tried multiple sources though. Also beware that while the fields may update to the new data, record> has to be applied manually. (Seems to be true in most versions of LibreOffice). I'm using a Base database (pasted the data in from a spreadsheet so I could run queries that were apparently too complex for simple conditional text). The field names haven't changed. If they did, then I would expect that I'd have to update the merge document. When I View | Field Names (ctrl-F9), I not only see the database name for both the old database (in the fields that I haven't updated manually) and the new database (in the fields that I did re-insert to this year's database) but also the name of the query that was used. This is absurd. The form letter should just contain the name of the fields and let the user select which database and/or query they wants to use. As it stands, I am apparently required to not only stick with the same database but also keep the same query name. Even the menu item (Field Names) seems to be poorly thought out. Toggling it switches the view from just the Field Names to the full database, query, Field Names. In both cases I see Field Names. It probably should be named "Query Path" - although as I have stated, the document shouldn't even use that information. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to change Writer form letter database connection
On 12/10/16 11:00 AM, Paul D. Mirowsky wrote: Are the field names identical from original to newer data? Are you creating new/updated queries? I'm always switching to new single source databases from boilerplate Writer and haven't had a problem. I have not tried multiple sources though. Also beware that while the fields may update to the new data, record> has to be applied manually. (Seems to be true in most versions of LibreOffice). I'm using a Base database (pasted the data in from a spreadsheet so I could run queries that were apparently too complex for simple conditional text). The field names haven't changed. If they did, then I would expect that I'd have to update the merge document. When I View | Field Names (ctrl-F9), I not only see the database name for both the old database (in the fields that I haven't updated manually) and the new database (in the fields that I did re-insert to this year's database) but also the name of the query that was used. This is absurd. The form letter should just contain the name of the fields and let the user select which database and/or query they wants to use. As it stands, I am apparently required to not only stick with the same database but also keep the same query name. Even the menu item (Field Names) seems to be poorly thought out. Toggling it switches the view from just the Field Names to the full database, query, Field Names. In both cases I see Field Names. It probably should be named "Query Path" - although as I have stated, the document shouldn't even use that information. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to change Writer form letter database connection
On 12/10/16 05:33 AM, Alexander Thurgood wrote: Le 11/10/2016 à 19:45, Gary Dale a écrit : Hi Gary, In fact, I can't think of a reason for the current behaviour. Why should switching data sources do that instead of the more sensible behaviour of picking up the data from fields with the same name in the new data source? Being cynical, no doubt because that would actually be a useful and intuitive behaviour, at least insofar as the field names and field data types are the same, and LO is still in many aspects not very intuitive for the user, especially with stuff like database mailmerge. What you are looking for could be made the subject of a bug request for enhancement. From my point of view as a QAer, I'd find that a valid request (if it hasn't already been made - I haven't checked). Note that the behaviour with regard to mailmerge documents changed recently-ish from that originally present in previous iterations of LO. Previously, the Writer document which included field references only linked via a reference to the datasource. Nowadays, the Writer document includes the datasource at least where that datasource is a spreadsheet, text or CSV file (or at least, that is my understanding of it). This might be why the change you effected didn't show up until you re-opened the document. There is still some kind of inconsisten weirdness in there in some cases with regard to older Writer documents that were made before the change to integrate the datasource, but I haven't managed to nail it down yet. Perhaps someone else has. Perhaps they were thinking of allowing links to multiple data sources (I'm not sure how that would work)? Otherwise I can't see any justification to include the data source in the document. From decades of experience with form letters, I know that the office staff typically use a (frequently manually) generated list to drive the mail merge rather than a database query. It's often a spreadsheet and the staff know how to title the columns so it works. The spreadsheets are always given unique names so including the name, let alone the path, would be counterproductive. LibreOffice lets you register databases so I have a nice list to choose from that I can give meaningful names - like "2015results", "2016results", etc. for lists that I may access frequently. For most merges even registering the database would be a useless chore since they are frequently one-time lists. Anyway, just using the field names and assuming the users know what they are doing strikes me as the more reasonable approach. I'll file a "feature request" to that effect. Thanks. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to change Writer form letter database connection
Spoke too soon. The data source changes but not the fields. Unless I change the fields in the document (re-insert them from the current data source), they show up as blank. This is NOT what I want. I want the fields to move to the new data source. In fact, I can't think of a reason for the current behaviour. Why should switching data sources do that instead of the more sensible behaviour of picking up the data from fields with the same name in the new data source? On 11/10/16 01:34 PM, Gary Dale wrote: No. I think you're thinking about Ctrl-Shft-F4 which brings up the the Data Sources toolbar. Actually, it's started working now for some reason. The error message I was getting has gone away. Weird. On 11/10/16 12:22 PM, Tom Davies wrote: Hi :) Is it F4 to bring up a "connected databases" toolbar? Regards from Tom :) On 11 October 2016 at 17:00, Gary Dale wrote: How does one go about changing the database that a form letter connects to? I have this problem in several "form letters". I want to connect to a different database than the one they were created against for the simple reason that I have a different set of data that I want to print against. If this is a simple spreadsheet connection then I can simply connect the database to a different spreadsheet. However I have a some cases where I need to use queries with joins and/or sub-queries, which precludes the use of a spreadsheet connection. While the obvious answer is to use a single database and use a query to only select the current data, this is not ideal in my case. I prefer to keep the data sets entirely separate so I can archive them by event along with a lot of other event-specific files. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns ubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to change Writer form letter database connection
No. I think you're thinking about Ctrl-Shft-F4 which brings up the the Data Sources toolbar. Actually, it's started working now for some reason. The error message I was getting has gone away. Weird. On 11/10/16 12:22 PM, Tom Davies wrote: Hi :) Is it F4 to bring up a "connected databases" toolbar? Regards from Tom :) On 11 October 2016 at 17:00, Gary Dale wrote: How does one go about changing the database that a form letter connects to? I have this problem in several "form letters". I want to connect to a different database than the one they were created against for the simple reason that I have a different set of data that I want to print against. If this is a simple spreadsheet connection then I can simply connect the database to a different spreadsheet. However I have a some cases where I need to use queries with joins and/or sub-queries, which precludes the use of a spreadsheet connection. While the obvious answer is to use a single database and use a query to only select the current data, this is not ideal in my case. I prefer to keep the data sets entirely separate so I can archive them by event along with a lot of other event-specific files. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns ubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] How to change Writer form letter database connection
How does one go about changing the database that a form letter connects to? I have this problem in several "form letters". I want to connect to a different database than the one they were created against for the simple reason that I have a different set of data that I want to print against. If this is a simple spreadsheet connection then I can simply connect the database to a different spreadsheet. However I have a some cases where I need to use queries with joins and/or sub-queries, which precludes the use of a spreadsheet connection. While the obvious answer is to use a single database and use a query to only select the current data, this is not ideal in my case. I prefer to keep the data sets entirely separate so I can archive them by event along with a lot of other event-specific files. -- 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] loading a database with images
On 11/10/16 10:29 AM, Robert Großkopf wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, SELECT "event_name", "first_name", "middle_initial", "last_name", "sex", "age", "email", "place", CASE WHEN "age" BETWEEN 0 AND 18 THEN 'Youth' WHEN "age" BETWEEN 19 AND 59 THEN 'Adult' ELSE 'Senior' END "Group", CASE WHEN "place" <= 3 THEN ( SELECT "finish", "ribbon" FROM "Ribbons" WHERE "ID" = "place" ) WHEN "place" >= 4 THEN ( SELECT "finish", "ribbon" FROM "Ribbons" WHERE "ID" = "4" ) END "Finish", "Ribbon" FROM "Results" 1. A subselect must have only one row with one field. 2. If you want to connect a subselsect with the outer select, you have to write a correlative select. SELECT "event_name", "first_name", "middle_initial", "last_name", "sex", "age", "email", "place", CASE WHEN "age" BETWEEN 0 AND 18 THEN 'Youth' WHEN "age" BETWEEN 19 AND 59 THEN 'Adult' ELSE 'Senior' END "Group", CASE WHEN "place" <= 3 THEN ( SELECT "finish" FROM "Ribbons" WHERE "ID" = "a"."place" ) WHEN "place" >= 4 THEN ( SELECT "finish" FROM "Ribbons" WHERE "ID" = "4" ) END "Finish", CASE WHEN "place" <= 3 THEN ( SELECT "ribbon" FROM "Ribbons" WHERE "ID" = "a"."place" ) WHEN "place" >= 4 THEN ( SELECT "ribbon" FROM "Ribbons" WHERE "ID" = "4" ) END "Ribbon" FROM "Results" AS "a" With "a"."place" the subselscts reads the value of "place" from the current row, which is read out from "Results". Sounds good in theory but I get the same error. I've also tried it with just sub-selecting for just one field (remove the last CASE statement) and again get the same error. -- 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] loading a database with images
On 11/10/16 02:05 AM, Robert Großkopf wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, Go it. The old primary key problem. Base insists that it create one and call it ID instead of using another name. How do you create tables? Every name for a field with primary-key is allowed. Primary-key has only to be unique. Your query (by adding the comma) could also work, if the images are in the same path as the *.odb-file. In the form you have to connect the imagecontrol to the field, which shows the text. The imagecontrol will show the iage insted of the path. Yes, found the way to make something a Primary Key. I got the code to work but am trying to optimize it (for human readability more than speed). I wanted something like this: SELECT "event_name", "first_name", "middle_initial", "last_name", "sex", "age", "email", "place", CASE WHEN "age" BETWEEN 0 AND 18 THEN 'Youth' WHEN "age" BETWEEN 19 AND 59 THEN 'Adult' ELSE 'Senior' END "Group", CASE WHEN "place" <= 3 THEN ( SELECT "finish", "ribbon" FROM "Ribbons" WHERE "ID" = "place" ) WHEN "place" >= 4 THEN ( SELECT "finish", "ribbon" FROM "Ribbons" WHERE "ID" = "4" ) END "Finish", "Ribbon" FROM "Results" which Base accepts as syntactically valid but generates a "Column not found: 4 in statement [...] when I run the query. Looking at the code in Design View, it has the Ribbon field as a Field instead of as an Alias with the code generating the field. Is it possible to specify two fields in one CASE statement or do I have to duplicate the code for each field? -- 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] loading a database with images
On 10/10/16 05:29 PM, Gary Dale wrote: On 10/10/16 05:05 PM, Gary Dale wrote: On 10/10/16 03:38 PM, Robert Großkopf wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, SELECT "place" You have forgotten: , SELECT "place", ... CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" FROM "Results" With ' ' will be input text. It isn't an image, which could be shown. Save the images by a form in a separate table "images". You will get the image you want, if you start a subselect for it. SELECT "place", CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0) WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1) WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2) WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3) WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4) END AS "ribbon" FROM "Results" Regards Robert Having an issue with my form. I was able to dump the ID data into it from a spreadsheet (paste into the table) but the table seems to be read only. When I right-click on the image control, nothing happens. I also have an extra field which provides a text translation of what the image says and I can't modify it either. I was following a video by TheFrugalComputerGuy.com - LibreOffice Base (15) Embedding a Picture and things went pretty much as per his video in the very short bit about actually adding the control, but it doesn't let me edit. There's probably something about Forms that I'm missing Actually, it looks like any table I add is read only... The original table in the database allows me to add and change records, but new tables that I add don't. Go it. The old primary key problem. Base insists that it create one and call it ID instead of using another name. -- 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] loading a database with images
On 10/10/16 05:05 PM, Gary Dale wrote: On 10/10/16 03:38 PM, Robert Großkopf wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, SELECT "place" You have forgotten: , SELECT "place", ... CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" FROM "Results" With ' ' will be input text. It isn't an image, which could be shown. Save the images by a form in a separate table "images". You will get the image you want, if you start a subselect for it. SELECT "place", CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0) WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1) WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2) WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3) WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4) END AS "ribbon" FROM "Results" Regards Robert Having an issue with my form. I was able to dump the ID data into it from a spreadsheet (paste into the table) but the table seems to be read only. When I right-click on the image control, nothing happens. I also have an extra field which provides a text translation of what the image says and I can't modify it either. I was following a video by TheFrugalComputerGuy.com - LibreOffice Base (15) Embedding a Picture and things went pretty much as per his video in the very short bit about actually adding the control, but it doesn't let me edit. There's probably something about Forms that I'm missing Actually, it looks like any table I add is read only... The original table in the database allows me to add and change records, but new tables that I add don't. -- 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] loading a database with images
On 10/10/16 03:38 PM, Robert Großkopf wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, SELECT "place" You have forgotten: , SELECT "place", ... CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" FROM "Results" With ' ' will be input text. It isn't an image, which could be shown. Save the images by a form in a separate table "images". You will get the image you want, if you start a subselect for it. SELECT "place", CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0) WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1) WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2) WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3) WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4) END AS "ribbon" FROM "Results" Regards Robert Having an issue with my form. I was able to dump the ID data into it from a spreadsheet (paste into the table) but the table seems to be read only. When I right-click on the image control, nothing happens. I also have an extra field which provides a text translation of what the image says and I can't modify it either. I was following a video by TheFrugalComputerGuy.com - LibreOffice Base (15) Embedding a Picture and things went pretty much as per his video in the very short bit about actually adding the control, but it doesn't let me edit. There's probably something about Forms that I'm missing -- 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] loading a database with images
On 10/10/16 02:56 PM, Gary Dale wrote: I have a database with a large enough number of records that I don't want to do this manually. I would like to have query do it instead. Everything I've found through searches seems to want to do it manually by creating a form. I have a small number of images (5), one of which will be added to the database based on the content of another field. What I was thinking was something along the lines of (extra fields omitted) SELECT "place" CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" FROM "Results" However I have two issues with that. The first is that the "Ribbon" field probably won't contain the image from the current directory but will instead just contain the text. The other is that Base complains about a SQL syntax error when I try to save it. Can anyone help me move forward on this? OK, missing comma after the first field explains the syntax error. But as expected, I'm getting the file name rather than the actual file in the query result. -- 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] loading a database with images
I have a database with a large enough number of records that I don't want to do this manually. I would like to have query do it instead. Everything I've found through searches seems to want to do it manually by creating a form. I have a small number of images (5), one of which will be added to the database based on the content of another field. What I was thinking was something along the lines of (extra fields omitted) SELECT "place" CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" FROM "Results" However I have two issues with that. The first is that the "Ribbon" field probably won't contain the image from the current directory but will instead just contain the text. The other is that Base complains about a SQL syntax error when I try to save it. Can anyone help me move forward on this? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Islamic Calendar
On 12/08/16 10:57 AM, toki wrote: On 12/08/2016 13:27, Gary Dale wrote: I note that a similar issue occurred in Europe when the start of the new year was moved from Easter to January 1. Historians deal with it by listing both years for dates prior to switch. I suspect that they probably do something similar, or cite the calendar in use, for dates using a Julian calendar after the invention of the Gregorian. In looking for an explanation of why only those four Arabic locales have an Islamic calendar, I stumbled across a guy that was fed up with trying to convert between calendar systems, so he created a database whose index key is the Julian Day. Then he reconciled the Gregorian and Julian Calendar dates to Julian Days, to populate the database. As his focus in history changes, he adds other calendars, as appropriate, to the database. jonathon And of course the Julian day (day in the year) has nothing to do with the Julian calendar. It's merely a historical accident that the names are the same. :) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Islamic Calendar
On 12/08/16 07:49 AM, CVAlkan wrote: The usage for a Calendar must also be considered. In addition to changes depending on country, culture, religion and all the other considerations mentioned, there is the issue of moment in time. Genealogy and History (including dependent disciplines such as archeology, et. al.) require a lot more knowledge. Even those who share the "same" calendar (such as the Gregorian) don't always have the same view of what date it is. For someone in Germany, the 3rd of September 1752 followed the 2nd of September 1752. In the American Colonies however, the day after Wednesday September 2nd was Thursday September 14th. (Unix/Linux systems support this; try typing "cal 1752" at the command line and, depending on locale, you may be surprised.) Other countries using the Gregorian calendar "corrected" its accumulated errors at quite different times, but they all have similar burps in their calendars. And don't forget the French revolutionary calendar. Napoleon's greatest contribution to France might just have been his abolishment of that unusual thirteen month calendar. Ben Franklin, who traveled between France and the American colonies in those years likely experienced far worse jet lag than any of us ever had from air travel. The point is, I suppose, that we must settle for the 99% of needs we have; it seems unlikely that any software will ever support *every* such variation. Right now, we're probably in the upper 80% range, but that's all we're likely to see. Have a great day, whatever date you suspect it might be. That makes a case for some inclusion in locale but a pretty Euro-centric one of limited usefulness except to historians. I'd argue that locale dependency more correctly should be a search-term dependency since the date depends more on the area you are investigating rather than the place you are residing. I note that a similar issue occurred in Europe when the start of the new year was moved from Easter to January 1. Historians deal with it by listing both years for dates prior to switch. I suspect that they probably do something similar, or cite the calendar in use, for dates using a Julian calendar after the invention of the Gregorian. -- 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] Islamic Calendar
On 11/08/16 04:16 PM, toki wrote: All: Can somebody either point to or explain why Islamic Calendar functions are only available for the following locales: * ar_EG: Arabic Egypt; * ar_LB: Arabic Lebanon; * ar_SA: Arabic Saudi Arabia; * ar_TUN: Arabic Tunisia; I couldn't find anything on the LibreOffice website in English, Dutch, or German. Baidu, Yandex, DuckDuckGo were equally uninformative. :( jonathon That's an interesting question. Why should calendars be tied to locales? For example, an English-speaking Muslim living in the EU or North America may well want to use an Islamic calendar for some purposes. Similarly, an Asian person living elsewhere may find it useful to work with the "Chinese" calendar. And then there are the Julian versus Gregorian calendars use in various Christian denominations. While all European nations use the Gregorian calendar secularly, the Julian is still used for religious purposes. Is this a case of the locales being overused for things that aren't really location dependent? -- 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] about libreoffice fonts and persian and arabic diacritics.
On 04/07/16 02:02 PM, nasrin khaksar wrote: hi every one. i read the previous post about unicode support in libreoffice and became very worried. does libreoffice support unicode independently? i mean if someone install a fresh windows (without installing any font), is it possible to read the persian and arabic documents and write the documents in two languages? a person who has a fresh windows, does not install separate windows, and also the only office program is libreoffice. and my second question is, how to configure libreoffice to support persian and arabic diacritics like the letters? i reported a bug for this problem almost two years ago and without any result until now. i pray for you and request devine mercy and grace for you. The short answer is no. While a document may contain unicode characters, they still need to be displayed which requires a font or localization file. Normally people who can read a language have the files installed. If you don't have a font for a particular language, it won't display correctly. Windows will use a system font for text editors and may replace fonts for word processors, etc. with one that has similar metrics. However it won't install a character set for a language it doesn't have. -- 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] form letters don't work directly from spreadsheet
I'm using LibreOffice 5.1.3.2 on a Debian/Stretch AMD64 machine. I created a spreadsheet containing 4 address columns where each row may or may not use all 4. Then I created an envelope form with a fixed return address and 4 fields for the addresses linked to each column in the spreadsheet. When I tried to print, it gets all the way to actually creating a PDF (wanted to make sure the envelopes looked good before physically printing them) but the PDF never was created. This happened when I asked for a single PDF and also if I asked for 1 PDF per row based on Address1. When I created a .ODB file linked to the spreadsheet and recreated the form using the .ODB file, the printing worked. Therefore the problem seems to be in the direct link to a spreadsheet. -- 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] font in LibreOffice messages
Whatever it is, it's not obvious in the Plasma 5 desktop settings and only seems to affect LibreOffice. On 25/05/16 12:05 AM, Steve Edmonds wrote: I may be way off track here, but some years (quite a few) ago I had similar. There was a desktop setting that set a pt. size below which fonts were not rendered (properly). I dropped this to 4. Don't ask me where, I will look about but have KDE on openSuse. Steve On 2016-05-25 15:31, Gary Dale wrote: I think this question was answered some time ago, possibly in a different (debian) forum, but I can't find the answer and it's bugging me. Some messages give me alternate ways to see the message while others don't (e.g. some Base messages have a pulldown for a fuller message). I'm using 5.1.3.2 on a Debian/Stretch AMD64 system. The text in a lot of the pop-up messages (e.g. error messages) is unreadable. It's like the font is too small for there to be enough pixels to render it properly or something. Possibly its the font size needs adjusting or possibly the font itself is corrupt (although it only happens in LibreOffice so it's not a font the desktop uses). Any ideas on how to track this down and fix it? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] font in LibreOffice messages
I think this question was answered some time ago, possibly in a different (debian) forum, but I can't find the answer and it's bugging me. Some messages give me alternate ways to see the message while others don't (e.g. some Base messages have a pulldown for a fuller message). I'm using 5.1.3.2 on a Debian/Stretch AMD64 system. The text in a lot of the pop-up messages (e.g. error messages) is unreadable. It's like the font is too small for there to be enough pixels to render it properly or something. Possibly its the font size needs adjusting or possibly the font itself is corrupt (although it only happens in LibreOffice so it's not a font the desktop uses). Any ideas on how to track this down and fix it? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Number comparisons in conditional text
The final query isn't too bad. Unfortunately Base doesn't like
pretty-printing so a raw view is hard to read. Here's what I finally
used. I just need to copy the raw spreadsheet into a Base table then
print against the query. It still means the code is split across two
documents (the certificate and the database) since I still need
conditional text to insert a middle initial and it's still simpler to
handle gender in the document.
SELECT "event_name", "first_name", "middle_initial", "last_name", "sex",
"age", "email", "place",
CASE WHEN "age" BETWEEN 0 AND 18 THEN 'Youth'
WHEN "age" BETWEEN 19 AND 59 THEN 'Adult'
ELSE 'Senior'
END "Group",
CASE WHEN "place" = 0 THEN 'supporting'
WHEN "place" = 1 THEN 'first'
WHEN "place" = 2 THEN 'second'
WHEN "place" = 3 THEN 'third'
WHEN "place" >= 4 THEN 'participating'
END "Finish"
FROM "Results"
On 09/05/16 08:24 AM, Bruce Hohl wrote:
A (more difficult) method to use the age ranges from their own table
(separate from the other data) would be to use a correlated subquery. Then
you could have "cleaner" SQL. You can find examples of this on the web.
OR I think there may be limited support for saving query formatting like
discussed here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=39997
but I don't have any experience with how this works or its limitations.
On Mon, May 9, 2016 at 12:00 AM, Gary Dale wrote:
Thanks Bruce. I appreciate the help. I was trying values from a table that
translates age ranges into text. I hate hard coding numbers, let alone the
number of ranges, because I handle events for two different groups who have
their own definitions. They used to be encoded in the different
certificates...
My sql was
SELECT "results".*, "Categories".* FROM { oj "results" LEFT OUTER JOIN
"Categories" ON "results"."age" BETWEEN "Categories"."low" AND
"Categories"."high" }
which doesn't work but does work when I use "results"."age" =
"Categories"."low", leading to my complaint that BETWEEN doesn't work.
Your use of a CASE statement with just the one table looks like it will do
the trick, even if the code will be ugly. I'll need 2 different CASE
statements with a total of 8 different cases to do the translations.
On 08/05/16 09:43 PM, Bruce Hohl wrote:
Gary,
See attached for a working case when in LO Base. You do have to be very
careful when using Base Queries (SQL) that everything is exactly correct
like where commas are placed (or not) and how quotes / half quotes are
used
(or not). So setting this up in Base will likely take more time than in
Calc. You will have to judge if the final result in Base is best for your
needs. Good Luck!
On Sun, May 8, 2016 at 4:31 PM, Gary Dale wrote:
The first option is what I have been doing - it uses a calc file to drive
a mailing list. The logic is in the document, not in the calc file, so
that
I can bring in new data without a lot of effort - the raw data can just
be
a .csv file.
The second option, using a "smart" calc file, moves the logic to the data
file which is what I don't want to do. It means importing the data or
calculation into a calc file each time. The second option, moving the
logic
into a base file seems more promising.
However, after much wailing and gnashing of teeth, I have to question
whether base can do what I want. I can't get it to take a query using a
BETWEEN criterion (e.g., youth is AGE between 0 AND 18).
It won't (apparently) do any queries on calc sheets. Fortunately
copy/pasting to create a new base table is easy enough. Unfortunately
without being able to match the main table (containing participant
information) against age categories, etc., it's not much good.
I suppose I can use a brute force technique and create a table row for
every possible age (for example) but that seems like a ludicrous kludge
when the basic problem is that Writer's form letter functions can't
compare
numbers.
On 28/04/16 09:58 PM, Bruce Hohl wrote:
Two more ideas for this problem: (1) Do not use a Calc file - see
LO_Labels_howto.odt, (2) Move the logic from Writer into either Calc or
a
Base query. While I can't explain how this might work for your
Certificate
mail merge I can show you through the attached examples how I used these
two ideas to solve my mail merge problem. Good Luck and I hope you can
make this work for you in LO.
On Wed, Apr 27, 2016 at 9:17 PM, Gary Dale > wrote:
Re: [libreoffice-users] Number comparisons in conditional text
Thanks Bruce. I appreciate the help. I was trying values from a table
that translates age ranges into text. I hate hard coding numbers, let
alone the number of ranges, because I handle events for two different
groups who have their own definitions. They used to be encoded in the
different certificates...
My sql was
SELECT "results".*, "Categories".* FROM { oj "results" LEFT OUTER JOIN
"Categories" ON "results"."age" BETWEEN "Categories"."low" AND
"Categories"."high" }
which doesn't work but does work when I use "results"."age" =
"Categories"."low", leading to my complaint that BETWEEN doesn't work.
Your use of a CASE statement with just the one table looks like it will
do the trick, even if the code will be ugly. I'll need 2 different CASE
statements with a total of 8 different cases to do the translations.
On 08/05/16 09:43 PM, Bruce Hohl wrote:
Gary,
See attached for a working case when in LO Base. You do have to be very
careful when using Base Queries (SQL) that everything is exactly correct
like where commas are placed (or not) and how quotes / half quotes are used
(or not). So setting this up in Base will likely take more time than in
Calc. You will have to judge if the final result in Base is best for your
needs. Good Luck!
On Sun, May 8, 2016 at 4:31 PM, Gary Dale wrote:
The first option is what I have been doing - it uses a calc file to drive
a mailing list. The logic is in the document, not in the calc file, so that
I can bring in new data without a lot of effort - the raw data can just be
a .csv file.
The second option, using a "smart" calc file, moves the logic to the data
file which is what I don't want to do. It means importing the data or
calculation into a calc file each time. The second option, moving the logic
into a base file seems more promising.
However, after much wailing and gnashing of teeth, I have to question
whether base can do what I want. I can't get it to take a query using a
BETWEEN criterion (e.g., youth is AGE between 0 AND 18).
It won't (apparently) do any queries on calc sheets. Fortunately
copy/pasting to create a new base table is easy enough. Unfortunately
without being able to match the main table (containing participant
information) against age categories, etc., it's not much good.
I suppose I can use a brute force technique and create a table row for
every possible age (for example) but that seems like a ludicrous kludge
when the basic problem is that Writer's form letter functions can't compare
numbers.
On 28/04/16 09:58 PM, Bruce Hohl wrote:
Two more ideas for this problem: (1) Do not use a Calc file - see
LO_Labels_howto.odt, (2) Move the logic from Writer into either Calc or a
Base query. While I can't explain how this might work for your Certificate
mail merge I can show you through the attached examples how I used these
two ideas to solve my mail merge problem. Good Luck and I hope you can
make this work for you in LO.
On Wed, Apr 27, 2016 at 9:17 PM, Gary Dale > wrote:
I can browse to a spreadsheet directly without first attaching it
to a database, but that's just a kludge. LibreOffice creates the
base file when you select the spreadsheet, which brings me back to
the same problem.
On 27/04/16 07:24 PM, Bruce Hohl wrote:
Reportedly, as of LO 5.1 you can create a mail merge without a
Base file -
reference this:
http://vmiklos.hu/blog/mail-merge-embedding.html You might
try to recreate your Certificate mail merge without the Base
file being
careful to select cell formats for your data that work with
Writer. (If
you have good spreadsheet skills you could likely get the job
done entirely
in Calc.)
On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale
mailto:garyd...@torfree.net>> wrote:
I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows
7 v5.1.3. If I
was running anything old or unusual, I would have noted
it. The document is
simple, as is the spreadsheet and the base file that
connects them.
I tried changing the numbers to text but Base doesn't seem
to allow that.
It's decided that the columns for age and place are
decimal numbers.
So far as I can see, either the number comparisons operate
differently
from the text comparisons (which the documentation doesn't
mention) or the
number comparisons are broken. Normally I'd consider that
unlikely, but my
past experience with printing "form letters" and labels is
Re: [libreoffice-users] Number comparisons in conditional text
The first option is what I have been doing - it uses a calc file to
drive a mailing list. The logic is in the document, not in the calc
file, so that I can bring in new data without a lot of effort - the raw
data can just be a .csv file.
The second option, using a "smart" calc file, moves the logic to the
data file which is what I don't want to do. It means importing the data
or calculation into a calc file each time. The second option, moving the
logic into a base file seems more promising.
However, after much wailing and gnashing of teeth, I have to question
whether base can do what I want. I can't get it to take a query using a
BETWEEN criterion (e.g., youth is AGE between 0 AND 18).
It won't (apparently) do any queries on calc sheets. Fortunately
copy/pasting to create a new base table is easy enough. Unfortunately
without being able to match the main table (containing participant
information) against age categories, etc., it's not much good.
I suppose I can use a brute force technique and create a table row for
every possible age (for example) but that seems like a ludicrous kludge
when the basic problem is that Writer's form letter functions can't
compare numbers.
On 28/04/16 09:58 PM, Bruce Hohl wrote:
Two more ideas for this problem: (1) Do not use a Calc file - see
LO_Labels_howto.odt, (2) Move the logic from Writer into either Calc
or a Base query. While I can't explain how this might work for your
Certificate mail merge I can show you through the attached examples
how I used these two ideas to solve my mail merge problem. Good Luck
and I hope you can make this work for you in LO.
On Wed, Apr 27, 2016 at 9:17 PM, Gary Dale <mailto:garyd...@torfree.net>> wrote:
I can browse to a spreadsheet directly without first attaching it
to a database, but that's just a kludge. LibreOffice creates the
base file when you select the spreadsheet, which brings me back to
the same problem.
On 27/04/16 07:24 PM, Bruce Hohl wrote:
Reportedly, as of LO 5.1 you can create a mail merge without a
Base file -
reference this:
http://vmiklos.hu/blog/mail-merge-embedding.html You might
try to recreate your Certificate mail merge without the Base
file being
careful to select cell formats for your data that work with
Writer. (If
you have good spreadsheet skills you could likely get the job
done entirely
in Calc.)
On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale
mailto:garyd...@torfree.net>> wrote:
I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows
7 v5.1.3. If I
was running anything old or unusual, I would have noted
it. The document is
simple, as is the spreadsheet and the base file that
connects them.
I tried changing the numbers to text but Base doesn't seem
to allow that.
It's decided that the columns for age and place are
decimal numbers.
So far as I can see, either the number comparisons operate
differently
from the text comparisons (which the documentation doesn't
mention) or the
number comparisons are broken. Normally I'd consider that
unlikely, but my
past experience with printing "form letters" and labels is
that these areas
don't get a lot of attention.
On 27/04/16 03:32 PM, Bruce Hohl wrote:
Can you give more details of your set-up. What is in
the Writer, Calc
and / or Base components of LO.
On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale
mailto:garyd...@torfree.net>
<mailto:garyd...@torfree.net
<mailto:garyd...@torfree.net>>> wrote:
I'm trying to print certificates for a group of
athletes and need
to have them reflect their standing in the event.
The certificate
has a number of conditional text fields, such as
to translate
their gender from M/F to male/female, which are
working.
However the ones that are doing numeric
comparisons aren't. The
comparison always seems to return "true" so the
"then" condition
is printed. For example Run Results.Race.place ==
1 is the
condition but the translation text is always
"first place", never
empty. Since I have 5 different conditions (first
3 positions,
Re: [libreoffice-users] Number comparisons in conditional text
I can browse to a spreadsheet directly without first attaching it to a database, but that's just a kludge. LibreOffice creates the base file when you select the spreadsheet, which brings me back to the same problem. On 27/04/16 07:24 PM, Bruce Hohl wrote: Reportedly, as of LO 5.1 you can create a mail merge without a Base file - reference this: http://vmiklos.hu/blog/mail-merge-embedding.html You might try to recreate your Certificate mail merge without the Base file being careful to select cell formats for your data that work with Writer. (If you have good spreadsheet skills you could likely get the job done entirely in Calc.) On Wed, Apr 27, 2016 at 6:18 PM, Gary Dale wrote: I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows 7 v5.1.3. If I was running anything old or unusual, I would have noted it. The document is simple, as is the spreadsheet and the base file that connects them. I tried changing the numbers to text but Base doesn't seem to allow that. It's decided that the columns for age and place are decimal numbers. So far as I can see, either the number comparisons operate differently from the text comparisons (which the documentation doesn't mention) or the number comparisons are broken. Normally I'd consider that unlikely, but my past experience with printing "form letters" and labels is that these areas don't get a lot of attention. On 27/04/16 03:32 PM, Bruce Hohl wrote: Can you give more details of your set-up. What is in the Writer, Calc and / or Base components of LO. On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale mailto:garyd...@torfree.net>> wrote: I'm trying to print certificates for a group of athletes and need to have them reflect their standing in the event. The certificate has a number of conditional text fields, such as to translate their gender from M/F to male/female, which are working. However the ones that are doing numeric comparisons aren't. The comparison always seems to return "true" so the "then" condition is printed. For example Run Results.Race.place == 1 is the condition but the translation text is always "first place", never empty. Since I have 5 different conditions (first 3 positions, participate, supported), I get a lot of text printed that shouldn't. The slightly more complex Run Results.Race.age > 18 AND Run Results.Race.age < 60 always prints adult. At one point I had it print an else (senior) but that branch was never taken even when the age was well past 60. I've checked the Run Results.odb file (which links to a spreadsheet) and the age & place fields are both of type decimal. What am I doing wrong? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org <mailto:users%2bunsubscr...@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 -- 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] Number comparisons in conditional text
I've tried it with Debian/Stretch v5.1.2.2.0+ and Windows 7 v5.1.3. If I was running anything old or unusual, I would have noted it. The document is simple, as is the spreadsheet and the base file that connects them. I tried changing the numbers to text but Base doesn't seem to allow that. It's decided that the columns for age and place are decimal numbers. So far as I can see, either the number comparisons operate differently from the text comparisons (which the documentation doesn't mention) or the number comparisons are broken. Normally I'd consider that unlikely, but my past experience with printing "form letters" and labels is that these areas don't get a lot of attention. On 27/04/16 03:32 PM, Bruce Hohl wrote: Can you give more details of your set-up. What is in the Writer, Calc and / or Base components of LO. On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale <mailto:garyd...@torfree.net>> wrote: I'm trying to print certificates for a group of athletes and need to have them reflect their standing in the event. The certificate has a number of conditional text fields, such as to translate their gender from M/F to male/female, which are working. However the ones that are doing numeric comparisons aren't. The comparison always seems to return "true" so the "then" condition is printed. For example Run Results.Race.place == 1 is the condition but the translation text is always "first place", never empty. Since I have 5 different conditions (first 3 positions, participate, supported), I get a lot of text printed that shouldn't. The slightly more complex Run Results.Race.age > 18 AND Run Results.Race.age < 60 always prints adult. At one point I had it print an else (senior) but that branch was never taken even when the age was well past 60. I've checked the Run Results.odb file (which links to a spreadsheet) and the age & place fields are both of type decimal. What am I doing wrong? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org <mailto:users%2bunsubscr...@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] Number comparisons in conditional text
I'm trying to print certificates for a group of athletes and need to have them reflect their standing in the event. The certificate has a number of conditional text fields, such as to translate their gender from M/F to male/female, which are working. However the ones that are doing numeric comparisons aren't. The comparison always seems to return "true" so the "then" condition is printed. For example Run Results.Race.place == 1 is the condition but the translation text is always "first place", never empty. Since I have 5 different conditions (first 3 positions, participate, supported), I get a lot of text printed that shouldn't. The slightly more complex Run Results.Race.age > 18 AND Run Results.Race.age < 60 always prints adult. At one point I had it print an else (senior) but that branch was never taken even when the age was well past 60. I've checked the Run Results.odb file (which links to a spreadsheet) and the age & place fields are both of type decimal. What am I doing wrong? -- 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] Conditional text using numeric conditions
Sorry, the second condition is missing the ".Race" after the Run Results". I removed some extraneous data from the spreadsheet's name for example purposes but messed it up. The original spreadsheet name was much longer and included event and date information that isn't relevant. On 26/04/16 05:01 PM, Gary Dale wrote: I'm trying to print certificates for a group of athletes and need to have them reflect their standing in the event. The certificate has a number of conditional text fields, such as to translate their gender from M/F to male/female, which are working. However the ones that are doing numeric comparisons aren't. The comparison always seems to return "true" so the "then" condition is printed. For example Run Results.Race.place == 1 is the condition but the translation text is always "first place", never blank. The slightly more complex Run Results.age > 18 AND Run Results.age < 60 always prints adult. I at one point had it print an else (senior) but that branch was never taken. I've checked the .odb file and the age & place fields are both of type decimal. What am I doing wrong? -- 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] Conditional text using numeric conditions
I'm trying to print certificates for a group of athletes and need to have them reflect their standing in the event. The certificate has a number of conditional text fields, such as to translate their gender from M/F to male/female, which are working. However the ones that are doing numeric comparisons aren't. The comparison always seems to return "true" so the "then" condition is printed. For example Run Results.Race.place == 1 is the condition but the translation text is always "first place", never blank. The slightly more complex Run Results.age > 18 AND Run Results.age < 60 always prints adult. I at one point had it print an else (senior) but that branch was never taken. I've checked the .odb file and the age & place fields are both of type decimal. What am I doing wrong? -- 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] Currency calculations [was: Avery 8167 label printing]
On 11/02/16 09:37 AM, Virgil Arrington wrote: Thanks for the tip, but back in 1989 when this was all happening, I'm not sure that my DOS spreadsheet even had the ability to display numbers as "currency". I certainly made no attempt to do so, even if it were possible. They were just numbers and, yes, integers, and no, the spreadsheet didn't get 28 divided by 7 correct. I have learned, however, as you point out, that how numbers are displayed is not the same as what they are. For example, you can't "round" a number in a spreadsheet by simply reducing the number of decimal places displayed in a cell. The underlying number remains unrounded and further calculations with it might produce undesired results. When working with currency, I've developed the habit of probably overusing the the "@round" function at each step of a complex calculation just to ensure desired results. Virgil There were stories back in the 1970s about programmers taking advantage of the binary/floating point rounding errors to transfer a penny here and there into their own accounts. With huge numbers of transactions each day, the pennies added up very quickly. COBOL actually had features that let you do arithmetic in decimal digits with the decimal point being a display item, not an actual fractional part of a number, so that the results would be exactly what they were if you did the calculations by hand. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Avery 8167 label printing
On 10/02/16 10:53 PM, Ken Springer wrote: On 2/10/16 4:27 PM, Gary Dale wrote: On 10/02/16 12:01 PM, Ken Springer wrote: On 2/10/16 8:28 AM, Gary Dale wrote: On 09/02/16 11:39 PM, Ken Springer wrote: On 2/9/16 2:23 PM, Gary Dale wrote: On 09/02/16 03:23 PM, Dave Liesse wrote: PDF is a great way to exchange documents but it has an interesting print option (usually) of shrinking to fit the printer margins. If you send a PDF label set, you need to remind the recipient to print them full size. I've run into this problem several times where my carefully crafted PDFs aren't printed the way I designed them. In this case, IMO, the creator of the PDF should be aware of the potential margin issue and set them accordingly. So far, I've never been burned that I know of by using .5" margins except with the top margin of the 8167 labels. So there should be no need for shrink to fit unless we are talking a totally different page size. But it's awful hard to break people's mindset and get them to switch to PDF. "Oh, if we are going to share and work with the same thing, we both have to have MS Word." Or WordPerfect. Or Lotus' word processor in the old days, I can't remember the name. At one time, this was absolutely true. But it's no longer a mandatory thing with PDF on the scene. There will be situations where where Word, or Excel, or will be required. But it's because that software is already in use across the enterprise. It's not because it's the only software that will do the job. That's not the issue. Sometimes you want something to occupy the full page for professional printing but people use their home printers instead. As for using the same software, that doesn't solve problems if the person doesn't have the same fonts installed that you do. The PDF format removes the requirement to stick to common fonts. Similarly the ISO standard Open Document formats that LibreOffice uses allow documents to used by other programs, including the M$ ones. They may not look the same, but will at least be exchangeable and editable. There used to be a problem with multi-column labels but they seem to have redone the label specification to correct that. When creating labels, there is "Format" tab that lets you adjust the label properties. In its new incarnation, it is easy to use and gives you exactly what you need to adjust the properties of incorrectly specified common label formats down to 1/100 of an inch. In the end, I'll probably do this. You can specify the top margin, label height and vertical pitch (the last two may be different if there is space between the labels) and do the same for the left margin, label width and horizontal pitch. They also allow you to specify the page size and the number of rows and columns. If you think a label isn't defined correctly, fix it. Also, file a bug report so that the developers can fix it for everyone. It's better to light a candle or two than to curse the darkness. In this case, the label spec is correct. Font design will have to have a factor in this someway too, I suspect. It shouldn't unless LO calculates the position of the next label relative to the end of the previous text. It would seem more natural (and simpler) to calculate in absolute terms. Upon retrospect, I agree. But it is something you have to be cognizant of when designing the label, as it can affect the apparent vertical centering of text on the label. Which can effect what you think may be happening with label output. In my case, the label includes a graphic, which is unaffected by text positioning. Makes it easy to figure out where the problem is likely to be. Another overall negative effect of this problem is, you have to ask yourself, if this is broken, what else in the suite is broken? Especially if you are using LO to make a living. Is there another feature I use in Writer that doesn't work correctly? What if one or two functions in the spreadsheet calculate incorrectly? What if Base occasionally mangles your data? I remember years ago when Intel turned out a chip that had an error in it's math calculations. It was a rare happening, but when they finally admitted it publicly, trying to say it wasn't important do to the rare occurrence, it did not go over well at all! I've yet to find software that is perfect (except of course for what I develop ;) ). Big suites like LO will have the occasional bug but I've never found one that was more than an annoyance. It's an annoyance if you can find a workaround. It's a problem if there's no workaround, and it's something you need to get your job done. And, if it was something I produced, I won't be happy until it's fixed. "Close enough" just doesn't work for me in a lot of case
Re: [libreoffice-users] Re: Avery 8167 label printing
On 10/02/16 12:01 PM, Ken Springer wrote: On 2/10/16 8:28 AM, Gary Dale wrote: On 09/02/16 11:39 PM, Ken Springer wrote: On 2/9/16 2:23 PM, Gary Dale wrote: On 09/02/16 03:23 PM, Dave Liesse wrote: I've never had any luck with any of the Avery templates I've tried (although my problem has been mostly with left-to-right adjustments rather than top-to-bottom). I finally just got in the habit of setting my paragraph position as 1/8" into the label; fooling with the template specs didn't do the job. I've occasionally found problems with the labels but they are minor. For small labels, like return-address labels, the print V. Pitch may be a little off so the labels creep up or down a little as you go down the page. I think this could also occur due to printer's paper feed abilities. In this case, the error is consistent. Are you referring to the page slipping on the rollers? That would likely produce inconsistent results. If the labels are simply off consistently, that would be the top margin. If they vary consistently down that page, that would be vertical pitch. Slippage in the rollers is what I was thinking of. In my case, the error is consistent, so slippage is not problem. Telling the printer where to actually start the printing appears to be the issue. We'll call it the top margin for convenience, but even that has it's own issues. Since the driver is TWAIN, the brand of printer shouldn't make a difference as long as the printer manufacturer doesn't screw up the driver. Time to "expand our horizons". (Sounds like a motivational speaker, doesn't it? LOL) LO's built-in template, displayed on the screen, is correct. The paper's top margin is .5" on the screen and in real life. Positioning of the text is also correct, as displayed on the screen. Only printing is in error. Now... Suppose you are creating X number of label designs for someone else. They don't have LO, how to you get the labels to them? Today, I think almost everyone's answer would be PDF. Fair enough, but that doesn't work either. If you create the PDF with the default template settings, which are correct, the resulting PDF file is also in error. I tried it. Same vertical offset issue. So you change the top margin, create the PDF, and yep, labels print correctly. What's wrong with this? In the above scenario, the recipient of the PDF may/can/will look at the labels before printing them, to see if they are correct. (If they don't, they aren't doing their job.) Guess what? They'll see the top margin error, more easily spotted if you have a vertical ruler option. If you send a PDF based on the correct template (the one supplied by LO), the printing will be off. If you send a PDF based on a modified template, the visual display on the screen will be off. In this situation, LO falls on its face in providing WYSIWYG... What You See Is What You Get. One of the principals in modern computers. What is displayed on the screen is what is supposed to come out of the printer or other device. This is no different than if you had the font set for 12 points, but the output to either screen or printer was 16 points. Not a good thing in the long run. PDF is a great way to exchange documents but it has an interesting print option (usually) of shrinking to fit the printer margins. If you send a PDF label set, you need to remind the recipient to print them full size. I've run into this problem several times where my carefully crafted PDFs aren't printed the way I designed them. There used to be a problem with multi-column labels but they seem to have redone the label specification to correct that. When creating labels, there is "Format" tab that lets you adjust the label properties. In its new incarnation, it is easy to use and gives you exactly what you need to adjust the properties of incorrectly specified common label formats down to 1/100 of an inch. In the end, I'll probably do this. You can specify the top margin, label height and vertical pitch (the last two may be different if there is space between the labels) and do the same for the left margin, label width and horizontal pitch. They also allow you to specify the page size and the number of rows and columns. If you think a label isn't defined correctly, fix it. Also, file a bug report so that the developers can fix it for everyone. It's better to light a candle or two than to curse the darkness. In this case, the label spec is correct. Font design will have to have a factor in this someway too, I suspect. It shouldn't unless LO calculates the position of the next label relative to the end of the previous text. It would seem more natural (and simpler) to calculate in absolute terms. Upon retrospect, I agree. But it is something you have to
Re: [libreoffice-users] Re: Avery 8167 label printing
On 09/02/16 11:39 PM, Ken Springer wrote: On 2/9/16 2:23 PM, Gary Dale wrote: On 09/02/16 03:23 PM, Dave Liesse wrote: I've never had any luck with any of the Avery templates I've tried (although my problem has been mostly with left-to-right adjustments rather than top-to-bottom). I finally just got in the habit of setting my paragraph position as 1/8" into the label; fooling with the template specs didn't do the job. I've occasionally found problems with the labels but they are minor. For small labels, like return-address labels, the print V. Pitch may be a little off so the labels creep up or down a little as you go down the page. I think this could also occur due to printer's paper feed abilities. In this case, the error is consistent. Are you referring to the page slipping on the rollers? That would likely produce inconsistent results. If the labels are simply off consistently, that would be the top margin. If they vary consistently down that page, that would be vertical pitch. There used to be a problem with multi-column labels but they seem to have redone the label specification to correct that. When creating labels, there is "Format" tab that lets you adjust the label properties. In its new incarnation, it is easy to use and gives you exactly what you need to adjust the properties of incorrectly specified common label formats down to 1/100 of an inch. In the end, I'll probably do this. You can specify the top margin, label height and vertical pitch (the last two may be different if there is space between the labels) and do the same for the left margin, label width and horizontal pitch. They also allow you to specify the page size and the number of rows and columns. If you think a label isn't defined correctly, fix it. Also, file a bug report so that the developers can fix it for everyone. It's better to light a candle or two than to curse the darkness. In this case, the label spec is correct. Font design will have to have a factor in this someway too, I suspect. It shouldn't unless LO calculates the position of the next label relative to the end of the previous text. It would seem more natural (and simpler) to calculate in absolute terms. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Avery 8167 label printing
On 09/02/16 03:23 PM, Dave Liesse wrote: I've never had any luck with any of the Avery templates I've tried (although my problem has been mostly with left-to-right adjustments rather than top-to-bottom). I finally just got in the habit of setting my paragraph position as 1/8" into the label; fooling with the template specs didn't do the job. I've occasionally found problems with the labels but they are minor. For small labels, like return-address labels, the print V. Pitch may be a little off so the labels creep up or down a little as you go down the page. There used to be a problem with multi-column labels but they seem to have redone the label specification to correct that. When creating labels, there is "Format" tab that lets you adjust the label properties. In its new incarnation, it is easy to use and gives you exactly what you need to adjust the properties of incorrectly specified common label formats down to 1/100 of an inch. You can specify the top margin, label height and vertical pitch (the last two may be different if there is space between the labels) and do the same for the left margin, label width and horizontal pitch. They also allow you to specify the page size and the number of rows and columns. If you think a label isn't defined correctly, fix it. Also, file a bug report so that the developers can fix it for everyone. It's better to light a candle or two than to curse the darkness. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to.. sort a table in 3 columns
On 16/10/15 04:02 PM, william drescher wrote: I have a list that has two fields: aisle and item. I need to maintain the list sorted by item, but print a pick list by aisle. This would be simple except, when I print the list for marking I need to print it in item order, in 3 columns. When I print the pick list I again need to print it in 3 columns, sorted by item, Right now I am sorting the list by aisle and manually cutting and pasting it into 3 columns. I currently have the data in a spreadsheet. I tried using frames set for 3 columns, but when past the sorted list into the frames it does not spill over onto the 2nd and 3rd columns. I would appreciate suggestions. Thanks, bill 1) Create a custom Writer document with the fields you want printed. 2) attach the spreadsheet to Base. Create a query that meets your sort/selection requirements. 3) print the document as a form letter. -- 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] Libre Draw - rotate a pdf
On 07/08/15 05:29 PM, charles meyer wrote: I have little experience with Libre Draw so I very much appreciate your help with rotating a pdf counterclockwise, I’ve tried with Rotate and Convert but that doesn’t do it. What’s the best way to rotate a pdf image in Libre Draw (Libre Office ver. 4.3 - Windows XP Pro). Thank you! Charles. You could run Linux in a VM and use one of the free PDF manipulators. Or you could convert it to a pixel graphic and rotate that. Another option would be to use Scribus instead of LibreOffice Draw. It's a DTP so it's better suited to that task. -- 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] Linux - Evince - avoid the default
On 24/07/15 09:03 PM, charles meyer wrote: It's gratifying seeing so many posts about who's using Linux, which resources and other software. I haven't found a good Linux forum so I appreciate those using Linux on this forum as you share your workouts and solutions. Evince (pdf reader) was, I believe, originally a Linux product. They now have a Windows version. I'm trying to figure out a way to avoid Evince becoming my default pdf as it seems when you instal it in Windows 7 it forces you to make it your default. Has anyone figure out how to avoid making Evince your default pdf when installing it in Windows or even Linux? Thanks so much! Charles. Right-click on a pdf and select "open with" then pick the program you want, check the "always use the selected program to open this kind of file" and you're done. -- 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: [OT] [libreoffice-users] Linux alternative
On 19/07/15 02:43 PM, Tom Williams wrote: On 07/18/2015 07:51 PM, toki wrote: On 07/18/2015 10:08 PM, James Knott wrote: Tell that to all the scientists who use supercomputers. The vast majority of them, including my cousin, run Linux. If you want state of the art software, that costs a fortune, you run *Nix. If you want almost state of the art, that costs a small fortune, it is as likely to run on Mac OS X, as on Windows. If you want software that is almost state of the art, but is "affordable", you run Windows. If you want software that is "good enough for most purposes", you run Linux. Joe Sixpack wants something slightly better than "good enough for most purposes", but doesn't want the cash outlay that state of the art requires. Thus far, Windows has been that "happy medium". jonathon I disagree with most of this, but the "good enough for most purposes" part really bothers me. :) "Joe Sixpack" is most familiar with Windows and will stick with it. Familiarity is definitely worth its weight in gold. :) Peace... "The other" Tom Agreed. There may be some niche software that runs on Windows or Macs that beats the Linux alternatives but for general purposes, I find Linux to be far better. I hate working on Windows or Macs compared to Linux. There are just too many things that Windows and Macs don't do that are easy on Linux. -- 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: [OT] Re: [libreoffice-users] Linux alternative
On 18/07/15 06:30 PM, Malgosia Askanas wrote: Heh heh. But then the _real_ top reason would be that you can't acquire a Linux machine in a hurry. True enough. No, the real reason is that people don't have the option in front of them to even realize that it is possible. -- 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: [OT] Re: [libreoffice-users] Linux alternative
On 18/07/15 06:10 PM, Malgosia Askanas wrote: On 2015-07-18 04:02 PM, Gary Dale wrote: The top reason people find hard is almost certainly that you have to install it. That's not entirely accurate. There are a few (not many) companies that specialize in selling Linux-preinstalled machines. The two that immediately come to mind are System76.com and ThinkPenguin.com . -malgosia True but largely irrelevant. You can't go to the local Best Buy or Staples and pick up one. -- 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] Linux alternative
On 18/07/15 05:15 PM, Harvey Nimmo wrote: On Sat, 2015-07-18 at 16:05 -0400, Gary Dale wrote: On 18/07/15 02:25 PM, Harvey Nimmo wrote: On Sat, 2015-07-18 at 08:21 -0400, Tim---Kracked_P_P---webmaster wrote: On 07/18/2015 03:42 AM, Eric wrote: On 07/17/2015 05:25 PM, charles meyer wrote: For those on the list using or contemplating Linux, this was interesting. http://www.techrepublic.com/article/alternative-is-the-question-linux-is-the-answer/ No one really addressed software only written for Windows - e.g. Dragon Naturally Speaking. There doesn't seem to be a good open source or Linux-based voice recognition software. That can be a deal breaker. yes it can be. As someone dependent on NaturallySpeaking, I can tell you that most of the native limits speech recognition solutions do not measure up and would probably take a multimillion dollar effort to make a functional equivalent. Then there is the issue of supporting it, fixing bugs, adding features, working with the community current open-source funding techniques just don't measure up to the financial needs of critical projects like this would be. So how is it, I am using NaturallySpeaking to dictate on the next? Well the wine solution is pretty fragile and doesn't work with the latest NaturallySpeaking. It still has problems with using community supported extensions such as natlink and vocola. Instead, I'm using a different solution which is running NaturallySpeaking in a Windows virtual machine and using a tool I developed called speech bridge (See github) to link speech recognition functionality in Windows to whatever the hell Linux is doing. It's moving slow, I am changing things as I need them. I'm getting to the point where I could use some assistance but I'm going to hold off asking until I have a good specification/Definition. --- eric There are only two or three Win-only software I need to use, that I have not found an easy to use alternative for a .deb based Linux OS. Also, I have not found any way to use my external USB-based wifi antenna, for "better/faster" useful access 10 floors below my router's antennas. IF so, then Linux would be use for that work "environment", Also, for the "speech issue", I have never been able to got that to work properly for Ubuntu and Linux Mint, as least text to speech. I have not worked with speech to text or speech "system control" before, so I have not really looked into that, much. I couldn't find a good OCR solution for linux either. Project for someone? Cheers Harvey You're kidding right? Check out https://help.ubuntu.com/community/OCR for a quick overview of the current state of affairs. No, I'm not really kidding. Command line programs are only the start of the journey. It is quite a bit more to have something that is well integrated with the corresponding display and text tools. The command line tools are excellent but they are just the backends. Choose the GUI that suits your purposes. Some are better tuned to preserving column structures while others do a great job on multiple pages You have choice. You can use a different GUI or different backend for different purposes. -- 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] Linux alternative
On 18/07/15 02:25 PM, Harvey Nimmo wrote: On Sat, 2015-07-18 at 08:21 -0400, Tim---Kracked_P_P---webmaster wrote: On 07/18/2015 03:42 AM, Eric wrote: On 07/17/2015 05:25 PM, charles meyer wrote: For those on the list using or contemplating Linux, this was interesting. http://www.techrepublic.com/article/alternative-is-the-question-linux-is-the-answer/ No one really addressed software only written for Windows - e.g. Dragon Naturally Speaking. There doesn't seem to be a good open source or Linux-based voice recognition software. That can be a deal breaker. yes it can be. As someone dependent on NaturallySpeaking, I can tell you that most of the native limits speech recognition solutions do not measure up and would probably take a multimillion dollar effort to make a functional equivalent. Then there is the issue of supporting it, fixing bugs, adding features, working with the community current open-source funding techniques just don't measure up to the financial needs of critical projects like this would be. So how is it, I am using NaturallySpeaking to dictate on the next? Well the wine solution is pretty fragile and doesn't work with the latest NaturallySpeaking. It still has problems with using community supported extensions such as natlink and vocola. Instead, I'm using a different solution which is running NaturallySpeaking in a Windows virtual machine and using a tool I developed called speech bridge (See github) to link speech recognition functionality in Windows to whatever the hell Linux is doing. It's moving slow, I am changing things as I need them. I'm getting to the point where I could use some assistance but I'm going to hold off asking until I have a good specification/Definition. --- eric There are only two or three Win-only software I need to use, that I have not found an easy to use alternative for a .deb based Linux OS. Also, I have not found any way to use my external USB-based wifi antenna, for "better/faster" useful access 10 floors below my router's antennas. IF so, then Linux would be use for that work "environment", Also, for the "speech issue", I have never been able to got that to work properly for Ubuntu and Linux Mint, as least text to speech. I have not worked with speech to text or speech "system control" before, so I have not really looked into that, much. I couldn't find a good OCR solution for linux either. Project for someone? Cheers Harvey You're kidding right? Check out https://help.ubuntu.com/community/OCR for a quick overview of the current state of affairs. -- 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: [OT] Re: [libreoffice-users] Linux alternative
On 18/07/15 01:44 PM, Felmon Davis wrote: On Sat, 18 Jul 2015, Thomas wrote: Although I know, this does not belong here, just a word. I have been trying (STRUGGLING) to move away from MS and get friendly with Linux for 7-8 years now! So far with little success. Yet, I still keep trying. this makes me wonder what the top two or three things are that people find hard in adopting Linux. I don't want to count the yrs I've used Linux. I was never a full-time user of Windows, I used OS/2 before Linux and Desqview on some version of DOS before that. for the most part I'm barely aware of the operating system: launch a program and work or play is my mode. never gave up command-line habits either, the pictures confuse me like holding a conversation via charades. f. The top reason people find hard is almost certainly that you have to install it. Windows comes pre-installed and there are always those nice people in the who will reformat your drive and reinstall Windows for only a small charge once it gets messed up. :) The other two reasons are: - package that I depend on only runs on Windows, and - game only runs on Windows. All three problems are going away slowly but not without M$ fighting back. -- 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] Linux alternative
On 18/07/15 01:29 PM, Tom Davies wrote: Hi :) +1 But Wine is about bondage in the sense that it keeps you using stuff that is made for Windows. Making stuff that needs Wine in order to work kinda keeps you locked-in to the Windows world. By contrast we see many native Gnu&Linux programs are then ported over to Mac and Windows apparently without a huge amount of effort. Firefox and LibreOffice/OpenOffice are great examples of that as they have then become serious competitors to alternatives that were only written for Windows and then have been unable to be ported to anything else. If programs plan to become cross-platform then initially writing for Linux seems to be the optimum route. Writing for Mac seems to be the next best option. Starting with Windows means programs or almost anything else faces a nightmare up-hill struggle. Even Microsoft themselves take an extra whole year to port their office suite to Mac and even then it's a stripped-down version. Writing for Wine is a neat trick that i have not heard of before. It sounds like it neatly avoids any need for porting at all. Wine runs on Mac too so that is all 3 major platform covered in one hit. It feels like there must be an inherent flaw aside from the ethical issue of not quite breaking free of the Windows world. If not why on earth wouldn't everyone be doing this? ;) Regards from Tom :) Not at all. Wine gives people the opportunity to leave Windows while still running the same software. So long as that software is under a Free license, what makes it any different from stuff that runs on JVM (for example)? I don't need to port my programs when I use Wine/Libwine. They run perfectly on both platforms, And I don't need to have anything to do with Windows whereas if I "port" my programs, I need a Windows platform to test them on. I feel like I'm perfectly free from the Windows world except that I need a VM to run an income tax program and to run Windows versions of browsers (did you know that the Windows version of Firefox doesn't always render pages the same as the Linux version?). There is actually a fair amount of software developed to Windows APIs. Samba and Mono (and programs that use Mono) are two that come to mind immediately. Some people oppose this (especially when the Windows APIs aren't public) but others accept it as a small price to pay to spread Free Software. -- 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] Linux alternative
On 18/07/15 01:04 PM, Luuk wrote: On 18-7-2015 18:00, Gary Dale wrote: Windows is like a pyramid scheme that way. They sucker developers into using only their products so that users have no choice but to buy licenses to run their products properly. And that is exactly why you should not _DEVELOP_ using libwine (using it, because there's not yeat a good alternative, is a complete different story That's not really a good argument. Software freedom is about choice. A lot of people don't have the option to quit Windows right away (if ever) so I give them the option of running software that runs on multiple platforms - the same as Mozilla, The Document Foundation, GIMP and a lot of others do. Being Open Source and under a Free License, I can't keep anyone else from recompiling my software to run on Windows, so why shouldn't I do it myself? -- 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] Linux alternative
On 18/07/15 11:35 AM, Luuk wrote: On 17-7-2015 23:47, Gary Dale wrote: On 17/07/15 05:25 PM, charles meyer wrote: For those on the list using or contemplating Linux, this was interesting. Frankly though, I'm confused as to why more software vendors don't compile to libwine . libwine is about 'bondage'.. It seems some people are just into bondage. :) Not really. Wine has a free license (LGPL). While the individual programs you run on Wine may have other licenses, you aren't obligated to use programs whose license doesn't meet your expectations. What Wine and Libwine do is allow developers to develop and test cross-platform programs on a Linux platform. I have a program that I developed exactly that way. While I could compile a Linux-specific version, I find it easier to just market the single version since it runs on Linux and Windows. The point is that there is no extra work to develop and sell a Linux version of your software if you use the right products. And you not only get a larger target market but also give your customers greater flexibility. For example, I support a small office that uses a Windows-only program. The developers not only don't make a Linux version but they double-down on bondage by only using Windows databases (Access or SQLServer for an extra charge). Had they supported MySQL/MariaDB, I could have at least moved the database to a separate server without worrying about extra licensing, etc.. Windows is like a pyramid scheme that way. They sucker developers into using only their products so that users have no choice but to buy licenses to run their products properly. -- 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] Linux alternative
On 18/07/15 04:31 AM, yahoo-pier_andreit wrote: On 07/18/2015 09:32 AM, Thomas wrote: On 2015/07/18 6:50, Jack Wallen wrote: Thank you for sharing that, Charles (I'm the author). Glad to know it resonated. Jack Thank YOU, Mr. Wallen, for your article. Although I know, this does not belong here, just a word. I have been trying (STRUGGLING) to move away from MS and get friendly with Linux for 7-8 years now! So far with little success. Yet, I still keep trying. many thanks jack, :-) I'm not an expert, I start to use linux, basically opensuse, in 2000, and I agree with thomas, my son, my sister, my nephews uses linux, but, if I didn't install it and configure it and solved the problems that rised up and sometimes continues to pop up, they never started to use linux. too complicate... :-) The same issue afflicts Windows. It's just that Windows usually comes pre-installed. Having performed a lot of installs of both types, I've found the Linux installs to be simpler and a lot faster. Windows may get to the login screen a bit faster but then you've got interminable updates to install with reboots needed between most of them. As for needing assistance, I find a lot more problems cropping up with Windows than with Linux. And yes, most end-users aren't equipped to deal with them but that isn't dependent on the operating system. However fixing Windows problems is more difficult and sometimes even fruitless (e.g. Windows Updates that mysteriously fail). I've used Linux pretty much exclusively (except for an income tax program that I haven't got to work in wine) for 18 years. I find Windows to be awkward and limiting. And after looking at Windows 8, it seems to be getting worse, not better. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Linux alternative
On 17/07/15 05:25 PM, charles meyer wrote: For those on the list using or contemplating Linux, this was interesting. http://www.techrepublic.com/article/alternative-is-the-question-linux-is-the-answer/ No one really addressed software only written for Windows - e.g. Dragon Naturally Speaking. There doesn't seem to be a good open source or Linux-based voice recognition software. That can be a deal breaker. But, for those of us not interested in grappling with W10, it's a conundrum. Charles. There's some pretty decent Linux voice recognition software out there, and lots of articles talking about the various options. Frankly though, I'm confused as to why more software vendors don't compile to libwine and get software that runs on both (and Macs). They could also switch their database options to Sqlite or MariaDB and reduce their costs while getting a more reliable product. It seems some people are just into bondage. :) -- 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] date
On 05/07/15 12:39 PM, Luuk wrote: On 5-7-2015 11:51, Dr. Martin Hennegriff wrote: Dear Sir, Libreoffice provides two date functions: a 'fixed' version and a 'dynamic' one. Q: How can I change the default? Regards, Since you only have a 'fixed' and a 'dynamic' one, you cannot change the 'default' one. ;) (Or, more info is needed. What are you actually trying to do?) I think if you were being a little less clever you'd guess that he is trying to set either the fixed or dynamic date function to be the default one if he just inserts a date. Currently, at least on my system, the "default" is fixed. I'm not sure you can alter that, but that seems to be the crux of his question. -- 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] open files automatically
On 27/05/15 09:32 AM, Tom Davies wrote: Hi :) If the folder contains some spreadsheets and some other things and you only want to open the spreadsheets then the fastest way i can think of is to use the file-browser to arrange/sort the files "by type" rather than by name or date. That might make it easier to select them all. I think other people have had better suggestions already though. I was wondering if it might be possible to "script it" but kinda assumed it probably wouldn't be at all easy = so i like Gary's suggestion! :) Regards from Tom :) Thanks Tom. If the OP is using Windows, it should still work although they may not be able to do the file loop. The raw command should work on any OS so it may just be a matter of using lots of -o's or running the command multiple times, once per file. -- 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] open files automatically
On 27/05/15 02:05 AM, Brian Barker wrote: At 10:22 27/05/2015 +0900, Thomas Noname wrote: Is there a trick to tell LibreOffice, in particular Calc, to open files automatically? Not that I know of. (Perhaps someone knows better.) Lotus 123 allows to specify a folder and then opens the files therein automatically whenever the software is started. For those administrative tasks, a set of 2-3 files, this is VERY convenient. I would like to convert those 123-files into Calc format and have Calc open them *automatically* whenever I start Calc. It's worth mentioning that you cannot "start Calc": that's not how LibreOffice works. You can do either of two different things: either start LibreOffice or start LibreOffice with a new, empty spreadsheet. And that tells you something about your problem: if you could do what you wanted, there would be no way to prevent your spreadsheet documents being opened if you wanted to start LibreOffice to edit a text file (or, as you would say, "start Writer") or presentation or whatever instead. I have no problem starting Calc nor opening several spreadsheets "automatically". I select the sheets I open in Dolphin (or any other file manager) and right-click on the selection then select "Open with". Calc is the default program to open .ods documents so they all open. Since the OP wants a job to run at startup, simply use the command-line to do the job: libreoffice --calc -o -o ... Put that into a script or a link to a script in your "Autostart" folder (.kde/Autostart on my KDE system). To open all the files in a folder, just use a loop like this: for f in *; do; libreoffice --calc -o $f; done We don't need no stinking features when we've got a real command line. :) There are many workarounds, which depend on your operating system - which you have kept a secret. (You appear to be using Windows XP.) o Your operating system will probably offer a way to start programs at start-up - when you log in, that is. You could put your document files (or possibly shortcuts to them?) in the appropriate folder. o You could put your documents or shortcuts to them somewhere convenient, such as on the desktop or in the start menu, and then click on these when you need the documents open. o (Probably best) Put the documents in a convenient folder. (You've done that already.) Create a shortcut to this on the desktop or in the start menu. When you need to open the documents, (1) click or double-click the shortcut to open the folder, (2) select all the document files together (using Edit | Select All or Ctrl+A?), and (3) press Enter to open all the documents (whether or not LibreOffice is already running). 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
Re: [libreoffice-users] Printing serial letters
On 12/10/14 07:28 PM, Dave Barton wrote: Gary Dale wrote: On 12/10/14 06:27 AM, Dave Barton wrote: Gary, Please add a reproducible example to Heinrich's report. This will: a) Assist QA in assessing if it is the same bug or not. b) Add more weight to the issue, which in turn is more likely to attract a developer's interest. If you know it's not the exactly the same issue and your reference to "messing up colors" suggests that it may not be, please find and contribute to an existing report, or open a new one. Nobody (developer, QA or other) "denies the existence of an issue", but no issue can be effectively resolved if it cannot be replicated and it's cause determined. Which is where we come in with accurate reports and reproducible examples. This list is a great place to vent our frustrations about our "pet" issues, but at the end of the day our "rants" here do nothing, only our contributions (ie. bug reports and reproducible examples) will help to get anything done. Dave I've already done everything you asked and more, No, I have not asked you to do anything, except provide a pointer to the location where the details of the issue could be found. Actually you asked for a reproducible example, which I've already provided, along with screen shots showing the bug. No, at that time you had given no information about any report you may have made. Only later did you come forward with a bug report number. I've done what you asked already by providing the developers with the information. including sending screen shots to demonstrate that the problem is with LibreOffice and not something else. Where are these screen shots? There are no attachments to bug 83346. That's because bugzilla refuses to take e-mail from me. I can send bug reports via reportbug but it doesn't want to take e-mail sent via icedove, probably due to the way it reads addresses - ignoring the reply-to and only using the from field. I don't understand what you mean about emailing into Bugzilla. I have been using the Bugzilla software for over a decade and to the best of my knowledge it does not accept email input. If you know differently please enlighten me. Of course bugzilla, like other bug tracking systems, takes e-mail responses to bugs. The problem is that the way LibreOffice's bugzilla is set up, it rejects messages where the "from" sender is not registered with the message "There is no user named ''. Either you mis-typed the name or that user has not yet registered for a Bugzilla account." In this it differs from other list response systems that take any "from" information. This doesn't work for people who use e-mail forwarders as permanent addresses that forward to whatever mail account they have with their current ISP. If you look in the print dialogue, it shows that LibreOffice thinks it is printing 2N-1 pages instead of N pages. And no, this is not the "print automatically inserted blank pages" "feature". There is no way for others to determine if this is true without details (eg. samples, screen shots, etc.) You can get them directly from developer Cor Nouws. The fact that he failed to attach them to the bug report suggests that he doesn't see the problem. No I can't get them from Cor. I don't know if he is a developer or not, but either way it is your issue and you opened the report, so if you wanted to get your issue resolved it is your responsibility to make the necessary information available on Bugzilla where others can evaluate it. If the developers want to get information about potential problems with their code, they need to ensure that it is easy and convenient for people to report them. The reason I think it is probably the same bug is that in both cases LibreOffice doesn't initiate the new page properly. I guess in monochrome it chews up some text while in colour it mangles the colour coding. It does not necessarily follow that similar issues come from the same section of the (very large) code base. I have seen numerous examples where changes to one part of the code has an unexpected impact on an apparently unrelated function. Perhaps but the odds are against the same effect having two separate causes. The odds are very much in favour of it having a separate cause, because Heinrich now reports that his issue has been resolved in a more recent version. Thanks for the heads up. I don't do form letters every day. I just checked and it appears to working on my system too. My latest bug report on it was 83346. I sent the samples to Cor Nouws who closed the bug after deciding that it was a "feature" that no sane person would ask for - the mangling of colours. Apparently he didn't note that "feature" he thought it was, was actually a symptom of the problem I was reporting. Th
Re: [libreoffice-users] Printing serial letters
On 12/10/14 06:27 AM, Dave Barton wrote: Original Message From: Gary Dale To: Dave Barton Date: Sun, 12 Oct 2014 00:14:10 -0400 On 11/10/14 04:59 PM, Dave Barton wrote: Heinrich Stöllinger wrote: Hello, A long time ago (REALLY long ago!) I complained that LO does not print serial letters correctly. I think I also filed a bug report with (in MY opinion!) the right test data. I just tried to print such serial letters again today. Unfortunately the problem still exists. As you can maybe see from the enclosed pdf-file, only the FIRST letter prints correctly, while ANY letters after the first one miss out lines of text (e.g. the place and date near the top on the right), drawn lines (near the bottom). Even though I use a MySQL database as "supplier" of DB-fields, I don't think this has anything to do with Base. It should be easy enough to put together a test for this issue, but I include the respective .odt-file in any case. Again, I don't think a DB-table is necessary for testing. Regards Heinrich Heinrich, Is https://bugs.freedesktop.org/show_bug.cgi?id=76257 the bug report you are referring to? If so, I will take a look and see if I can replicate and confirm it. Gary, Please add a reproducible example to Heinrich's report. This will: a) Assist QA in assessing if it is the same bug or not. b) Add more weight to the issue, which in turn is more likely to attract a developer's interest. If you know it's not the exactly the same issue and your reference to "messing up colors" suggests that it may not be, please find and contribute to an existing report, or open a new one. Nobody (developer, QA or other) "denies the existence of an issue", but no issue can be effectively resolved if it cannot be replicated and it's cause determined. Which is where we come in with accurate reports and reproducible examples. This list is a great place to vent our frustrations about our "pet" issues, but at the end of the day our "rants" here do nothing, only our contributions (ie. bug reports and reproducible examples) will help to get anything done. Dave I've already done everything you asked and more, No, I have not asked you to do anything, except provide a pointer to the location where the details of the issue could be found. Actually you asked for a reproducible example, which I've already provided, along with screen shots showing the bug. including sending screen shots to demonstrate that the problem is with LibreOffice and not something else. Where are these screen shots? There are no attachments to bug 83346. That's because bugzilla refuses to take e-mail from me. I can send bug reports via reportbug but it doesn't want to take e-mail sent via icedove, probably due to the way it reads addresses - ignoring the reply-to and only using the from field. If you look in the print dialogue, it shows that LibreOffice thinks it is printing 2N-1 pages instead of N pages. And no, this is not the "print automatically inserted blank pages" "feature". There is no way for others to determine if this is true without details (eg. samples, screen shots, etc.) You can get them directly from developer Cor Nouws. The fact that he failed to attach them to the bug report suggests that he doesn't see the problem. The reason I think it is probably the same bug is that in both cases LibreOffice doesn't initiate the new page properly. I guess in monochrome it chews up some text while in colour it mangles the colour coding. It does not necessarily follow that similar issues come from the same section of the (very large) code base. I have seen numerous examples where changes to one part of the code has an unexpected impact on an apparently unrelated function. Perhaps but the odds are against the same effect having two separate causes. My latest bug report on it was 83346. I sent the samples to Cor Nouws who closed the bug after deciding that it was a "feature" that no sane person would ask for - the mangling of colours. Apparently he didn't note that "feature" he thought it was, was actually a symptom of the problem I was reporting. There is no way of determining if Cor was right or wrong if the samples you refer to are not made publicly available (eg. Bugzilla). At this stage I am not going to reopen the report, but if you want to reply to https://bugs.freedesktop.org/show_bug.cgi?id=83346#c2 I am prepared to work with you on this. Please do not send anything directly to me. I am not an active developer, but if this can be demonstrated as an issue that needs fixing, it can be brought to the attention of the developers. Again, blame Cor for not attaching them. So long as bugzilla doesn't take legitimate followups, I can't do much. I'd like to send you the e-mail I sent him but if you're not willing to accept it
Re: [libreoffice-users] Printing serial letters
I've reported the same bug myself with respect to labels and having the printer mess up the colours on all pages past the first. It's been around for a long time but the developers deny that it occurs. I don't know how they do their testing but I've had the problem with Debian and Ubuntu printing to different documents to different printers. I have no trouble recreating it. On 11/10/14 01:08 PM, Heinrich Stöllinger wrote: Hello, A long time ago (REALLY long ago!) I complained that LO does not print serial letters correctly. I think I also filed a bug report with (in MY opinion!) the right test data. I just tried to print such serial letters again today. Unfortunately the problem still exists. As you can maybe see from the enclosed pdf-file, only the FIRST letter prints correctly, while ANY letters after the first one miss out lines of text (e.g. the place and date near the top on the right), drawn lines (near the bottom). Even though I use a MySQL database as "supplier" of DB-fields, I don't think this has anything to do with Base. It should be easy enough to put together a test for this issue, but I include the respective .odt-file in any case. Again, I don't think a DB-table is necessary for testing. Regards Heinrich -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer stopped printing form letters
I went the other way and pulled down the version from Sid (Version: 4.3.1.2 Build ID: 430m0(Build:2)) - not sure why it has the same version as jessie but it works. Thanks everyone. On 22/09/14 05:38 AM, Tom Davies wrote: Hi :) Have you tried renaming the User Profile? https://wiki.documentfoundation.org/UserProfile It's usually a good first thing to try when something weird suddenly starts happening as it gets everything "back to factory defaults". It might also be worth trying the (in Debian terms) stable branch rather than the development branch. We call them "still" and "fresh" but it means roughly the same thing. http://www.libreoffice.org/download/libreoffice-fresh/?type=deb-x86&version=4.2.6&lang=en-GB Regards from Tom :) On 22 September 2014 05:48, Steve Edmonds wrote: Hi. Did anything change from the last time you printed these (LO, OS). Is the printer plugged in or networked. I had this once but can't remember what caused it or how I fixed it. Steve On 2014-09-22 16:30, Gary Dale wrote: Something I've been doing for years now has stopped working. I print tickets using Writer 5 to a page. The tickets have a stub portion and are numbered so that the stub and ticket portion have the same number. The number field gets inserted twice on each ticket. The number field is almost the only text. The tickets are actually designed separately and imported as a background graphic. The numbers increase by some amount for the second, third, etc. tickets so that the subsequent sheets can have consecutively numbered tickets. This makes cutting and assembly into books easy. By connecting to a Calc spreadsheet I can print off as many as I need with unique numbers. Except this time when I get to the Mail Merge dialogue, select the records I want to print then hit print, the dialogue closes but the printer selection never opens. I've tried this on another document that I'd printed earlier and got the same result. For some reason form letter printing seems to be broken. Is anyone else having this problem? BTW: running Debian/Jessie with LibreOffice Version: 4.3.1.2, Build ID: 430m0(Build:2). -- 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
Re: [libreoffice-users] Writer stopped printing form letters
I'm running Jessie, which is the testing branch of Debian, so things change daily. On 22/09/14 12:48 AM, Steve Edmonds wrote: Hi. Did anything change from the last time you printed these (LO, OS). Is the printer plugged in or networked. I had this once but can't remember what caused it or how I fixed it. Steve On 2014-09-22 16:30, Gary Dale wrote: Something I've been doing for years now has stopped working. I print tickets using Writer 5 to a page. The tickets have a stub portion and are numbered so that the stub and ticket portion have the same number. The number field gets inserted twice on each ticket. The number field is almost the only text. The tickets are actually designed separately and imported as a background graphic. The numbers increase by some amount for the second, third, etc. tickets so that the subsequent sheets can have consecutively numbered tickets. This makes cutting and assembly into books easy. By connecting to a Calc spreadsheet I can print off as many as I need with unique numbers. Except this time when I get to the Mail Merge dialogue, select the records I want to print then hit print, the dialogue closes but the printer selection never opens. I've tried this on another document that I'd printed earlier and got the same result. For some reason form letter printing seems to be broken. Is anyone else having this problem? BTW: running Debian/Jessie with LibreOffice Version: 4.3.1.2, Build ID: 430m0(Build:2). -- 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] Writer stopped printing form letters
Something I've been doing for years now has stopped working. I print tickets using Writer 5 to a page. The tickets have a stub portion and are numbered so that the stub and ticket portion have the same number. The number field gets inserted twice on each ticket. The number field is almost the only text. The tickets are actually designed separately and imported as a background graphic. The numbers increase by some amount for the second, third, etc. tickets so that the subsequent sheets can have consecutively numbered tickets. This makes cutting and assembly into books easy. By connecting to a Calc spreadsheet I can print off as many as I need with unique numbers. Except this time when I get to the Mail Merge dialogue, select the records I want to print then hit print, the dialogue closes but the printer selection never opens. I've tried this on another document that I'd printed earlier and got the same result. For some reason form letter printing seems to be broken. Is anyone else having this problem? BTW: running Debian/Jessie with LibreOffice Version: 4.3.1.2, Build ID: 430m0(Build:2). -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: longstanding bugs - what does it take to get them fixed?
On 01/09/14 01:24 AM, Alex Thurgood wrote: Le 01/09/2014 02:25, Gary Dale a écrit : Who do I have to talk to in order to get these bugs addressed? A developer who is prepared either to fix it for free, one who will want money or gifts for doing so, or alternatively a developer who works for a company that offers paid tier 3 support. Whatever the scenario, it would be better to check with the LibreOffice bugzilla, to see whether the bugs have already been registered (or not, as the case may be) and then point the paid developers / support company in that direction. As for the volunteer developers, you can't tell any of them what to do nor when to do it, they are, after all, volunteers, much as virtually anyone else helping out here. Bug reports from the LibreOffice bugzilla are automatically referenced on the libreoffice IRC developer channel. Some developers follow particular modules, others just look at the ones they happen to be interested in at any given time. There are also a whole host of mailmerge bugfixes awaiting approval for integration into the master code repository from the Munich Wollmux project. Whether or not any of those cover your problems, I couldn't say. Alex Thanks Alex. It would have helped if "the home of LibreOffice" contained that information. :) -- 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] longstanding bugs - what does it take to get them fixed?
Probably not every LibreOffice writer user prints mailing lists but I'd have thought that a lot of people do. Yet these bugs don't seem to be getting fixed despite my having reported them several times over the years. Both of them are demonstrated in the attached file, which happens to be a mailing label form. Other forms with multiple records per page suffer the same problems. The first bug is that a blank page gets printed between each page. On this file it's not too bad because it only prints in black, but colour pages have to be printed one at a time because the subsequent pages don't seem to get the colour initialization correct. With just black, it merely results in a blank page between every printed page. The second bug is that labels don't use horizontal pitch, despite it being defined. Instead the start of the second and subsequent labels across a row are calculated using the label width. This should be a simple one-line fix. The program is using the wrong variable for its calculations. This particular file was set up to print to Avery 5260 address labels, which has a gap between labels. In order to get them to print properly, I have to adjust the width to be same as the horizontal pitch or the labels start in the gap. Who do I have to talk to in order to get these bugs addressed? -- 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
