first step forward

users
#1

Hello,

Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2.

I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question:

Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)?

I'm pretty sure, but to get forward I've attached simple sample as below.

Is the spreadsheet, or rather is the database the proper tool?

Could you proceed the sample, please?

Best regards,

Andrew Anddos

#2

Hi :slight_smile:
You might find this website more useful;
http://pl.libreoffice.org/

Also the Polish language mailing list might be easier as you can use
Polish;
https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish
or if your main language is something else then there is probably a
different mailing list for that too.

I think most people use spreadsheets (ie Calc or Excel) to create an array
of numbers.

However if this for bookkeeping then you might find it better to use a
specialist tool such as GnuCash (also "Libre" and free OpenSource
program).

It really depends on what you are trying to do. If you think a database
might be better then using Base as a "front-end" with an "external
back-end" such as MySql/MariaDb, Postgresql or something else is probably a
good idea. Some people have a go with a spreadsheet first as part of the
planning process before designing a database.

There is a book about how to use Base but it is primarily only available in
German. The English one is quite outdated now (already! Time flies!) and
the translator teams are often even smaller and mostly have only just begun
to think about translating the "Published Guides". Of course they do have
the "built-in help" but it sounds like you really need something a bit more
hefty to get a good overview. If you can find it in an appropriate
language then you might like the "Getting Started Guide"

Regards from
Tom :slight_smile:

#3

Hi Tom,

would you mind sending me the link to this book in german or is it only
available in hardcopy?

Thanks

Ralf

#4

Hi :slight_smile:
The link to the English translation is;
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook

The original in German is;
https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base_.28Datenbank-Programm.29

Regards from
Tom :slight_smile:

#5

Unfortunately I don't understand your spreadsheet.

I've added the mail list address back to the message. Please reply to mail
list. That way more (and better) brains than mine can then give their
feedback too.

I did edit your spreadsheet and put a copy here.
https://docs.google.com/spreadsheets/d/1xusCFUw5wy62IOcRJTTTfCQxtAcnyccXJuMHUilZ9T8/edit?usp=sharing

In my copy I've highlighted all the number/value "pairs" and have some
questions based on that.

First, some numbers aren't paired with anything. What do they belong with?
Second, you refer to the values as an array but, given the organization of
the spreadsheet I don't see any arrays. What arrays are you referring to?
Cell addresses would be helpful to understand.

Regarding your question about numbers of rows and columns I believe the max
number of rows is 1,000,000 and max columns is 1024.

Your example for "A" target shows the one positive value for "A" in one
column and the negative values for "A" in a different column. In the target
the order of values by row is the same as in the source.

Which gets me back to I still don't understand what you need to accomplish.

Answers to a few questions may help me:
- is the goal to rearrange the "Raw Alphanumerical" so it is organized like
the target?
- is there a specific repeatable method for why data is where it is in the
"Raw Alphanumerical" and if there is what are the rules? Knowing the rules
would go a long way to planning how to rearrange "Raw" into "Target"

-Alan

#6

Hi Tom,

many thanks for the links.

Ralf