[libreoffice-users] Re: time and date difference
hello, wonderful, the solution Michael D. Setzer II gave is amazing! Many thanks! -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147109.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: time and date difference
Hello and thanks you all for the kind suggestions that helped me a lot.. I have found some points: -first of all, I don't now why but I had to use . instead of : as separator for time.. 15:30 won't be accepted while 15.30 is ok... this even if cells were formatted as time maybe this is due to my regional settings -for the circular reference mentioned by Brian Barker it was a mistake copying the formula from the sheet to the webpage.. sorry for this.. Anyway, changing the separator works fine -when I have: E14: 23/04/15 15.30 E15: 25/04/15 16.20 both E16: =E15-E14 and E16 = DAYS(E15;E14) give the integer number 2.0 but using the first formula and changing format to hours and back to numbers I have 2.034 that should be correct.. thanks again! -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147106.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: time and date difference
Hello and thanks you all for the kind suggestions that helped me a lot.. I have found some points: -first of all, I don't now why but I had to use . instead of : as separator for time.. 15:30 won't be accepted while 15.30 is ok... this even if cells were formatted as time maybe this is due to my regional settings -for the circular reference mentioned by Brian Barker it was a mistake copying the formula from the sheet to the webpage.. sorry for this.. Anyway, changing the separator works fine -when I have: E14: 23/04/15 15.30 E15: 25/04/15 16.20 both E16: =E15-E14 and E16 = DAYS(E15;E14) give the integer number 2.0 but using the first formula and changing format to hours and back to numbers I have 2.034 that should be correct.. thanks again! -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147108.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: time and date difference
Not sure if you want to just display the value as number as a message B12 contains the later date - earlier date =INT(B12/(60)) Hours INT(MOD(B12+0.0001,60)) Minutes Creates This 48 Hours 50 Minutes Had to add the 0.0001 otherwise was showing 49 minutes when int used. On 24 Apr 2015 at 3:49, sserra wrote: Date sent: Fri, 24 Apr 2015 03:49:06 -0700 (MST) From: sserra simone.se...@cogne.com To: users@global.libreoffice.org Subject:[libreoffice-users] Re: time and date difference hello, wonderful, the solution Michael D. Setzer II gave is amazing! Many thanks! -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147109.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 +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +--+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 28512493.011262 | SETI50011275.211265 ABC 16613838.513356 | EINSTEIN58725353.615700 -- 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] time and date difference
hello everyone, I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating time differences.. I would like to calculate the time difference in hours between the following date/times: E14 = 23/04/2015 15:30 E15 = 25/04/2015 16:20 E16 = DAYS(E15;E14) But I get a value error so I split data: F14 = 23/04/2015 F15 = 25/04/2015 F16 = DAYS(F15;F14) --- Ok, I get 2, multiply x 24 = 48h and it's fine then for the hours G14 = 15:30 G15 = 16:20 G16 = (G15G14)+G15-G16 (as suggested by the wiki: https://help.libreoffice.org/Calc/Calculating_Time_Differences) but again I have a value error.. does anyone knows how can I solve this?? -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099.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] time and date difference
At 01:46 24/04/2015 -0700, Simone Serra wrote: I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating time differences. I would like to calculate the time difference in hours between the following date/times: E14 = 23/04/2015 15:30 E15 = 25/04/2015 16:20 E16 = DAYS(E15;E14) But I get a value error ... This should work (if your date locale is set appropriately) if these are genuine date values, i.e. numbers formatted as DD/MM/ HH:MM - but not if the cell contents are text values. so I split data: F14 = 23/04/2015 F15 = 25/04/2015 F16 = DAYS(F15;F14) --- Ok, I get 2, multiply x 24 = 48h and it's fine This mean that you *do* now have these values as genuine dates, not text. then for the hours G14 = 15:30 G15 = 16:20 G16 = (G15G14)+G15-G16 (as suggested by the wiki: https://help.libreoffice.org/Calc/Calculating_Time_Differences) but again I have a value error.. If you really have put a formula including G16 into G16, then you have a circular reference, and you may see Error 522. does anyone knows how can I solve this?? If you use =(G15G14)+G15-G14 it should work (whether you have times or text). It's important to understand the effect of cell formatting in spreadsheets. When you type something into a cell, the value may be converted and the cell formatting may be changed. Such changes may not be immediately evident, but you need to appreciate them if you are to see why formulae work or don't work. There are two facilities that may help: o Unless you have specifically set cell alignment, text values will be left-aligned and numbers (including date/times) will be right-aligned. o Go to View | Value Highlighting (or Ctrl+F8). Text values show in black and numbers (including date/times) in blue. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] time and date difference
Did the work below, but then came up with a simpler option. Converts difference to minutes =(E15-E14)/TIME(0,1,0) Above Answer ANSWER/60 =((E15-E14)/TIME(0,1,0))/60 Above Answer INT(ANSWER/60) gives full hours =INT(((E15-E14)/TIME(0,1,0))/60) Above Answer MOD(ANSWR,60) gives minutes left =MOD(((E15-E14)/TIME(0,1,0)),60) Original way of doing it. E14 = 04/23/15 03:30 PM E15 = 04/25/15 04:20 PM E16 = 48 E17 = 50 E18 = 0 E19 = 50 E20 = 48 E21 = 48.83 Formula in E16 to calc Hours in full days =int(e15-e14)*24 Calculates the number of minuts left E17 = =MOD((E15-E14),1)/TIME(0,1,0) Calculate number of Hours in partial day E18 = =INT(E17/60) Calc Remain Minutes E19 = =MOD(E17,60) Calc Total Hours E20 = =E16+E18 Calc Hours with fraction. E21 = =E20+E19/60 Added 12 hours to test results. 04/23/15 03:30 PM 04/26/15 04:20 AM 48 Full Hours 770 Extra Minutes 12 Hours 50 Minutes 60 Total Hours 60.83 On 24 Apr 2015 at 1:46, sserra wrote: Date sent: Fri, 24 Apr 2015 01:46:12 -0700 (MST) From: sserra simone.se...@cogne.com To: users@global.libreoffice.org Subject:[libreoffice-users] time and date difference hello everyone, I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating time differences.. I would like to calculate the time difference in hours between the following date/times: E14 = 23/04/2015 15:30 E15 = 25/04/2015 16:20 E16 = DAYS(E15;E14) But I get a value error so I split data: F14 = 23/04/2015 F15 = 25/04/2015 F16 = DAYS(F15;F14) --- Ok, I get 2, multiply x 24 = 48h and it's fine then for the hours G14 = 15:30 G15 = 16:20 G16 = (G15G14)+G15-G16 (as suggested by the wiki: https://help.libreoffice.org/Calc/Calculating_Time_Differences) but again I have a value error.. does anyone knows how can I solve this?? -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099.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 +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +--+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 28512493.011262 | SETI50011275.211265 ABC 16613838.513356 | EINSTEIN58725353.615700 -- 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: time and date difference
Am 24.04.2015 um 10:46 schrieb sserra: hello everyone, I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating time differences.. I would like to calculate the time difference in hours between the following date/times: E14 = 23/04/2015 15:30 E15 = 25/04/2015 16:20 E16 = DAYS(E15;E14) First of all , check if both cells E14 and E15 have numbers. menu:ViewHighlightValues(Ctrl+F8). If both values appear in blue font: =E15-E14 gives the difference in days. -- 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: time and date difference
Am 24.04.2015 um 10:46 schrieb sserra: E14 = 23/04/2015 15:30 E15 = 25/04/2015 16:20 E16 = DAYS(E15;E14) [...] does anyone knows how can I solve this?? did you try E16: =E15-E14 ? (IIRC set cell format to [hh] to display difference in hours) Regards, Nino -- 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: time and date difference
Am 24.04.2015 um 12:33 schrieb sserra: Hello and thanks you all for the kind suggestions that helped me a lot.. I have found some points: -first of all, I don't now why but I had to use . instead of : as separator for time.. 15:30 won't be accepted while 15.30 is ok... this even if cells were formatted as time maybe this is due to my regional settings You are working with an Italian locale. ToolsOptionsLanguageSettingsLanguages = Italian(Italy) -for the circular reference mentioned by Brian Barker it was a mistake copying the formula from the sheet to the webpage.. sorry for this.. Anyway, changing the separator works fine -when I have: E14: 23/04/15 15.30 E15: 25/04/15 16.20 both E16: =E15-E14 and E16 = DAYS(E15;E14) give the integer number 2.0 but using the first formula and changing format to hours and back to numbers I have 2.034 that should be correct.. thanks again! The cell value remains 2 (days) displayed as 48:00 (hours). If you want to calculate with hours, multiply the day value by 24. -- View this message in context: http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147106.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] display
Try here: http://www.intel.com/support/graphics/sb/CS-034107.htm On 4/23/2015 2:24 PM, Thomas Blasejewicz wrote: On 2015/04/23 23:06, Paul D. Mirowsky wrote: Screen tearing issue with NVidia may be resolved by changing Vertical Sync to Adaptive. Start video at URL below at 40 seconds. https://www.youtube.com/watch?v=mFRpnQ09_LA The video is from 2013 and may not quite match, but you get the idea. Hope this helps. On 4/22/2015 11:17 AM, Thomas Blasejewicz wrote: Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Am I correct assuming, that this applies ONLY to NVidia graphic cards? My computer has an Intel HD Graphics 4600 and I cannot find anywhere a setting called vertical sync Thomas -- 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] column limit in libreoffice 4.3.something
Hi :) Have you tried Gnumeric for spreadsheet work? It is a dedicated spreadsheet program rather than being part of a suite so there are quite a few advantages to it for serious spreadsheeting work. Regards from Tom :) On 24 April 2015 at 08:39, yahoo-pier_andreit pier_andr...@yahoo.it wrote: On 04/23/2015 08:53 PM, Luuk wrote: On 23-4-2015 20:39, yahoo-pier_andreit wrote: today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier - Please, define 'so low' i see 1024 columns in 4.4.something and also in 4.1.something I exported a 2kx2k dataset in csv from a database to be eaten by a python program and I can open it in excel but non in libreoffice calc, and this is bad... :-) :-) - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) I wasn't there when I posted and i supposed that a parameter like numbers of columns doesn't change in subversions... :-) :-) -- 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: column limit in libreoffice 4.3.something
Am 24.04.2015 um 14:08 schrieb Tom Davies: Hi :) Have you tried Gnumeric for spreadsheet work? It is a dedicated spreadsheet program rather than being part of a suite so there are quite a few advantages to it for serious spreadsheeting work. Regards from Tom :) Since Gnumeric is a more serious toy than the somewhat baroqe toys Calc and Excel, it supports 65.536x256 columns (2^15 x 2^8). This used to be the standard for 3 decades (80ies until 2007). On a Linux system it takes no more than 3 seconds to check this out because Gnumeric starts in less than 2 seconds. -- 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: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Hi Tom: I've wanted to report it as a bug, but first I decided to ask the community, in case I 'm the the origin of the failure . Now I want to ask you how exactly can I report it to be treated as a bug by the dev. community ? Thanks. (long live LibO!) -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147116.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: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
m.a.riosv wrote: I think Piet have pointed to the source of the problem. Seems in several sheet there are cells formatted out data range. Sheet 'Análisis Pisos' seems empty but has a lot of empty comments, better delete the sheet. For a first cleaning, to do in every sheet: - Ctrl+End goes to bottom-right corner of range with data in a sheet. - Use Ctrl-M to clear any direct format for the columns right and rows down of it. Miguel Ángel. I did some more experimenting with Sheet 7 (ANALISIS PISOS IMPORTADOS). First I selected all columns from M to the end and deleted all cells (everything) in it. That helped. But then I saw that several rows (3723, 3897, 3972-3984, 4040-4046, 4090. 8375, 8378, 10415-10417, 10238) still had all their cells listed individually. It appears that these complete rows have the font set to Times New Roman 10pt, whereas the default font is Arial. So I also dir a Ctrl-M on these columns and that dramatically decreased the size of Sheet 7. The file saved by MS Excel has special commands to set the format/style of a row, so that it does not have to specify each individual cell. So that is an optimisation that the exporter misses for some reason. I also tried this with a small file and there it did optimize it. I guess if you do this for all the sheets the file may become much smaller. That still leaves improvement possibilities in the exporter. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
Should Delete empty rows/columns be a new command on a sheet basis. Sheet basis meaning you see the results of command before saving and can undo. I'm not sure it would be good a default unless the command would check formulas to make sure empty cells are not referenced. On 4/23/2015 7:57 PM, m.a.riosv wrote: I think Piet have pointed to the source of the problem. Seems in several sheet there are cells formatted out data range. Sheet 'Análisis Pisos' seems empty but has a lot of empty comments, better delete the sheet. For a first cleaning, to do in every sheet: - Ctrl+End goes to bottom-right corner of range with data in a sheet. - Use Ctrl-M to clear any direct format for the columns right and rows down of it. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147086.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: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?
One possibility comes to mind as to why empty cells are saved. If formatting has been applied to the empty cells then they must be saved even if no values are currently stored in those cells. As a trivial example consider the four cell range A1:B2 which contain no values but the four cells are formatted to display numbers as currency. How could that formatting be saved without saving those empty cells? -- Jim -Original Message- From: Cley Faye cleyf...@gmail.com To: RamonTavarez ramontava...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Thu, 23 Apr 2015 13:47 Subject: Re: [libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion? That's interesting. Examining the beginning of one of the big sheets in both case, we see that LibreOffice is *very* verbose with what it save. If I understand it correctly, LO save informations about *every* cells, including empty ones. Which is very odd, since it does not do it with *every* sheets. This does not explain why MSO have to repair the files though. Maybe the devs would be interested in this test case. -- Cley Faye http://cleyfaye.net 2015-04-23 20:12 GMT+02:00 RamonTavarez ramontava...@gmail.com: Check the post, I've uploaded the requested file. Thanks for your interest. Regards *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail Archive] ml-node+s969070n4147063...@n3.nabble.com wrote: Discussion about open formats aside, I've looked at the file and it looks like when saving as xlsx each sheet grow huge (some goes to ~20MB before compression). Could you also post the xlsx file obtained when saving with MSO, for comparison? My guess is that either LO saves *a lot* of empty/dummy cells, or that it saves in an older xlsx format that is less compact. btw this is only a by curiosity request, but it could help the dev pinpoint an issue if my first guess is correct. -- Cley Faye http://cleyfaye.net 2015-04-23 17:28 GMT+02:00 Tom Davies [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=0: Hi :) Yeh, i don't know a good way around that :( other than the way you already use! :)) People used to be quite happy with the idea of downloading Adobe Acrobat to read Pdfs with. It used to be that almost any website that shared any kind of document tended to only have them as Pdfs and also then 'had to' have a button to help people download and install an Adobe Pdf Reader. We hardly see any of that these days but that is quite a recent change. There were objections from people working in the council, or other government offices or in big companies that they couldn't install anything and thus couldn't use the format that everyone else seemed to be using so much. Now they seem to use Pdf more than everyone else, and even demand that other people use it! Regards from Tom :) On 23 April 2015 at 16:08, Ramon Tavarez [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=1 wrote: Hi: Thanks for your attention. The fact with this file is that can't be supported by .XLS format, and my coworkers doesn't work with LibO, and that is the only way I can use to keep in touch with them and their jobs. It may be a pain .. ... ... , but while it work I'll keep using this method to share my jobs with them! In use LibO for every document I create, even I update every version of LibO as the module for my Linux distro: Porteus. On the other hand,I can understand the situation with MSOffice and how they refuse the OpenDocument formats, but I still worry about the big file size for those files not supported by the classical file type. This can lead erroneously, as you said, to people to believe that everyone else made bad spreadsheet programs and everyone should stick with MS. Thanks. *Ramón E. Tavárez B.* On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies [hidden email] http:///user/SendEmail.jtp?type=nodenode=4147063i=2 wrote: Hi :) The XlsX, and other OOXML formats are notoriously unreliable. Each different version of MS Office uses slightly different versions. There are at least 3 different transitional versions of the format and they are not always compatible with each other. If you take the XlsX that was saved by MS Office 2013 and try opening it in another version of MS Office, say 2010 or 2007, or even 365 then you may well find it's been opened in Compatibility Mode or even that it doesn't work at all in extreme cases. Chances are that some things will have moved around or vanished, especially if you have anything in a frame (such as images). It makes a bit of sense that a file created with newer
Re: [libreoffice-users] selecting cells in calc sheet
Pete, You still leave a lot unsaid such as whether the result is in a single fixed location, what if anything is in the even numbered rows of column C, whether any other column can be used for identification purposes, what if anything is below the most recent month's data, etc. You imply that there's no more than eight months worth of data so I guess C17 ends the series. Without some of the information vacuum filled I'm not sure what we can do for you. -- Jim -Original Message- From: Piet van Oostrum p...@vanoostrum.org To: pete nikolic pg.nikol...@gmail.com Cc: users@global.libreoffice.org Sent: Fri, 24 Apr 2015 14:20 Subject: Re: [libreoffice-users] selecting cells in calc sheet pete nikolic wrote: if we start as will be the case C3 will contain say 50 (the actual dates are of little importance ) a month later C5 will be say 47 and so on every month the next cell would be C7 then C9 then C11 what i need is to be able to automatically pick the last 3 cells containing data so when C9 is filled in then it needs to automatically choose C9 C7 C5 and add them then divide by 3 then subtract a variable defined on the day .. Hope this makes it a little clearer That would then be: IF(ISBLANK(C7);;AVERAGE(C3;C5;C7)-30) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] display
2015-04-22 17:17 GMT+02:00 Thomas Blasejewicz ny...@hb.tp1.jp: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. So, I would LOVE to believe, that there cannot be any sort of insufficient power. IS there a trick to convince the display to work smoothly??? Thank you. Thomas Thomas, this is a tad off-topic, but since you mentioned that «Windows 8.1 (= a nightmare !!!)», I thought I'd suggest two simple steps to tame the beast : 1. Install Classic Shell from *classicshell.net http://classicshell.net* (elect the Windows 7 interface and change the start button), and 2. Deactivate the superfluous Lockscreen by following the steps found here : *http://www.howtogeek.com/134620/how-to-disable-the-lock-screen-on-windows-8-without-using-group-policy* http://www.howtogeek.com/134620/how-to-disable-the-lock-screen-on-windows-8-without-using-group-policy */* While not, alas, quite as good as dumping Windows altogether and installing, e g, Linux Mint 17.1 instead, it should suffice to turn those nightmares into relatively sweet dreams. I know it has for many retirees here in Stockholm whom we help with computer problems Henri -- 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] column limit in libreoffice 4.3.something
Try importing into Base as csv, pay particular attention formatting on this screen matches your csv. During import keep an eye out for errors. Stop at error, look at last record imported in table. Using text editor, fix that or next record. Delete Base database and re-iterate until no errors found. When complete import occurs, copy table to Calc. This works fairly well for finding import errors and copying from Base to Calc is usually a clean process. Just ran my first Firebird test and it does import much fast than HSQL1.8 Yes, I did have problems importing a csv directly into Calc which showed non-english character set. Hope this helps. On 4/24/2015 3:39 AM, yahoo-pier_andreit wrote: On 04/23/2015 08:53 PM, Luuk wrote: On 23-4-2015 20:39, yahoo-pier_andreit wrote: today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier - Please, define 'so low' i see 1024 columns in 4.4.something and also in 4.1.something I exported a 2kx2k dataset in csv from a database to be eaten by a python program and I can open it in excel but non in libreoffice calc, and this is bad... :-) :-) - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) I wasn't there when I posted and i supposed that a parameter like numbers of columns doesn't change in subversions... :-) :-) -- 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] time and date difference
On 4/24/2015 4:46 AM, sserra simone.se...@cogne.com wrote: hello everyone, I am using LibreOffice Version: 4.3.0.4 Why? 4.3.6 is latest 4.3.x series... It never amazes me the number of people who chase bugs using a dated release - especially when it is the very first release in a major new series... -- 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] column limit in libreoffice 4.3.something
On 04/23/2015 08:53 PM, Luuk wrote: On 23-4-2015 20:39, yahoo-pier_andreit wrote: today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier - Please, define 'so low' i see 1024 columns in 4.4.something and also in 4.1.something I exported a 2kx2k dataset in csv from a database to be eaten by a python program and I can open it in excel but non in libreoffice calc, and this is bad... :-) :-) - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) I wasn't there when I posted and i supposed that a parameter like numbers of columns doesn't change in subversions... :-) :-) -- 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] selecting cells in calc sheet
At 21:00 24/04/2015 +0100, Pete Nikolic wrote: I need to be able to select the last 3 in a series of cells that change on a weekly basis so in week 1: there would be 1 cell - no action week 2: 2 cells - no action week 3: 3 cells - sum three cells week 4: 4 cells - sum last three week 5: 5 cells - sum last three and so it goes on for 8 weeks always just summing the last 3 cells in the series then divide by 3 subtract 30 = result .. I'm guessing that you want separate results for each week, not just a single result - so that in week 5, for example, you would have three results, not one. Let's imagine your data is in column A, starting in A1. In B3, insert: =AVERAGE(A1:A3)-30 and fill down the column. If you want to suppress the display in B cells for which there is not yet an A-cell vale, try something like: =IF(A3=0;;AVERAGE(A1:A3)-30) I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] selecting cells in calc sheet
On Fri, 24 Apr 2015 21:52:47 +0100 Brian Barker b.m.bar...@btinternet.com wrote: At 21:00 24/04/2015 +0100, Pete Nikolic wrote: I need to be able to select the last 3 in a series of cells that change on a weekly basis so in week 1: there would be 1 cell - no action week 2: 2 cells - no action week 3: 3 cells - sum three cells week 4: 4 cells - sum last three week 5: 5 cells - sum last three and so it goes on for 8 weeks always just summing the last 3 cells in the series then divide by 3 subtract 30 = result .. I'm guessing that you want separate results for each week, not just a single result - so that in week 5, for example, you would have three results, not one. Let's imagine your data is in column A, starting in A1. In B3, insert: =AVERAGE(A1:A3)-30 and fill down the column. If you want to suppress the display in B cells for which there is not yet an A-cell vale, try something like: =IF(A3=0;;AVERAGE(A1:A3)-30) I trust this helps. Brian Barker Hi Brian oklets see .. if we start as will be the case C3 will contain say 50 (the actual dates are of little importance ) a month later C5 will be say 47 and so on every month the next cell would be C7 then C9 then C11 what i need is to be able to automatically pick the last 3 cells containing data so when C9 is filled in then it needs to automatically choose C9 C7 C5 and add them then divide by 3 then subtract a variable defined on the day .. Hope this makes it a little clearer Thanks Pete . -- Illegitimi non carborundum . ro for the purists out there Noli nothis permittere te terere. -- 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] selecting cells in calc sheet
Hi Folks .. I need to be able to select the last 3 in a series of cells that change on a weekly basis so i week 1 there would be 1 cell no action week 2 2 cells no action week 3 3 cell sum three cells week 4 4 cells sum last three week 5 5 cells sum last three and so it goes on for 8 weeks always just summing the last 3 cells in the series then divide by 3 subtract 30 = result .. Pete -- Illegitimi non carborundum . ro for the purists out there Noli nothis permittere te terere. -- 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] selecting cells in calc sheet
pete nikolic wrote: Hi Folks .. I need to be able to select the last 3 in a series of cells that change on a weekly basis so i week 1 there would be 1 cell no action week 2 2 cells no action week 3 3 cell sum three cells week 4 4 cells sum last three week 5 5 cells sum last three and so it goes on for 8 weeks always just summing the last 3 cells in the series then divide by 3 subtract 30 = result .. That is rather vague. Where is the week number? How is the series represented? What do you want to do with the result? -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] selecting cells in calc sheet
pete nikolic wrote: if we start as will be the case C3 will contain say 50 (the actual dates are of little importance ) a month later C5 will be say 47 and so on every month the next cell would be C7 then C9 then C11 what i need is to be able to automatically pick the last 3 cells containing data so when C9 is filled in then it needs to automatically choose C9 C7 C5 and add them then divide by 3 then subtract a variable defined on the day .. Hope this makes it a little clearer That would then be: IF(ISBLANK(C7);;AVERAGE(C3;C5;C7)-30) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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
