[libreoffice-users] Calc - detect landing on a particular cell.
I want to trigger an event when a particular cell becomes the active cell. Here's the situation: After entering a payment in a specific cell (say $10 in A5) and hitting enter, I'd like to programatically put the current time as hidden "userdata" in the cell immediately below it (A6) - the new active cell. I'd like to detect leaving that cell (A6) or entering the cell below (A7) without modifying the visible contents of A6 or A7. I want to use the elapsed time between the enter keystrokes to change the way the sheet reacts. $10 (enter) (immediate enter) Signals that the transaction is over and a macro sets up for the next transaction. $10 (enter) (wait a second) (enter) Signals the transaction isn't over and just sits there. The time difference between the double enter keystrokes determines what happens next. This spreadsheet has 6600 lines of macro code that makes it function, and I'm already relying heavily on event handling, but it only works on a modified cell. In this case, I'm not modifying A6 or A7, but I want to trigger an event that lets me know they have become the active cells. -- Bill Gradwohl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Where to post improvement suggestions?
Brian Barker wrote: At 21:12 01/12/2015 +, Mark Bourne wrote: Perhaps I'm missing something too, but I think I can see where Steve's coming from. For example: - The table is a fixed width or filling the whole page width (and that's how you want it; selecting "adapt table width" is not desirable) This is your mistake: denying the very technique which will help you. It's a bit like my saying that I like eating Christmas pudding, but I don't want to put it in my mouth. Er, but that's how eating works. But if I want the table to have a fixed width, why should I change it to variable width (even temporarily) every time I want to take a bit off one column width and add it to another which isn't adjacent to it? It's a workable workaround, but not exactly intuitive, nor expressing what I want to achieve (keeping a constant table width). - Column widths are 1.0", 0.5", 3.0", 3.0", 0.5", 0.5". - You want to add 2" to column 1 (make it 3.0") and deduct 2" from column 4 (make it 1.0") To do this, you have to: - Set column 1 to 3" (column 2 becomes 0.02", column 3 becomes 0.02", column 4 becomes 1.97" - didn't want to change columns 2 and 3) - Set column 2 back to 0.5"; column 4 becomes 1.48" - Set column 3 back to 0.5"; column 4 becomes 1.0" (finally what was wanted) No, you don't *have* to do this. It would be much easier to: - Set column 1 to 3"; no other widths change (columns don't add up to the total width, but that's OK because we're about to fix that) *You* know that you are going to make further compensating changes but LibreOffice doesn't. If you are espousing such a change to LibreOffice, you need to explain, please, exactly what happens if users click OK at this point. To be honest, I'm not entirely sure what the best way around it is. Of course, it would need to disallow OKing the dialog at this point, perhaps with a message saying the column widths don't add up to the required total (though I'd agree that isn't particularly elegant), or perhaps by disabling the OK button and showing a message within the dialog itself. A display within the dialog showing the mismatch between required table width and current column widths would also be useful, similar to the existing "remaining space" field (which shows how much space is left to expand the table width when allowing that to change). For what it's worth, I don't recall MS Word being any easier. From what I recall, it allows you to enter column widths which don't add up to the total table width, but does something like scaling proportionately when displaying the table to make it required width. Surely, if "columns don't add up to the total width", you can allow LibreOffice to know this - by allowing it to adapt the table width, albeit temporarily. - Set column 4 to 1" Try this: o On the Table tab of the Table Format dialogue, change Alignment from Automatic to something else - perhaps Left. o On the Columns tab, tick "Adapt table width". o Enter "1" for column 4. (As you acknowledged in a later message, it's helpful to do the reduction first, before the increase.) o Enter "3" for column 1. o Untick "Adapt table width". o On the Table tab, change Alignment back to Automatic. o OK. So you have to either fiddle about with column widths automatically changing, or change two options which you don't actually want to change and then change them back again after adjusting column widths. I can see why someone might describe either option as "quite cumbersome", when all they want to do is change two column widths. -- 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: font replacement rules
... be aware that font/glyph replacement rules are different in Linux/Unix than they are in Windows. I don't use Macs so can't comment on that OS. Take a look at: https://wiki.documentfoundation.org/LibreOffice_Localization_Guide/Advanced_Source_Code_Modifications. e.g.: "Under unix, where fontconfig is used for font fallback, then if the first entry in the list is not available, fontconfig is consulted for the best replacement font to use based off that fontname and the desired locale. Under other platforms LibreOffice loops through the list until one is found." Also under the "Font Fallback" and "Glyph Fallback", the same thing is stated, although both sections are marked as "This section needs updating!" It is also clear that LibreOffice has quite a few easily reproducible bugs relating to font replacement. If, for instance, you are using a particular font that contains glyphs for multiple different writing systems (e.g. one that uses non-Latin Unicode characters) to type two languages in the same document (e.g. English and Hebrew or French and Thai), Writer will sometimes happily substitute a completely different font for the "foreign" characters instead of using your chosen font for both languages. This CAN BE mitigated somewhat by using the CTL (Complex Text Layout) settings, but that is spotty and inconsistent at best. To be fair, this behavior has been around since the birth of the code in Star Office days. I guess my point is that even having a wide variety of fonts doesn't necessarily guarantee a good layout. You need to experiment to figure out what works best with the particular documents you tend to work with - there will always be some quirks. -- View this message in context: http://nabble.documentfoundation.org/font-replacement-rules-tp4167959p4168120.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] font replacement rules
On 01/12/2015 18:29, Milos Sramek wrote: > Don't you happen to know if LO uses any rules according to which the > replacement font is chosen? Or the choice is random (unless I set the > replacement manually)? There is a specific sequence of rules used for determining which glyph from which font is substituted for "missing" glyphs. However, that sequence, and order of precedence depends upon the users _specific_ configuration. jonathon -- 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] Cannot run Libre Office on the new Microsoft Surface Computers
Having problems running Libre Office on both the new Surface Pro 4 and on the new Surface Book. After installing the application and clicking on the application, all I get is a black window for the any application in Libre Office. This does not happen on the older Surface computers. Only the new ones. I have tried deleting and re-installing the program without any success. Also tried installing in compability mode without any luck. Contacted Microsoft and they stated that they think that the error is in the way Libre Office is handling OpenGL. Sorry to state that answer was greek to this new user. Any one have any ideas on how I can solve this problem? -- View this message in context: http://nabble.documentfoundation.org/Cannot-run-Libre-Office-on-the-new-Microsoft-Surface-Computers-tp4168136.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: Where to post improvement suggestions?
Ok, Table -> autofit -> distribute evenly works like a charm. But that still leaves adjusting width of whole table a cumbersome task. It seems that getting the width of one cell right, then calculating the width of table from column count is the only way. What if font size needs adjusting later? Too bad, adjustments are not "user-friendly" to make. Sorry, too much text to read all the posts. Thanks for replies. -- View this message in context: http://nabble.documentfoundation.org/Where-to-post-improvement-suggestions-tp4167920p4168060.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