[libreoffice-users] Re: converting txt to dates
If DATEVALUE(A2) is giving an error, maybe there is something else in the cell, or you are using English-US as language then it is an invalid date, month=14? You can also try with Menu/Data/Text to column after select the data, click on column head and select in column type the day type. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4143832.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] converting txt to dates
On 19/03/15 08:28 PM, James wrote: Column A has text strings that are DD/MM/ format. I want to make them real dates. I tried these 2 datevalue formulas but I can't make it work. 14/03/2015Err:502 14/03/2015Err:502 =DATEVALUE(TEXT(A1,"##/##/")) =DATEVALUE(A2) Highlight the cells Right click FORMAT CELLS NUMBERS tab In the FORMAT CODE block at the bottom, put DD/MM/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Writer won't let me manually hyphenate a name.
On 03/19/2015 09:19 PM, Robert Funnell wrote: On Thu, 19 Mar 2015, Doug wrote: /snip/ As I read the manuals, I should be able to just use 'ctrl plus -' to manually place a hyphen. But this doesn't work either. /snip/ This sort of thing is _exactly_ why I won't use LO or AOO! --doug Doug: So why exactly are you on this list? - Robert Just a hold-over from when I actually tried to use LO/AOO, before I gave up. I have been using a paid version of SoftMaker Office 2012--which btw, can read and write _all_ the MS Word version--and I don't have the aggravations like Eric wrote about. (Free products are nice, but if they can't hack it, then I'm not averse to paying a reasonable price for something that will.) --doug -- 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: Using SQL functions in LibreOffice base (notation)
On Thu, 2015-03-19 at 19:21 -0700, xavier2 wrote: > Hi, seems to be LibreOffice base it's using HSQLDB... > However, I don't know if there is available any website describing examples > of code of HSQLDB for LibreOffice Base... > someone here knows any? There is a good tutorial that helped me understand how base works on their wiki.documentfoundation page. The book is called Base_tutorial by Mariano Casanova. It has examples for sql code, forms, queries, reports, and views. Direct link: https://wiki.documentfoundation.org/images/0/02/Base_tutorial.pdf JM -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Using SQL functions in LibreOffice base (notation)
Hi, seems to be LibreOffice base it's using HSQLDB... However, I don't know if there is available any website describing examples of code of HSQLDB for LibreOffice Base... someone here knows any? -- View this message in context: http://nabble.documentfoundation.org/Using-SQL-functions-in-LibreOffice-base-notation-tp4143811p4143831.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Writer won't let me manually hyphenate a name.
thanks. I tried what Tim suggested. It then will break after 'Bruin' until I enter more characters. Then it breaks after 'Bru'. So it wasn't that the manual break wasn't working--it was insisting on breaking automatically before it got to the manual break. So I need some way to stop it from breaking after 'Bru' when it wants to do that. Either only let it break after 'Bruin' or keep it from breaking altogether, as John suggested. But I don't want to turn off automatic hyphenating for the entire paragraph style. It looks like there's a method for preventing hyphenation in the name altogether--in 'writing aids' under options, by adding the word to a dictionary followed by '='.That seems to have done it. I think I've also finally found how to prevent auto hyphenating at undesired points (like 'Bru-')--certainly not intuitive: inserting 'No width no break'. Thanks for the suggestions. On 03/19/2015 09:21 PM, John Jason Jordan wrote: On Thu, 19 Mar 2015 20:26:26 -0400 Eric Beversluis dijo: I've got a name 'Bruinsma' that LO wants to hyphenate between the 'u' and the 'i'. I'm trying to get it to hyphenate between the 'n' and the 's'. LO won't let me. I go to tools->language->hyphenation with the word highlighted, but there's no way I can get it to move the hyphen. If I put my cursor where I want it to hyphenate and click 'hyphenate', it just closes the dialog and leaves the hyphen in the original place. There also doesn't seem to be a way to tell LO not to hyphenate that word at all. As I read the manuals, I should be able to just use 'ctrl plus -' to manually place a hyphen. But this doesn't work either. I don't know the answer to your question, but I'd like to point out that in traditional typesetting proper names are not hyphenated. I have LO 4.2.7.2 on Xubuntu and Ctrl - does add a hyphen in 'Bruinsma' as you wanted it to do. And the name does break on the optional hyphen when I add text to force it beyond the end of the line. Do I assume correctly that otherwise hyphenation is working as expected? -- 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] converting txt to dates
Column A has text strings that are DD/MM/ format. I want to make them real dates. I tried these 2 datevalue formulas but I can't make it work. 14/03/2015Err:502 14/03/2015Err:502 =DATEVALUE(TEXT(A1,"##/##/")) =DATEVALUE(A2) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Writer won't let me manually hyphenate a name.
On Thu, 19 Mar 2015 20:26:26 -0400 Eric Beversluis dijo: >I've got a name 'Bruinsma' that LO wants to hyphenate between the 'u' >and the 'i'. I'm trying to get it to hyphenate between the 'n' and the >'s'. LO won't let me. I go to tools->language->hyphenation with the >word highlighted, but there's no way I can get it to move the hyphen. >If I put my cursor where I want it to hyphenate and click 'hyphenate', >it just closes the dialog and leaves the hyphen in the original place. >There also doesn't seem to be a way to tell LO not to hyphenate that >word at all. > >As I read the manuals, I should be able to just use 'ctrl plus -' to >manually place a hyphen. But this doesn't work either. I don't know the answer to your question, but I'd like to point out that in traditional typesetting proper names are not hyphenated. I have LO 4.2.7.2 on Xubuntu and Ctrl - does add a hyphen in 'Bruinsma' as you wanted it to do. And the name does break on the optional hyphen when I add text to force it beyond the end of the line. Do I assume correctly that otherwise hyphenation is working as expected? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Writer won't let me manually hyphenate a name.
Here is a what I saw. * I enter the word bruinsma * place cursor between 'n' & 's' * CTRL + '-' nothing happens. However if I add text which pushes that word to straddle 2 lines, a hyphen appears between 'n' & 's' and stays in the word for the foreseeable. Is this what you are attempting? To hyphenate when a word crosses the line boundary? 4.4.1.2 from the LO website and Fedora 21 BTW Cheers On 20/03/15 11:26, Eric Beversluis wrote: I've got a name 'Bruinsma' that LO wants to hyphenate between the 'u' and the 'i'. I'm trying to get it to hyphenate between the 'n' and the 's'. LO won't let me. I go to tools->language->hyphenation with the word highlighted, but there's no way I can get it to move the hyphen. If I put my cursor where I want it to hyphenate and click 'hyphenate', it just closes the dialog and leaves the hyphen in the original place. There also doesn't seem to be a way to tell LO not to hyphenate that word at all. As I read the manuals, I should be able to just use 'ctrl plus -' to manually place a hyphen. But this doesn't work either. Using LO Version: 4.2.8.2 Build ID: 4.2.8.2-6.fc20 What am I missing? 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] LO Writer won't let me manually hyphenate a name.
On Thu, 19 Mar 2015, Doug wrote: On 03/19/2015 08:26 PM, Eric Beversluis wrote: I've got a name 'Bruinsma' that LO wants to hyphenate between the 'u' and the 'i'. I'm trying to get it to hyphenate between the 'n' and the 's'. LO won't let me. I go to tools->language->hyphenation with the word highlighted, but there's no way I can get it to move the hyphen. If I put my cursor where I want it to hyphenate and click 'hyphenate', it just closes the dialog and leaves the hyphen in the original place. There also doesn't seem to be a way to tell LO not to hyphenate that word at all. As I read the manuals, I should be able to just use 'ctrl plus -' to manually place a hyphen. But this doesn't work either. Using LO Version: 4.2.8.2 Build ID: 4.2.8.2-6.fc20 What am I missing? Eric: If you use 'ctrl plus -' to insert an optional hyphen before the 'u', does it take effect? If you put it after the place where LO already wants to hyphenate, it makes sense that it won't have an effect, unless you turn off automatic hyphenation in the paragraph style. Thanks. This sort of thing is _exactly_ why I won't use LO or AOO! --doug Doug: So why exactly are you on this list? - Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Writer won't let me manually hyphenate a name.
On 03/19/2015 08:26 PM, Eric Beversluis wrote: I've got a name 'Bruinsma' that LO wants to hyphenate between the 'u' and the 'i'. I'm trying to get it to hyphenate between the 'n' and the 's'. LO won't let me. I go to tools->language->hyphenation with the word highlighted, but there's no way I can get it to move the hyphen. If I put my cursor where I want it to hyphenate and click 'hyphenate', it just closes the dialog and leaves the hyphen in the original place. There also doesn't seem to be a way to tell LO not to hyphenate that word at all. As I read the manuals, I should be able to just use 'ctrl plus -' to manually place a hyphen. But this doesn't work either. Using LO Version: 4.2.8.2 Build ID: 4.2.8.2-6.fc20 What am I missing? Thanks. This sort of thing is _exactly_ why I won't use LO or AOO! --doug -- 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] LO Writer won't let me manually hyphenate a name.
I've got a name 'Bruinsma' that LO wants to hyphenate between the 'u' and the 'i'. I'm trying to get it to hyphenate between the 'n' and the 's'. LO won't let me. I go to tools->language->hyphenation with the word highlighted, but there's no way I can get it to move the hyphen. If I put my cursor where I want it to hyphenate and click 'hyphenate', it just closes the dialog and leaves the hyphen in the original place. There also doesn't seem to be a way to tell LO not to hyphenate that word at all. As I read the manuals, I should be able to just use 'ctrl plus -' to manually place a hyphen. But this doesn't work either. Using LO Version: 4.2.8.2 Build ID: 4.2.8.2-6.fc20 What am I missing? 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] Using SQL functions in LibreOffice base (notation)
On Thu, 2015-03-19 at 15:15 -0700, xavier2 wrote: > Hello > I need to insert the current date from my computer into a field from a > database. > SQL has a function called NOW() which introduce the current date into a > field. However, I don't know very well how this work. I tried to visit a > website giving code examples in SQL... w3schools.com however I find > differences between the SQL language posted in that website and the SQL > language used in LibreOffice Base > > For example, at w3schools.com they would suggest me this code to introduce > the current system date and hour into a field of my database (sorry for the > fields are in Spanish)... > > SELECT > ID_Empleados, > Nombre, > Apellido1ero, > Direccion, > > NOW( ) > PerDate > > FROM > tbl_EMPLEADOS > > Okay, that code will fail in LibreOffice Base, and it is SQL ... > > ??? > > However, if I use " " then the code work... I am new to sql myself but, I believe that base auto converts all sql code into capitals letters. If you used all capitals for the columns in your table, then you should be fine, else you must define the string literals with surrounding double quotes. "" > This code will work in LibreOffice Base... > > SELECT > "ID_Empleados", > "Nombre", > "Apellido1ero", > "Direccion", > > NOW( ) > "PerDate" > > FROM > "tbl_EMPLEADOS" > > As you may see, the code is exactly the same except that LibreOffice Base > SQL need quotation marks " " to define the name of fields and tables... > > So I was wondering if the SQL from LibreOffice Base change very much from > the original SQL and if we have more notation changes... > > ??? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Using SQL functions in LibreOffice base (notation)
Hello I need to insert the current date from my computer into a field from a database. SQL has a function called NOW() which introduce the current date into a field. However, I don't know very well how this work. I tried to visit a website giving code examples in SQL... w3schools.com however I find differences between the SQL language posted in that website and the SQL language used in LibreOffice Base For example, at w3schools.com they would suggest me this code to introduce the current system date and hour into a field of my database (sorry for the fields are in Spanish)... SELECT ID_Empleados, Nombre, Apellido1ero, Direccion, NOW( ) PerDate FROM tbl_EMPLEADOS Okay, that code will fail in LibreOffice Base, and it is SQL ... ??? However, if I use " " then the code work... This code will work in LibreOffice Base... SELECT "ID_Empleados", "Nombre", "Apellido1ero", "Direccion", NOW( ) "PerDate" FROM "tbl_EMPLEADOS" As you may see, the code is exactly the same except that LibreOffice Base SQL need quotation marks " " to define the name of fields and tables... So I was wondering if the SQL from LibreOffice Base change very much from the original SQL and if we have more notation changes... ??? -- View this message in context: http://nabble.documentfoundation.org/Using-SQL-functions-in-LibreOffice-base-notation-tp4143811.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Size of calc window
On 03/19/2015 05:52 AM, Tom Davies wrote: Hi :) Sorry! I don't have a good answer for this except the weird work-around that is not helping you in this case. :( No problem. Thanks for trying. It's not a game breaker just an oddity I noticed. It might be good to post a bug-report about it. I'm not sure who to but if you post to LibreOffice bug-reporting system the QA Team might be able to help. Apols and regards from Tom :) I am using the old 3.xx branch and I doubt anyone is interested in fixing it now. When I eventually upgrade to the 4.xx branch if it is still present I will at that point. Thanks, Jim On 17 March 2015 at 14:39, Jim Byrnes wrote: On 03/17/2015 06:31 AM, Tom Davies wrote: Hi :) Is this set by the OS rather than by LibreOffice? Oddly it does work for me on Ubuntu 14.04. It does for me to as far as the OS part of it goes, I did a poor job of asking my question. If I have 2 spreadsheets A & B. A is run full screen and B is run using half the screen. If I shutdown A and then reopen A it is full screen. If I shut down B and then reopen B it takes half the screen. What I am asking about is if I shut down A and then open B, B will open full screen. what I would like is A to always be fullscreen and B to always be half screen. Regards. Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: database2spreadsheet
Am 19.03.2015 um 11:37 schrieb hw: > >> For a LibreOffice user there is only one built-in tool to do reporting >> with pictures. It is the report tool. > > Hm, I'm not too happy with that because the defaults aren't too useful, > and when I wanted to make a report to display data from a table, the > report didn't display any of the data but the default placeholders instead. > I'm pretty sure this can be fixed one way or the other. Sorry, I don't know about this problem since I do not use that reporting tool (in fact I do not even use LibreOffice). Assuming that you get that report with pictures running and you really want to manipulate the data on that report and you know that this is NOT how things should be done because your reports would differ from your database content, then all you need to do is calling menu:File>SaveAs... and save a new writable copy of that Writer document. All reports are read-only Writer documents in the first place. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: database2spreadsheet
Am 19.03.2015 um 11:49 schrieb hw: > Copying icons? > Indeed. In order to copy table or view contents from one DB to another DB you copy the table _icon_ from one database window, select the table icon in the other database window (the DB where you have write access) and paste. A dialog pops up which lets you map the matching fields of both tables. -- 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: Size of calc window
Hi :) Sorry! I don't have a good answer for this except the weird work-around that is not helping you in this case. :( It might be good to post a bug-report about it. I'm not sure who to but if you post to LibreOffice bug-reporting system the QA Team might be able to help. Apols and regards from Tom :) On 17 March 2015 at 14:39, Jim Byrnes wrote: > On 03/17/2015 06:31 AM, Tom Davies wrote: > >> Hi :) >> Is this set by the OS rather than by LibreOffice? Oddly it does work for >> me on Ubuntu 14.04. >> >> > > > It does for me to as far as the OS part of it goes, I did a poor job of > asking my question. If I have 2 spreadsheets A & B. A is run full screen > and B is run using half the screen. If I shutdown A and then reopen A it is > full screen. If I shut down B and then reopen B it takes half the screen. > What I am asking about is if I shut down A and then open B, B will open > full screen. what I would like is A to always be fullscreen and B to > always be half screen. > > Regards. Jim > > > > > -- > 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] Re: database2spreadsheet
Am 17.03.2015 um 21:34 schrieb Andreas Säger: Am 17.03.2015 um 13:22 schrieb hw: Ok, so I want to import data from a CSV file and would like to have some formatting applied automatically, like specifying a particular width and conditional formatting for some of the columns when I open the file which is sent to me by email. It would be possible to write some extra data into the CSV to achieve this. How could I do this? Simply use the database engine of your choice. The one you are already connected with. It should provide all the capabilities to export, import and link csv table. In this case you would not need any Office suite at all. Office users can import csv files in the office GUI. Copying table icons from a text connected database into a regular database or copying spreadsheet cells onto the icon of a database table. Copying icons? For the built-in HSQLDB this is described here: [Tutorial] Using csv/text files as editable data source. https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 And it works in the same way with later versions of HSQL. Since you do not mention your database engine, Google is your friend. mysql There are thousands of hits about csv and MySQL. All this works without any office suite and your Perl script can simply issue some SQL command via the dbi module (I think). Yes, it uses DBI to do its work. I'm 100& sure that an office suite can not add anything to your project. It makes life a hell of a lot easier because it provides a very useful frontend. Operate your database any way you want. Finally you may or may not load the results into document templates. [Example] Loading CSV into preformatted spreadsheets https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=23727 how to maintain prepared Calc templates to be filled with raw data from csv (or any other kind of data source provided by the Base component). Awesome, thank you! That might be exactly what I'm looking for, I'll check it out. -- 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: database2spreadsheet
Am 17.03.2015 um 21:41 schrieb Andreas Säger: Am 17.03.2015 um 13:36 schrieb hw: Sorry, this is the wrong answer to the right post --- still a question, though. The answer to this post should have been that I would need the images to appear in the spread sheet. Pictures in Calc are no spreadsheet data. Pictures are decorative, illustrating elements pinned to the cells or to the top-left corner of a sheet. Writing a program to manipulate many calculator cells so they wrap around picture objects is very difficult. Absolutely non-trivial. Hence my idea to resize the pictures outside of LO to suitable dimensions and put links to the resized ones into the CSV (or a databse table) to have them displayed reasonably in the spreadsheet. For a LibreOffice user there is only one built-in tool to do reporting with pictures. It is the report tool. Hm, I'm not too happy with that because the defaults aren't too useful, and when I wanted to make a report to display data from a table, the report didn't display any of the data but the default placeholders instead. You are a Perl programmer. This kind of stuff has always be done with html reports. Then the data cannot be edited as easily as with a spreadsheet ... However, a web page just like a spreadsheet would be very useful. I will have to look for some tool that works for this; there's probably something I could 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] Re: Business Cards - Printing - Libre Writer version 4.3.5.2
There is a program called gLabels. I use it to create mailing labels. Re: business cards, I would avoid laser, as business cards are usually stacked together, so they rub. They will wear off the laser toner. Ink is soaked into the paper so it won't come off. That would interfere with the image that you are trying to create. John On 03/15/2015 04:31 AM, Andreas Säger wrote: Am 15.03.2015 um 01:18 schrieb charles meyer: Hi Folks, I’ve never printed business cards using Libre Writer and it didn’t go well using the Avery online template. I have blank sheets of cardstock (bought at Office Depot) to print my own business cards with logo - one sided only. There’s 10 business cards on each sheet of cardstock - 2 across and 5 down. Each card is 2 inches by 3.5 inches. Is there some kind of a template in Libre Writer for business card printing? I’ll bet you can do it by using tables or charts but that’s way past my expertise. Thanks so much! Charles. Hi, menu:File>New>Business Cards... Fill out that dialog and LibreOffice will generate a page with separate frames representing the space of one card. --- If you want to use one of the downloadable templates from various sites, these have basically one table without borders. Each cell represents the space of a business card. Right-click and check "Table Boundaries" to make the cells visible on screen but not on the print out. Now you can edit a single table cell to your liking, copy the cell content and paste into each cell. Hope this helps -- 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
