Re: [libreoffice-users] Re: Libre Office - 5.3.3

2017-06-01 Thread Joel Madero
On 6/1/2017 10:54 AM, charles meyer wrote: Thank you all for sharing your experiences with LO 5.3.3 Which LO version would you suggest I upgrade to from my 3.1? Is LO 5.2 a safer option with most bugs worked out? No - the bugs will never "mostly be worked out" - there are thousands of

Re: [libreoffice-users] LibreOffice Viewer Roadmap

2017-04-04 Thread Joel Madero
There are generally no "grand plans" in LibreOffice absent a few limited circumstances. People can do as they like. If someone with the skills decides to tackle this finds it interesting enough to do, they'll do it, else, it won't get done. That about sums it up. My guess is this will never

Re: [libreoffice-users] Missing file extension on saving

2016-12-01 Thread Joel Madero
iki.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 > -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to:

Re: [libreoffice-users] which docx format to recommend to MSO Word users?

2016-09-08 Thread Joel Madero
I always recommend older pre-OOXML formats (2003 Office formats, .doc, .xls, etc) because even Microsoft can't keep up with OOXML. On 9/8/2016 8:53 PM, Zenaan Harkness wrote: Have been trying to determine what to suggest as preferred/ default file save format for users stuck in MSO Word,

Re: [libreoffice-users] Libre Office

2016-08-22 Thread Joel Madero
I highly suggested getting L3 support to keep your organization up to date on stuff. Absent a contract agreement, there is /no guarantee/. Volunteers do things as they want. Generally security issues are tackled quickly but if you're looking for a group of volunteers to be your personal

Re: [libreoffice-users] About Libreoffice business services

2016-07-05 Thread Joel Madero
Hi, You'll want to contact one or more of our certified developers. https://www.documentfoundation.org/gethelp/developers/ The Document Foundation itself does not provide support for companies but those individuals and entities have been certified by TDF to do consulting work. Best, Joel

Re: [libreoffice-users] Calc suggestion

2016-06-26 Thread Joel Madero
Hi Kolbjørn, I just want to make sure expectations here are realistic (I believe I was one who commented on the bug). Our project works by the "doers deciding" - so even if 100 users say they'd like the feature, *at most* this would result in the enhancement going to NEW as a valid

Re: [libreoffice-users] Re: save button in Calc 5.1.3.2

2016-06-06 Thread Joel Madero
The file is writeable, control-S works fine. Try resetting your profile. https://wiki.documentfoundation.org/UserProfile Best, Joel --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- To unsubscribe e-mail to:

Re: [libreoffice-users] Question About Trojan Detection

2016-06-03 Thread Joel Madero
It'd be great if you inform McAfee about this - they consistently seem to have issues with over aggressive detections that mislead users. Best, Joel On 6/3/2016 12:27 AM, Jerry Greenberg wrote: I downloaded Libre Office on two computers. McAfee Scan picked up "RDN/Generic Downloader.x"

Re: [libreoffice-users] undo functionality

2016-06-01 Thread Joel Madero
On 6/1/2016 1:55 PM, B.S. wrote: B.S. schreef op 01-06-2016 22:41: Regards. By the way, no one has still not really tackled the question of whether there should be better undo. People are trying to avoid that subject. That is simply untrue. How about you read what I said. Report the

Re: [libreoffice-users] undo functionality

2016-06-01 Thread Joel Madero
am going to respond in public. Joel Madero schreef op 01-06-2016 18:13: I use LibreOffice daily for professional work - your subjective feelings are irrelevant in this outside of imposing a common sense "duty" (as a member of the open source world) to report whatever issues you have i

Re: [libreoffice-users] undo functionality

2016-06-01 Thread Joel Madero
Seriously people, this is the second time I have lost a great amount of work because the undo functionality of LibreOffice is about limited to one paragraph. The alternative to make backups every time you change something is just not workable. Are you just ranting? This isn't a question

Re: Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed

2016-05-21 Thread Joel Madero
use, > adds an asterisk * to the heading, if there has been any > unsaved change to the workfile. Easy to see at all times. > > Cheer, > Gordon. > > > > On 22/05/16 13:08, Joel Madero wrote: >> I strongly disagreed with this decision but it was made by UX and wa

Re: Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed

2016-05-21 Thread Joel Madero
I strongly disagreed with this decision but it was made by UX and was on purpose. I agree, the dimmed state was much easier to notice and the fact that you can now save even when there has been zero change is irritating to say the least. But, the doers decide, and they decided this one ;) Warm

Re: [libreoffice-users] Re: Dynamic Validation List

2016-02-19 Thread Joel Madero
Hi Miguel, > Hi Joel, > > find attached a sample file, I hope it is what you want. > To avoid duplicates in the list it`s needed to mark 'Sort entries ascending' > Be aware of Menu/Tools/Options/LibreOffice calc/General - Expand formatting, > if it is activated, when selecting in A1, then A1

[libreoffice-users] Dynamic Validation List

2016-02-18 Thread Joel Madero
Hi All, Based on: http://www.contextures.com/xlDataVal02.html#Dynamic I'm wondering if there is an easier way to do a dynamic validation list than that relatively complex method in that post pertaining to Excel. I swear I've done it before but for the life of me I can't remember how. Setup:

Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi Pedro, > > In my experience this is simply not possible. To have a linear graph the > X-values have to increase (in this case with year). You have 12 text values > on the X-axis. > You really have to convert this to a two column structure (BTW if you make > the first date value 1/15/2007 and

Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi Regina and Pedro, > > Technically it is possible, but it is cumbersome and instable. I would > not go that way, but generate a one-dimensional list from the data. > With such list, you can use a real time axis. That's what I figured - so I'll have to have a ghost list somewhere (probably

[libreoffice-users] Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi All, Please see this file: https://drive.google.com/file/d/0B2kdRhc960qdV2dTVUh5aWZIUWc/view?usp=sharing I'm hoping to create a linear graph from January of 2007 -> Current Month using this data. I can't think of a way to do this without putting the data in a different format (possible but

[libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi All, Please see this file: https://drive.google.com/file/d/0B2kdRhc960qdV2dTVUh5aWZIUWc/view?usp=sharing I'm hoping to create a linear graph from January of 2007 -> Current Month using this data. I can't think of a way to do this without putting the data in a different format (possible but

[libreoffice-users] Ruler Color - Color Change Needs Reviewed

2015-12-10 Thread Joel Madero
Hi All - Just sent an email but not sure if it went through so here it goes again. I'm addressing this bug https://bugs.documentfoundation.org/show_bug.cgi?id=90214, in summary, the ruler color scheme is unusable with dark themes. I've changed the color to a gray color instead of black but I

Re: [libreoffice-users] Re: LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?

2015-11-20 Thread Joel Madero
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 thi

Re: [libreoffice-users] Re: Large spreadsheet does not open in LibreOffice.

2015-11-16 Thread Joel Madero
56 Mb. I usually >> reduce the number of steps it can undo because 100 usually takes me to >> waaay before my last back-up. >> >> If the file really is Mb instead of just kb then is it due to having >> lots of images and art? >> Regards from >> Tom :)

Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

2015-11-13 Thread Joel Madero
g to be slow when you're talking about 150 megs. Open the file over night, save it as an open document format (ods) and I suspect it will be quite a bit faster. But, again, I bet that file needs to be a database and not a spreadsheet... Best, Joel -- *Joel Madero* LibreOffice QA Volunte

Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

2015-11-13 Thread Joel Madero
On 11/13/2015 08:23 PM, toki wrote: > On 13/11/2015 19:27, Joel Madero wrote: > >> I have never seen a 150 mb functional spreadsheet before. > That size is not uncommon in environments where Excel is the only office > tool that the employees know how to use. Trust me.

Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS

2015-11-11 Thread Joel Madero
lling > the new one in this Ubuntu? > > (b)when upgrading LibreO in Ubuntu does the help-pack upgrade > automatically together with the main program or must it be installed > separately? > > Please forgive me, I am trying to learn Ubuntu. > > Pertti Rönnberg > > > > On 11.

Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS

2015-11-10 Thread Joel Madero
that will be installed. On Tue, Nov 10, 2015 at 1:32 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: > Joel Madero, > Thank you for your reply. > But this is one of the confusing details: does your answer not lead to > install not > the version 5.02.3 but a later/the latest one? > Pertti >

Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS

2015-11-10 Thread Joel Madero
apt-get > > but then the error changed to: "E: Command line option 'r' [from > -repository] is not known." > > John > > > > > On 11/10/2015 01:17 PM, Joel Madero wrote: > >> Terminal - >> >> sudo add-apt-repository ppa:libreoffice/libre

Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS

2015-11-10 Thread Joel Madero
latest version in 5.0 so that's the version that > will be installed. > > On Tue, Nov 10, 2015 at 1:32 PM, Pertti Rönnberg <p...@elisanet.fi> wrote: > >> Joel Madero, >> Thank you for your reply. >> But this is one of the confusing details: does your answer not

Re: [libreoffice-users] How to upgrade LO on Ubuntu 14.04.LTS

2015-11-10 Thread Joel Madero
it on Ubuntu too. > But obviously it is not possible -- how come? > > By the way. Will the LO5.0x.x helppack install on Ubuntu together > (automatically) with the LO-upgrade or shall it be installed > separately? > Pertti > > > On 10.11.2015 23:39, Joel Madero wrote: &g

Re: [libreoffice-users] LEBRE VERSION STILL

2015-11-03 Thread Joel Madero
ibreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-

Re: [libreoffice-users] Announcing OpenOffice 4.1.2

2015-10-29 Thread Joel Madero
> -- > 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.o

Re: [libreoffice-users] Re: Announcing OpenOffice 4.1.2

2015-10-29 Thread Joel Madero
.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] Missing illustration captions in printout

2015-10-27 Thread Joel Madero
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.or

Re: [libreoffice-users] Re: Shortcut changes

2015-10-20 Thread Joel Madero
Office. There are really some great people over there - I highly recommend joining the list and getting involved :) They have weekly meetings - I believe on Friday - where they discuss a whole litany of UX related topics. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.

Re: [libreoffice-users] Windows Based Machine with High DPI Monitor?

2015-10-20 Thread Joel Madero
10/20/2015 12:54 PM, Joel Madero wrote: > >> Hi All, >> >> We have a stale UNCONFIRMED but that needs some attention but the hardware >> is a bit rare so QA team doesn't have anyone that can reproduce. >> >> Needed: Windows based machine with a high

Re: [libreoffice-users] Re: Shortcut changes

2015-10-20 Thread Joel Madero
contributors (from my experience over the years) and adds nothing to the fruitful and positive attitude in the project. Just my two cents. I know all of the people on the UX team and they are all fantastic people who are always open to bringing in new voices and incorporating lots of ideas moving f

[libreoffice-users] Windows Based Machine with High DPI Monitor?

2015-10-20 Thread Joel Madero
. You can either comment on the bug or just email me with your system specs and results. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Re: Shortcut changes

2015-10-20 Thread Joel Madero
/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.or

Re: [libreoffice-users] pptx files can't be opened when created with Impress 5.0.x

2015-10-20 Thread Joel Madero
programs/elements/apps/modules of the > >> suite > >> > within your presentation. Also it's what 'everyone' seems to be > using. > >> > > >> > Anyway good luck and regards from > >> > Tom :) > >> > > >> > >

Re: [libreoffice-users] Digital signatures

2015-10-15 Thread Joel Madero
Office I believe). I wouldn't be surprised if there is already a report in bugzilla about it. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Libre Writer - Line Spacing - not appearign as single space

2015-10-15 Thread Joel Madero
; >> > Charles. > > >> > > > >> > -- > > >> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > >> > Problems? > > >> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >

Re: [libreoffice-users] LO 5.0.2.2 ignores altered path for temporary files ?

2015-10-06 Thread Joel Madero
; 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 > delete

Re: [libreoffice-users] Liberation fonts vs Google croscore fonst

2015-10-06 Thread Joel Madero
> > > -- > 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/glo

Re: [libreoffice-users] libre offe general bug

2015-09-20 Thread Joel Madero
r...@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 li

Re: [libreoffice-users] LibreOffice Damaged

2015-09-11 Thread Joel Madero
; 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 > -- *Joel Madero* LibreOffice QA Volunteer jmadero@gm

Re: [libreoffice-users] Re: Need help To convert Excel Sheet to Libre sheet

2015-09-11 Thread Joel Madero
Indeed the certified migrators are a good place to start to poke people. You can also contact CIB who may be able to help. https://libreoffice.cib.de/ Best, Joel On 09/11/2015 06:00 AM, Andreas Säger wrote: > Am 10.09.2015 um 08:24 schrieb Gabriele Ponzo: >> What's your problem specifically? >>

Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

2015-09-10 Thread Joel Madero
*Mobile*: +91 >>>>> 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|* >>>>> >>>>> -- >>>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>>>> Problems? >>>>> http://www.libreof

Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

2015-09-10 Thread Joel Madero
Services Limited**|***|**No.34/1 Andree Road, Shantinagar, > Bangalore - 560027*|***|***www.janalakshmi.com**|* > *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 > 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|* > On 11-09-2015 04:20, Joel Madero wrote: &g

Re: [libreoffice-users] v2.0 Images copied to Libre Office Writer from Shutter look so pixelated

2015-07-31 Thread Joel Madero
://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Question about LO Writer and complex documents

2015-07-24 Thread Joel Madero
. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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

Re: [libreoffice-users] No Win x64 builds?

2015-07-23 Thread Joel Madero
://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get

Re: [libreoffice-users] [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Joel Madero
, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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

Re: [libreoffice-users] Re: Europass docs

2015-07-15 Thread Joel Madero
:) Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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

Re: [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Joel Madero
Funny enough if you remove Monday from the entry and just put Aug 1 and then Aug 2, things work ;) On Wed, Jul 15, 2015 at 2:06 PM, Joel Madero jmadero@gmail.com wrote: Ah yes I do see that (Excel has same behavior). I would have quoted smart instead of that ;) But I think that detecting

Re: [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Joel Madero
/users/ All messages sent to this list will be publicly archived and cannot be deleted -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Joel Madero
/ 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 -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com

Re: [libreoffice-users] Open LO files via IE Explorer

2015-07-14 Thread Joel Madero
it if you look at bugs.documentfoundation.org. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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

Re: [libreoffice-users] Error message

2015-07-13 Thread Joel Madero
be deleted -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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

Re: [libreoffice-users] Error message

2015-07-13 Thread Joel Madero
the problem is that since windows 8 is 64 bit, Mark installed a 64 bit JRE. LibreOffice is 32 bit and needs a 32 bit JRE. If this is the case, Mark, install the 32 bit JRE for windows. This should solve the problem. Dan Original message From: Joel Madero jmadero@gmail.com

Re: [libreoffice-users] CTL Bug Report Posted (for those using CTL of course)

2015-07-09 Thread Joel Madero
patiently for a company or someone else to fund it; In this particular case what *might* work is to look around the web for grants that users can apply for on behalf of LibreOfficethis is just a possibility that came to mind...no clue if such grants exist. Best, Joel -- *Joel Madero

Re: [libreoffice-users] VAR, STDEV, CHISQ.INV

2015-07-08 Thread Joel Madero
: 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 -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users

Re: [libreoffice-users] Re: LibreOffice's documentation (pdf and online)

2015-06-24 Thread Joel Madero
and cannot be deleted -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.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

Re: [libreoffice-users]

2015-05-11 Thread Joel Madero
On 05/11/2015 04:33 AM, Tom Davies wrote: Hi :) Thanks for letting us know. I guess you have already looked for an Extension (like and add-on or plug-in) to do this, because you always tend to go that extra mile. It seems odd that no company has done this already and then released the code

Re: [libreoffice-users]

2015-05-10 Thread Joel Madero
sent to this list will be publicly archived and cannot be deleted -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Re: macro - find record based on text entry

2015-05-01 Thread Joel Madero
Hi Alex, Le 30/04/2015 22:09, Joel Madero a écrit : Hi Joel, I have a form with a simple text document, what I'm hoping to do is take Is the text in question free-standing, as in, in a paragraph outside of a form control, or is it the value of a form control ? Currently I just have a form

[libreoffice-users] macro - find record based on text entry

2015-04-30 Thread Joel Madero
Hi All, I have a form with a simple text document, what I'm hoping to do is take the text to open another form and for it to automatically be at the record that matches the text. If the value does not exist, I want the entry to be added to the related table. Help appreciated. Best, Joel -- To

Re: [libreoffice-users] Re: converting txt to dates

2015-04-21 Thread Joel Madero
/dates aren't showing up right. Cor - your thoughts since you developed the extension? Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Re: Macro to open form + pass on value from current form

2014-12-17 Thread Joel Madero
On 12/17/2014 08:52 AM, Alexander Thurgood wrote: My own take on this, as I had something similar setup a long time ago, was to have a button that activated a macro which : - checked whether a value existed in another table via a parameterized query, Do you have an example of how to do

[libreoffice-users] Select Concat in Form Dropdown?

2014-12-16 Thread Joel Madero
Hi All, I have a form based on a table with FirstName and LastName, I want the form to have a dropdown with SELECT CONCAT(FirstName,,,LastName) Is there a way to do this? Thanks! Best, Joel -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Select Concat in Form Dropdown?

2014-12-16 Thread Joel Madero
)) Does this help (Oracle SQL Syntax) Liebe Grüße / Yours, Florian Reisinger Am 16.12.2014 um 21:43 schrieb Joel Madero jmadero@gmail.com: Hi All, I have a form based on a table with FirstName and LastName, I want the form to have a dropdown with SELECT CONCAT(FirstName,,,LastName

[libreoffice-users] Macro to open form + pass on value from current form

2014-12-16 Thread Joel Madero
the bookID to that form so I can enter the appropriate info. Guidance appreciated. Best, Joel -- Joel Madero, Member of the Board of Directors GPG Key ID: 0x8FFB1B14 - EE32 6D0F 81FF 6FAC 5AD8 10E4 0141 27C6 8FFB 1B14 The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige

Re: [libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Joel Madero
Hi All, Well, you set the string of a cell. Set the formula instead. So I just started from scratch because I had a ton of if statements before, decided to go to switch to make it faster but I'm hitting the same type of problem. Document:

Re: [libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Joel Madero
what you mean by what you said - worst case I'll just give up the macro and stick with the limited abilities of kmymoney to do graphs and what not. Joel On 12/10/2014 12:33 PM, Andreas Säger wrote: Am 10.12.2014 um 18:23 schrieb Joel Madero: I literally have no clue where those are coming from

Re: [libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Joel Madero
On 12/10/2014 01:54 PM, Andreas Säger wrote: Am 10.12.2014 um 21:43 schrieb Joel Madero: I'll try to figure out what you mean by what you said - worst case I'll just give up the macro and stick with the limited abilities of kmymoney to do graphs and what not. At least we know know waht you

Re: [libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Joel Madero
at examples). Warmest Regards, Joel On 12/10/2014 12:23 PM, Joel Madero wrote: Hi All, Well, you set the string of a cell. Set the formula instead. So I just started from scratch because I had a ton of if statements before, decided to go to switch to make it faster but I'm hitting the same

[libreoffice-users] macro pasting text instead of formula

2014-12-09 Thread Joel Madero
Hi There, I have a macro that used to work and now it's not any more, trying to diagnose what's going on. Code snipit: 'takes text value from QIF entries and pastes them into column I, values are pasted as text if (dateOption = DD/MM/) then pasteValue

Re: [libreoffice-users] Re: How to handle regressions

2014-10-03 Thread Joel Madero
that I do build. They write it - they should own it. I simply don't understand how anyone could believe otherwise. On 10/2/2014 5:57 PM, Joel Madero jmadero@gmail.com wrote: Um - well two points: 1. None of the paid developers are paid by TDF - we have 0 paid developers on staff. 2. Most

Re: [libreoffice-users] Re: How to handle regressions

2014-10-03 Thread Joel Madero
I have no clue how my comment was rude, it's pretty standard in open source world to say that patches welcome or some variation. I'm unsubscribing though as I don't have the time nor energy to continue this and you seem to have more than enough of both to go around. Enjoy ranting on the thread.

Re: [libreoffice-users] Re: How to handle regressions

2014-10-02 Thread Joel Madero
Um - well two points: 1. None of the paid developers are paid by TDF - we have 0 paid developers on staff. 2. Most commits are still done by volunteers and many are done by paid developers on their free time (ie. when they are volunteering). On 10/02/2014 12:53 PM, Tanstaafl wrote: On

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
when you start typing. Best, Joel On 09/09/2014 01:21 PM, Kevin O'Brien wrote: Well, styles are over-ridden by manual formatting, for one. So if a Style specifies a bold font, but you click a button to turn it off, it should go off. Regards, On Tue, Sep 9, 2014 at 4:17 PM, Joel Madero

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
upload another one with the line not bolded ;) Best, Joel On 09/10/2014 08:08 AM, Tom Davies wrote: Hi :) It is bold but Header 3 makes things grey in the Font Effects tab so it just doesn't look as bold as usual. Regards from Tom :) On 10 September 2014 16:01, Joel Madero jmadero

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
On 09/10/2014 08:21 AM, Sophie wrote: Hi Joel, Le 10/09/2014 17:01, Joel Madero a écrit : https://drive.google.com/file/d/0B2kdRhc960qdMlFhVzAtTllETEU/edit?usp=sharing There is one example file. Go to the very end, push enter a couple times, and then set the style to Heading 3. If you look

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
Don't be in too much of a rush to post a bug Joel. Wherever I type on a blank line in your example file and set Heading 3 (either before or after typing) I get 14pt Bold Liberation Sans text in a User Defined colour. Which in my assessment is the correct behaviour. Setting existing manually

Re: [libreoffice-users] Re: Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
On 09/10/2014 09:36 AM, Alex Thurgood wrote: Le 10/09/2014 17:56, Dave Barton a écrit : Hi Dave, Setting existing manually formatted text to Heading 3 is an issue, if the formatting is not completely cleared first. Shouldn't applying the style overwrite all previous style information

Re: [libreoffice-users] Re: Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
Bug report: https://bugs.freedesktop.org/show_bug.cgi?id=83726 Best, Joel On 09/10/2014 10:10 AM, Brian Barker wrote: At 18:36 10/09/2014 +0200, Alex Thurgood wrote: Shouldn't applying the style overwrite all previous style information though ? This depends on what you mean. Applying one

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
Hm - in bibisect package I can't confirm that, I went all the way back to 3.5beta0 :-/ Can you add your findings to the bug? Best, Joel On 09/10/2014 11:25 AM, Steve Edmonds wrote: Stays bold in Version 3.6:build-304 so a regression. steve On 2014-09-11 03:01, Joel Madero wrote: https

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-10 Thread Joel Madero
On 09/10/2014 03:06 PM, jomali wrote: I downloaded the file and examined the parameters of the Level 3 style in the document and found that, under Font Effects, Gray is checked. Could this be the source of the difficulty? No because the issue is that it's inconsistent, not that it's

[libreoffice-users] Styles Don't Retain Bold?

2014-09-09 Thread Joel Madero
Hi All, Quick question. Are styles supposed to retain properties like bold. I am consistently getting mixed results using styles. I can provide an example if need be. Best, Joel -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Dependency Issues

2014-08-19 Thread Joel Madero
On 08/19/2014 04:24 PM, Paul wrote: Hi Joel, Uh, I'd really need to be sitting at the keyboard to get a real handle on this, but looking at your second image, have you tried apt-get -f install as it suggests? This was the first pastebin - results in errors :-/ Or maybe try removing

Re: [libreoffice-users] Dependency Issues

2014-08-19 Thread Joel Madero
, etc so it's not super easy and I just started second year of law school so time is stretched real thin ;) Best, Joel On 20 August 2014 00:30, Joel Madero jmadero@gmail.com mailto:jmadero@gmail.com wrote: On 08/19/2014 04:24 PM, Paul wrote: Hi Joel, Uh

Re: [libreoffice-users] Dependency Issues

2014-08-19 Thread Joel Madero
Joel Madero jmadero@gmail.com wrote: On 08/19/2014 04:24 PM, Paul wrote: Hi Joel, Uh, I'd really need to be sitting at the keyboard to get a real handle on this, but looking at your second image, have you tried apt-get -f install as it suggests? This was the first pastebin - results in errors

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
So - I've started with the previous suggestions and am hesitant to change now (put in about 5 hours over the past couple days to learn by doing). Attached is what I have so far. It's pretty basic but just two tables (as you can see) and a form which I made to my likings. Suggestions

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
status see below Authors Name Series Name of series like Dragons of Pern or Harry Potter Read status started finished wanted Linking should be by query. On Aug 8, 2014, at 10:29 AM, Joel Madero jmadero@gmail.com wrote: Just wanted to bump this to see

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
much more easily than with a spreadsheet ;o) Mark. Joel Madero wrote: Hi All, So I went back to planning stage. Link to what I think might work - hoping to get the planning stage done today so I can start actually putting together the db - I have 3 days off so now's a good

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
. Add: AND `bi`.`ReadStatus` = Read to the ON condition and you can get the number of read books by each author. That's the kind of thing a database enables you to do much more easily than with a spreadsheet ;o) Mark. Joel Madero wrote: Hi All, So I went back to planning stage. Link to what I

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
and you can get the number of read books by each author. That's the kind of thing a database enables you to do much more easily than with a spreadsheet ;o) Mark. Joel Madero wrote: Hi All, So I went back to planning stage. Link to what I think might work - hoping to get the planning stage done

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
I'm not horribly worried about name changes ;) Best, Joel On 08/10/2014 07:21 PM, jonathon wrote: On 8/10/2014 6:48 PM, Joel Madero wrote: I decided to do the smart thing and diagram it out Potential issues with the author field: Book One: Author A Author B; Book Two: Author B Author

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-10 Thread Joel Madero
Hey Jonathan, responded in line but the gist is - this is a hobby and I'm not going to spend hours and hours thinking about corner cases/etc... if a book has multiple authors, I'll pick one, if it belongs to multiple series, I'll pick one, if it's a spin off to a main series, I'll just track

Re: [libreoffice-users] What version?

2014-08-08 Thread Joel Madero
is super important - I'd say equally important is convincing our neighbors that there are alternatives that are indeed transparent, functional, and easy to use (odf of course). Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr

  1   2   3   4   >