[libreoffice-users] Re: LO Base Problem
Le 19/02/2015 15:00, Ian Whitfield a écrit : Hi Ian, But when I go back into my Database with the Base Front End the RecordID is still marked as 'No Auto-Increment' and still will not change!! What am I doing wrong and how do I urgently fix this?? Did you read Fernand's comment ? You need to look very carefully through your form's properties and controls to check where and if the form controls might have referenced the old field as this is stored in the ODB xml. I would add the following questions : - your old RecordID was just an INT that you filled in yourself - so now that you have converted it to INT AUTO_INCREMENT, did you regenerate the values, or have you just carried on from the previous lastinsert_id() of the RecordID field ? If the new values of your newly redefined field do not match the values you had originally, there will naturally be problems with form data representation... Ways around this : - reindex your table using the appropriate mysql command ; - run mysqlcheck from the command line I don't use phpMyAdmin a great deal, so I don't know whether you have access to these commands from that UI - if not, you will have to get your hands dirty and use the console/terminal, which is what most db admins do anyway. If your data _is_ coherent, then the problem lies with your form and/or LO. Alex -- 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: LO Base Problem
Le 19/02/2015 15:00, Ian Whitfield a écrit : A quick, alternative possibility : Create a new ODB file that connects to your database. Save it under a new name. Open the newly named (and currently empty, at least with regard to forms, queries, etc) ODB file. Open the old ODB file. Try dragging and dropping your form from the old ODB file to the Forms window of the new ODB file. Now try opening that form in the new ODB file. Alex -- 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: Solver bug
Hi all, Because the NLP Solver is already an extension project within LibreOffice, there was a new nlpsolver.oxt file produced after I made the simple changes. I would post the oxt as an attachment, but I could not get the new one to install because I couldn't get the 'built-in' version uninstalled. Seems it is nailed in there pretty well and can't be swapped out without other [C++, rsc] patches that definitely won't be delivered before the next release date. So... setting the NLP Solver's Objective cell (so it has a goal to work on) is available in daily builds of the development master. It should also work well if you patch your own LibreOffice build, but that takes a 'little' bit of space and time to set up (15 to 25GB and lng first build). Echoing the links above... Daily Build http://dev-builds.libreoffice.org/daily/master/ should work. Noting -- If you don't want to disrupt your tuned up copy of LO, you should install in parallel. Instructions linked from here by OS. -- https://wiki.documentfoundation.org/Installing_in_parallel If you do test the NLP solver please note your success or failure here or on Bug#87074 . Thanks! -- View this message in context: http://nabble.documentfoundation.org/Solver-bug-tp4134802p4140779.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] Re: LO Base Problem
Hi Alex
I really appreciate your help here!!
But still no luck - My replies are below.
A quick, alternative possibility :
Create a new ODB file that connects to your database. Save it under a
new name.
Open the newly named (and currently empty, at least with regard to
forms, queries, etc) ODB file.
I tried this and the ID field comes through as 'No increment' and still
will NOT change!!
Did you read Fernand's comment ?
Yes - There is only ONE field on my Form that calls this field. The one
I'm trying to change.
your old RecordID was just an INT that you filled in yourself -
No - it was empty, like all my fields), and I imported my old data from
a CSV file and then started to work. That,s when I discovered I had not
set it to Auto Increment.
so now that you have converted it to INT AUTO_INCREMENT, did you regenerate the
values, or have you just carried on from the previous lastinsert_id() of
the RecordID field ?
I can not change it so have not regenerate it.
All I can do at the moment is enter the next number by hand.
Ways around this :
- reindex your table using the appropriate mysql command ;
- run mysqlcheck from the command line
I'm NOT a DB Admin at all I just need this DB to keep all the details of my
Group. The DB is just a very important tool to me!!
I tried to run the 'mysqlcheck' command and I don't know what the output is but
this is what I got ...
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
- -
all-databases FALSE
all-in-1 FALSE
auto-repair FALSE
character-sets-dir(No default value)
compress FALSE
databases FALSE
debug-check FALSE
debug-infoFALSE
default-character-set (No default value)
fast FALSE
fix-db-names FALSE
fix-table-names FALSE
force FALSE
extended FALSE
host (No default value)
write-binlog TRUE
port 0
quick FALSE
silentFALSE
socket(No default value)
ssl FALSE
ssl-ca(No default value)
ssl-capath(No default value)
ssl-cert (No default value)
ssl-cipher(No default value)
ssl-key (No default value)
ssl-verify-server-certFALSE
use-frm FALSE
user (No default value)
Thanks again
IanW
Pretoria RSA
--
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: LO Base Problem
Le 20/02/2015 15:00, Ian Whitfield a écrit : I tried to run the 'mysqlcheck' command and I don't know what the output is but this is what I got ... That is the output of the built-in help, which gets displayed when you run mysqlcheck without any parameters. Try : mysqlcheck -A -p the '-p' is only necessary if you need a password to access your database server. Preferably, you should run the above as superuser : sudo mysqlcheck -A -p The tables of all databases to which you have access rights, will be analyzed. Any errors in table data consistency will be displayed next to the given table. If you are using mysql, you really should learn the command line tools to administer your mysql server and databases. If you have no access to UI tools for whatever reason, it can save your bacon on more than one occasion. Alex -- 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: LO Base Problem
On 02/20/2015 04:47 PM, Alexander Thurgood wrote: Try mysqlcheck -A -p Thanks for the explanation Alex. This is what I get . FedSaints.Members OK mysql.columns_priv OK mysql.db OK mysql.eventOK mysql.func OK mysql.general_log Error: You can't use locks with log tables. status : OK mysql.help_categoryOK mysql.help_keyword OK mysql.help_relationOK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log Error: You can't use locks with log tables. status : OK mysql.tables_priv OK mysql.time_zoneOK mysql.time_zone_leap_secondOK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_typeOK mysql.user OK IanW Pretoria RSA -- 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: Formatting a date
P.S. to the special case where you imported normal dates in US context ending up with a column of wrong dates and text. Assuming that you don't have the original data at hand so you can not repeat the data import with appropriate import options, this is how to correct wrong values: 1) Switch the locale option under ToolsOptionsLanguageSettingsLanguages from English(USA) to English(UK). Now the wrong date 1/2/14 switches to 2/1/14 in UK context but it is still the same wrong date (2nd of February). The text values like 13/1/2014 remain the same text values but now they show a leading apostrophe in order to mark them as literal text and prevent numeric evaluation. In UK context 13/2/14 would be a correct date but the actual cell values remain stable when playing with language options and formattings. This is an important feature. It is not a bug by any means. 2) Apply the following formula to the entire date column (assuming dates starting in A1): =IF(ISNUMBER(A1);DATE(YEAR(A1);DAY(A1);MONTH(A1));VALUE(A1)) The formula returns the corrected date if A1 has a wrong date and converts the text in A1 to a number if the A1 has a text value. The conversion from text to number happens in the globally set UK context set in step 1). Don't panic if the converted text values are shown as integer numbers. These integer numbers are the correct values. Copy the formula column, select the source column (A in this example) and paste-special values only (no formulas). Reset the locale back to US. Now the correct dates switch from 13/1/2014 to 1/13/2014 but they are still the same correct dates. Format the cells to your liking. Notice that the number format dialog lets you override the locale option for the selected cell. This has no influence on the actual cell values which are the right ones after this conversion. -- View this message in context: http://nabble.documentfoundation.org/Formatting-a-date-tp4140660p4140849.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: Styles and Formatting Not Working
Dear Tom, Thank you very much for your advice. I will install the former version. Taang Zomi On Fri, Feb 20, 2015 at 8:33 PM, Tom Davies tomc...@gmail.com wrote: Hi :) I think best advice is to reinstall the 4.3.x to get back to familiar territory! Err, a new version has just been released in that branch so if you don't have your old installer then maybe download the newest release in the Still branch. It is possible to install it in parallel with your current version of LibreOfrfice but personally i would probably go for a normal proper install. Regards from Tom :) On 21 February 2015 at 01:29, Taang Zomi libreofficez...@gmail.com wrote: Many, many years ago, I read somewhere that when a misfortune comes, it does not come alone; it is accompanied by its companions or to that effect. Today, I had another problem. It could be called the #4 problem. The Styles and Formatting (F11) under Format did not work. As I am writing a book, and the deadline for submission of the manuscript is the end of February, you can imagine how much I am frustrated. I used LibreOffice 4.3.5.2; Since February 19, 2015, I have used LibreOffce 4.4.0.3. Taang Zomi -- 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: Styles and Formatting Not Working
Hi :) I think best advice is to reinstall the 4.3.x to get back to familiar territory! Err, a new version has just been released in that branch so if you don't have your old installer then maybe download the newest release in the Still branch. It is possible to install it in parallel with your current version of LibreOfrfice but personally i would probably go for a normal proper install. Regards from Tom :) On 21 February 2015 at 01:29, Taang Zomi libreofficez...@gmail.com wrote: Many, many years ago, I read somewhere that when a misfortune comes, it does not come alone; it is accompanied by its companions or to that effect. Today, I had another problem. It could be called the #4 problem. The Styles and Formatting (F11) under Format did not work. As I am writing a book, and the deadline for submission of the manuscript is the end of February, you can imagine how much I am frustrated. I used LibreOffice 4.3.5.2; Since February 19, 2015, I have used LibreOffce 4.4.0.3. Taang Zomi -- 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] Styles and Formatting Not Working
At 20:29 20/02/2015 -0500, Taang Zomi wrote: The Styles and Formatting (F11) under Format did not work. Er, do you mean that the Styles and Formatting window does not appear? Or does it appear but then not function in some sense? Can you successfully select the type of style using the buttons at the top of the Styles and Formatting window? o What happens if you go to Format | Styles and Formatting? o Or press F11? o Or click the Styles and Formatting button in the Formatting toolbar? o Or press Alt+O, Y? o Or click the Styles and Formatting button in the LibreOffice sidebar? Have you restarted LibreOffice? Have you restarted your computer? Have you merely lost the window off the screen? Are you using Windows? o When you press F11 (or whatever), does the LibreOffice title bar become dimmed - indicating that another window (the one you have lost) has taken focus? o With the main title bar still dimmed, press Alt+Space and then M. o Press any of the keyboard arrow keys once. o Now move the mouse until the outline of the missing window is somewhere central. o Click the mouse. At 20:35 20/02/2015 -0500, Taang Zomi wrote: I will install the former version. Isn't it a bit unlikely to be a bug in the later version? Wouldn't millions of users then be asking the same question? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Styles and Formatting Not Working
Many, many years ago, I read somewhere that when a misfortune comes, it does not come alone; it is accompanied by its companions or to that effect. Today, I had another problem. It could be called the #4 problem. The Styles and Formatting (F11) under Format did not work. As I am writing a book, and the deadline for submission of the manuscript is the end of February, you can imagine how much I am frustrated. I used LibreOffice 4.3.5.2; Since February 19, 2015, I have used LibreOffce 4.4.0.3. Taang Zomi -- 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: Styles and Formatting Not Working
Hi :) Thanks :) It is worth keeping the installer for the newer branch for later on, after the deadline! Also because it is quite handy to have 2 different versions to choose from. Regards from Tom :) On 21 February 2015 at 01:35, Taang Zomi libreofficez...@gmail.com wrote: Dear Tom, Thank you very much for your advice. I will install the former version. Taang Zomi On Fri, Feb 20, 2015 at 8:33 PM, Tom Davies tomc...@gmail.com wrote: Hi :) I think best advice is to reinstall the 4.3.x to get back to familiar territory! Err, a new version has just been released in that branch so if you don't have your old installer then maybe download the newest release in the Still branch. It is possible to install it in parallel with your current version of LibreOfrfice but personally i would probably go for a normal proper install. Regards from Tom :) On 21 February 2015 at 01:29, Taang Zomi libreofficez...@gmail.com wrote: Many, many years ago, I read somewhere that when a misfortune comes, it does not come alone; it is accompanied by its companions or to that effect. Today, I had another problem. It could be called the #4 problem. The Styles and Formatting (F11) under Format did not work. As I am writing a book, and the deadline for submission of the manuscript is the end of February, you can imagine how much I am frustrated. I used LibreOffice 4.3.5.2; Since February 19, 2015, I have used LibreOffce 4.4.0.3. Taang Zomi -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice 4.4 and 4.3 crashes
Hallo everybody, I just subscribed the mailing list and I have a problem. I'm trying to develop a simple Python script that interact with Calc, but LibreOffice crashes. To replicate the event, just run it as a service with the following command (Win7): c:\Program Files (x86)\LibreOffice 4\program\soffice.exe --norestore --calc -accept=socket,host=localhost,port=2002;urp;StarOffice.ServiceManager --nologo I replicated the beheviour on two different computers running Windows7 64bit and LO 4.3 and LO4.4. Calc starts and a new document appears on the screen. You can move and resize the window, select cells and columns, BUT as you type something in a cell, the program crashes. I tested the same command on another computer, running WindowsXP and LibreOffice 4.1 and everything works perfectly. Can someone find a solution? Thanks for help. Giacomo P.S. I think the bug is the same described in http://nabble.documentfoundation.org/LibreOffice-4-4-crash-when-using-pyuno-Windows7-tt4139609.html but is not related to pyuno. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice 4.4 and 4.3 crashes
Hallo everybody, I just subscribed the mailing list and I have a problem. I'm trying to develop a simple Python script that interact with Calc, but Calc crashes. LibreOffice just crashes if you run it as a service with the following command: c:\Program Files (x86)\LibreOffice 4\program\soffice.exe --norestore --calc -accept=socket,host=localhost,port=2002;urp;StarOffice.ServiceManager --nologo It happens on two different computers running Windows7 64bit and LO 4.3 and LO4.4. Calc starts and a new document appears on the screen. You can move and resize the window, select cells and columns, BUT as you type something in a cell, the program crashes. I tested the same command on another computer, running WindowsXP and LibreOffice 4.1 and everything works perfectly. Can someone find a solution? Thanks for help. P.S. I think the bug is the same described in http://nabble.documentfoundation.org/LibreOffice-4-4-crash-when-using-pyuno-Windows7-tt4139609.html but is not related to pyuno. -- 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: Formatting a date
1. Do not type dates into cells that are formatted as text and do not type dates with a leading apostrophe 2. Do not import dates as text values from csv or html files. 3. When you paste content from another program, then do not hit Ctrl+V. Use the paste-special command, import raw text data and import the date column as dates With the right method of input/import/paste your dates will sort properly and you can calculate all kinds of time intervals, time differences, aggregate by months, years, weeks etc. Import options for numeric text data when using paste-special or when opening text tables (csv): 1) The special numbers option should _always_ be checked. Special numbers are dates, times, booleans, numbers with currency symbols, any kind of number with more than minus sign, digits and a decimal separator. ALWAYS check this option. 2) quoted numbers as text: Some text files there are quotes around numbers (e.g. zip or phone numbers) in order to mark them as text. WIth this option checked, quoted values are always imported as text. Now for the most important option in the whole dialog: 3) Language. Choose English(USA) if 1/2/2015 should be interpreted as 2nd of January and decimals have a point (3.14) Choose English(UK) if 1/2/2015 should be interpreted as 1st of February. 1.2.2015 looks like a typical German date together with decimals like this: 3,14 (comma decimal). If the file has currency values like ￥3.14 you would choose Japanese. If the file has currency values like 3,14 RUR you would choose Russian import language. 4) the preview table on the bottom of the import dialog lets you select columns and mark them as DMY dates, MDY dates,YMD dates, US English or Text. This overrides all the other options for the selected columns. When you have special numbers checked and disregard any quotes around numbers and now there is a field that looks like 3-4 (meaning 3 to 4 but software can not know what it means) then you should mark this column as text. Otherwise it may be interpreted as special number 4th of March with US language or 3rd of April with any other language. If you have entered/imported/pasted wrong data (numeric text): Formatting will not (and must not) change any data. You need to re-enter all data. But you don't need to do that manually. Semi-automatical method to re-enter all data of the selected cells: 1)Select the column(s) in question. 2)Apply the right number format language and any number format you like to see afterwards. 3) Editfindreplace... [More Options] [X] Current selection [X] Regular expressions Search: .+ (a dot and a plus) Replace: (ampersant) [Replace All] Caveat: If you imported dates with the wrong language option, then you may have a mix of wrong dates and text values: 01/02/14 (meant to be 1st of February but the actual cell value is 2nd of January ) 13/02/14 (meant to be 13th of February but the actual cell value is text because in US context there is no 13th month ) ViewHighlightValues[Ctrl+F8] shows the text dates in black font and the wrong dates in blue font. In this difficult case you need a formula to interchange months and days for the wrong dates and then convert the text cells into dates. =DATE(YEAR(A1);DAY(A1);MONTH(A1)) turns 1st of February into 2nd of Januaray and vice versa. -- View this message in context: http://nabble.documentfoundation.org/Formatting-a-date-tp4140660p4140844.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
