Pergunte aqui

Perfil de fldynamatic - atividade

2016-02-19 06:37:15 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-02-19 06:25:14 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-09-02 22:55:00 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-01-22 13:01:19 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-08-05 17:02:57 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-06-09 15:41:51 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-06-09 15:41:51 +0200 Medalha recebida  Pergunta notável (fonte)
2014-05-20 21:29:43 +0200 Medalha recebida  Pergunta notável (fonte)
2014-05-20 21:29:43 +0200 Medalha recebida  Pergunta popular (fonte)
2014-04-06 22:35:31 +0200 Medalha recebida  Pergunta notável (fonte)
2014-03-16 15:53:45 +0200 Medalha recebida  Pergunta notável (fonte)
2014-02-25 09:17:02 +0200 Medalha recebida  Pergunta notável (fonte)
2014-02-24 16:38:46 +0200 Perguntou push button macro's don't work properly

Libreoffice 4.1.1.2 OS - Win 7 Pro

I am trying to give some users access to LO and others will be using Excel 2003 and eventually 2013. I have created a push button that opens another document (created using excel 2003). I save the document in xls format. When I open it in Excel, the push button does not work (it seems to come up in edit mode) Any help would be appreciated.

2014-02-06 10:39:55 +0200 Medalha recebida  Pergunta popular (fonte)
2014-02-05 16:17:06 +0200 Perguntou freeze not working properly...?

Hello,

I have imported an excel file with macros. It seems to work OK except for 2 things. 1. the macro buttons don't work - I guess I can rewite them in LO. 2. Freeze frames does not seem to work properly. When I sort by date, the whole of the sort row goes to the bottom and messes up the spreadsheet.

Can this problem of freeze frames be fixed? I cannot seem to attach the calc file so I have uploaded it to mailbigfile - here is the link http://mbf.cc/u6Nzti

2014-02-05 16:06:21 +0200 Medalha recebida  Palpiteiro
2014-02-05 16:06:21 +0200 Resposta comentada how do i create buttons that link to calc files?

great - thanks!

2014-02-05 16:05:54 +0200 Medalha recebida  Pergunta popular (fonte)
2014-02-05 12:08:23 +0200 Resposta comentada how do i create buttons that link to calc files?

Thanks - Idid that but nothing happens when I press the button

2014-02-05 10:16:49 +0200 Resposta comentada Calc text import not working correctly

Thanks I tried that earlier - I think I'll have to give up on this unless LO decide to support the MS DOS (PC-8) format and also enable one to merge columns on import like in excel

2014-02-04 15:57:45 +0200 Perguntou how do i create buttons that link to calc files?

Hi,

I am trying to create buttons which once clicks open up another calc file. I tried to use the form designer. I cannot get the labels to be renamed to what I need them to. I need to simply create a button, have text on the button called fred and once clicked, it will open up fred's calc file. It appears that the form designer has never been tested within calc?

2014-02-04 12:49:59 +0200 Medalha recebida  Pergunta popular (fonte)
2014-02-04 12:26:49 +0200 Resposta comentada Calc text import not working correctly

Thanks for the tip Mario. The file is a combination of TAB and spaces as delimiters by the looks of things.

2014-02-04 11:48:28 +0200 Medalha recebida  Entusiasta
2014-02-03 15:20:56 +0200 Resposta comentada Calc text import not working correctly

I thought I had enclosed the file - but I can't seem to see it - I have copied and pasted the first few lines - but I'm not sure this will help you much - so I have uploaded onto mailbigfile.com . The link is here http://mbf.cc/IfKNUB - it is a text file called mfg9_8.txt. Thanks for any assistance you can offer me.

2014-02-03 15:06:07 +0200 Resposta comentada Calc text import not working correctly

Item Number Description Customer Name Order Sch Quantity Required


550116859001 SEALKIT PLUS WASHER 00600109 AGCO INTERNATIONAL GmbH(FR SO645934 Fin 18.0 13/01/14 551101326210032 MOTOR 16.8LC SW.VALVE SNM2 VITON SHAFT SE 00603001 Alexander Dennis Ltd (Prod SO627694 Sch 14.0 13/01/14 550LG32890002 SEALPACK 32890 00600109 AGCO INTERNATIONAL GmbH(FR SO646113 Fin 9.0 14/01/14

2014-01-31 12:04:48 +0200 Resposta comentada Calc text import not working correctly

I did try that but no joy I'm afraid. Excel recognises it as an MS DOS (PC-8) format and translates it well. This is quite critical as it means I will have to upgrade more desktops to Office2013 and I would rather not do that.

Also, the way Excel handles these imports is really nice - you can also during the import join 2 columns making it easy to create a result you desire. How can I request this as a feature in LO?

2014-01-29 21:35:07 +0200 Medalha recebida  Pergunta notável (fonte)
2014-01-29 11:23:05 +0200 Medalha recebida  Pergunta popular (fonte)
2014-01-29 10:06:05 +0200 Pergunta comentada Need help with MS Access 2003 Form

Thanks for you inputs.

2014-01-28 14:20:57 +0200 Pergunta comentada Calc text import not working correctly

Hi ,

I'm using LO 4.1.1.2. I have enclosed the file. I tried to import it - so far the best result I have achieved is by ticking the "TAB" "SPACE" and merge delimiters boxes. But even then it is not perfect. Excel seems to handle it fine.

2014-01-28 14:20:21 +0200 Medalha recebida  Editor (fonte)
2014-01-28 08:29:44 +0200 Medalha recebida  Pergunta popular (fonte)
2014-01-27 16:57:54 +0200 Perguntou Calc text import not working correctly

Hello,

I am trying to import this text file - but it doesn't seem to work correctly.

Can you please help?

2014-01-23 14:40:02 +0200 Perguntou Need help with MS Access 2003 Form

Hi

I need to convert an Access form to Base ( or import it). The form has several push buttons that contain links to different Excel Spreadsheets. So for example if I push the button for fred, it will launch Excel (later to become Calc) and open the spreadsheet containing Fred's data. How can I recreate this using base?

2014-01-15 13:07:23 +0200 Resposta comentada Help with sort macro button

great - this works well - Thank you so much!!

2014-01-14 17:23:43 +0200 Perguntou Help with sort macro button

Hi,

I am very close to switching several of our users from Office 2003 to LO. I am struggling with one excel file. Bascially it has 3 Macro push buttons that don't work one of which is a sort. I need to sort out A5 to AC49 by Column C and create a push button for this. I don't have the time to learn the Macro language.

Could some one please help me? Thanks Francis