I have a process that I do in a spreadsheet, and part of the process is converting a text date field that is in the MM/YY format?? from the website that I download 487 records. The process to convert it to the real date field that it should have been is: Text date is in G1, so in L1 I use the formula. =eomonth(date(right(g1,2),left(g1,2),1),0). That gives me the proper last day of the month as the expiration date.
He is my problem. When I record as a macro, entering the formula doesn't get included in the macro. All the other steps do, but not the formula??? I have discovered, and I can record the macro, but instead of putting in the formula as it should be entered, I type it without the = at the beginning. This the Macro recorder handles with no problem, and it works, just doesn't put the correct formula. I can then edit the Macro, and add the =, and it works perfectly?? (This is with the latest libreoffice 5.2.4.2 under linux. Don't know if it does the same in windows? I've also had an issue using Format Cell. I pops up with a message about wanting to install a Russian font?? Even with an empty spread sheet. Doesn't matter if I use menu format cell or right-click format cell. In running calc with strace I get these lines. ** (soffice:19050): DEBUG: InstallFontconfigResources method failed ** (soffice:19050): DEBUG: InstallFontconfigResources problem : did not agree to search The first one is what I think is the error that causes the asking to install russian font, and the second is when I select close. It I let it search, it come back with it finds no font? Thanks. +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com 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 ABC 16613838.513356 | EINSTEIN 123793630.788695 ROSETTA 54887642.050834 | SETI 97748790.390510 -- 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