OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
Menu
Forums
Topics
FAQ
Memberlist
Usergroups
Edit Profile
PM Inbox

Links
OpenOffice.org
OOoMacros.org
OOExtras.org
OOoDocs.org
LinuxSelfhelp.com
more...

Books & Training
Getopenoffice.org
Digitaldistribution.com
8daysaweek.co.uk
more...

Search
 

Search Options

Poll question
Star Wars or Star Trek?
Star Wars [ 3 ]
Star Trek [ 2 ]
Puppies [ 0 ]
You cannot vote in polls in this forum
View Results

User of the Moment
Viewing profile :: dare
Joined: 1624 Days
Posts: 1
Location:

Forum Topics Posts
OpenOffice.org Forums
Setup and Troubleshooting
Discuss OpenOffice.org setup and installation issues
10366 38995
OpenOffice.org Writer
Discuss the OpenOffice.org word processor
22859 101327
OpenOffice.org Calc
Discuss the OpenOffice.org spreadsheet application
15918 68395
OpenOffice.org Impress
Discuss the OpenOffice.org presentation application
3091 9320
OpenOffice.org Draw
Discuss the OpenOffice.org drawing application
1221 4555
OpenOffice.org Math
Discuss the OpenOffice.org formula editor
697 2876
OpenOffice.org Base
Discuss the OpenOffice.org database features
7918 30683
OpenOffice.org Macros and API
Discuss OpenOffice.org programming issues
15071 55310
OpenOffice.org Code Snippets
Discuss and share OpenOffice.org code snippets
461 2149
Community Forums
General Discussion
Discuss anything you want
4776 23791
Site Feedback
Provide site feedback and suggestions
396 2076

How to convert DRM protected music and movies to MP4/AVI/MOV
Author: hanegaton :: Posted: Thu Sep 02, 2010 7:26 pm
Many people ask me the same question: "I purchased videos on iTunes, but I can't play them on my video player, because they are in some 'protected' M4V format that only works on iPods. How can I convert iTunes videos to MPEG or WMV format so I can play them on My portable video device such as Archos and Creative Zen?"

I searched on Google, Yahoo answers and post the question on large number of forums, unfortunately, after scouring the Web for days, I couldn't find a FREE way to convert M4V to MPEG, WMV or AVI format.

Then I tried to burn the iTunes video onto a DVD and re-import it into iTunes just like how to remove the protection from the iTunes audios (M4P) by burning it onto a CD and re-import it as mp3. I failed, cause iTunes doesnt have a DVD burning option, then I used Nero, but it still doesnt work as Nero doesnt supports M4V format.

And finally, a software solution. I came across a few kinds of converters on Google search, they are Tunebite, Daniusoft and Noteburner. When I was testing the free trials one by one, what makes me comfortable is the Daniusoft media converter .

Daniusoft Media Converter software can remove DRM from protected wmv, wma, m4p, m4v, m4a, aac files that purchased and downloaded from online music store and convert to general video and audio formats, you can enjoy playing on portable media players, such as iPod, Zune, Creative Zen, MP3 player, PSP.

Stpe 1:Download and install the DRM Removal Tool

Stpe 2: Run the software and click Add.. button to load WMA or M4A, M4B, AAC, WMV, M4P, M4V, ASF files



Step 3: Choose output formats. If you want to convert protected audio files, please select Convert audio to list; If you want to convert protected video files, please select Convert video to list.

Stpe 4: Start remove DRM and convert your DRM protected music and videos by click on Start button.

[b]Tips:


1: Daniusoft Media Converter Pro are also avaible which can not only convert DRM Video but also convert commen video/audio even HD Video to any video/audio formats.

2: More DRM Removal and other special Tools:
A: Daniusoft Digital Music Converter
B: Daniusoft WMA MP3 Converter
C: DVD Ripper for Mac
D: YouTube Downloader/Converter Pro
E: Best DVD Ripper
F: SlideShow Maker


Find out how you can Make Money (ID 18107)
Author: imranali :: Posted: Thu Sep 02, 2010 7:19 pm
Find out how you can Make Money (ID 18107)

Earn money at home with the authority
The Internet. Without the need for expertos in the field of Internet marketing, and sell their products, rather than selling face to face,
Without a large capital to start adding 9-5 job, any president watching over your head.
1. Do you want additional income
2. Do you want your head
3. Lose your job and you want more income
4. If you want money in sleep
5. Do you want to spend more time with your family
6. Do you want financial freedom

If the answer is yes to any of the above please
Let
Construction workers and our country all over the world can currently reviewing our work from the top.
We encourage you to different companies to post our work.
Join us and take the franchise in your area, or enough money.
http://tinyurl.com/2w6nt7l


Need to pull data from a string to use in a different cell
Author: webagent0011 :: Posted: Thu Sep 02, 2010 5:47 pm
Okay, I use spreadsheets but only understand some of the simple stuff and this is beyond me. Here is what I am trying to do. I want to put this string into one cell "L31203502065." And in another cell, I want 35-2-65 to be derived from it automatically. Now to make it more complicated, I need to display the last three digits minus leading zeros. So, if the last three digits are 001, I only want to see 1 in my destination field. If the last three digits are 120, I want to see 120. The idea is to allow me to enter data into only one field with other fields being populated with parts of the string automatically.
Hopefully my explanation was clear. Thanks in advance.

Stephen


vlookup issue (spaces)
Author: dieg00 :: Posted: Thu Sep 02, 2010 5:14 pm
Hey guys.

First, my english is not good, so I hope you understand what i'm going to explain.

My problem with calc occurs when data contains spaces.

For example, this is my table:

Code:

suppliers    address
bla bla         adsasd 23
bloblo          dfgfdg 34


When i use vlookup to find suppliers data everything goes excelent, except when i try to retrieve information about "bla bla" because Calc says "#N/A".... but the info is in there !!

I did a research in google looking for the same problem and i read that the solution is using "TRIM", but didn't work for me... (maybe i used in the bad way).


So, plz help me !!!!

And, thanks for read my poor english ! Laughing

Cheers,

Diego.


Setting A4 as default paper size
Author: mamboze :: Posted: Thu Sep 02, 2010 4:53 pm
Hi,

This is a pretty simple query, I guess, but i'm having trouble setting A4 rather than Letter as the default paper size. Can this be done directly without defining a template?

TIA


Welcome
Welcome to OOoForum.org, the OpenOffice.org Forum!
 
Register

Log in
Username:

Password:

Log me on automatically
 

Latest Discussion
Thu Sep 02, 2010 7:37 pm lantius
Export Form (View) to PDF...
Thu Sep 02, 2010 7:27 pm sliderule
How to convert DRM protec...
Thu Sep 02, 2010 7:22 pm sliderule
Find out how you can Make...
Thu Sep 02, 2010 7:18 pm shades49
vlookup issue (spaces)
Thu Sep 02, 2010 6:42 pm spaceghost43201
Auto filling fields

Downloads
Download OpenOffice.org (en)
OOo 2.3.0 Split Download Set
OOo 2.3.0 for Windows
OOo 2.3.0 for Linux
OOo 2.3.0 for Solaris (x86)
OOo 2.3.0 for Mac OS X (Intel)
OOo 2.3.0 for FreeBSD 6.2

Top Ten Posters
1. JohnV 7664
2. Villeroy 7649
3. jrkrideau 5936
4. David 5671
5. Hagar de l'Est 5173
6. acknak 4312
7. AndrewZ 4148
8. DannyB 4021
9. 9point9 3904
10. hol.sten 3385

Stats
Our users have posted a total of 339477 articles. We have 112466 registered users. The newest registered user is hardvour.

In total there are 96 users online:
empr333esaseor, hardvour, lantius, lightscameron, moneymakingbim, therabi, 90 Guests

This site is sponsored by:
UnitedLayer

Powered by phpBB © 2007 phpBB Group.