Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

On Tue, Mar 3, 2015 at 8:24 AM, <> wrote:

 Thank you, Allan for the prompt reply, ...
The sample is simply enough, I belive, so the point is how to proceed it
to get output in several seperate SS or database tables, preserving
the sequention in row position.

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.

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"


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.